cstm: artefacts: 108,463 rows where sorted by ObjectName

108,463 rows sorted by ObjectName

descending

Link	rowid	artifactNumber	GeneralDescription	Manufacturer	ManuCountry	NumberOfComponents	ArtifactFinish	ContextCanada	ContextFunction	ContextTechnical	group1	category1	subcategory1	material	image	thumbnail
1119	1119	1966.0686.017				91
1120	1120	1966.0686.018				91
1121	1121	1966.0686.019				91
1122	1122	1966.0686.020				91
1123	1123	1966.0686.021				91
1124	1124	1966.0686.022				91
1125	1125	1966.0686.023				91
1126	1126	1966.0686.024				91
1127	1127	1966.0686.025				91
1128	1128	1966.0686.026				91
1129	1129	1966.0686.027				91
1130	1130	1966.0686.028				91
1131	1131	1966.0686.029				91
1132	1132	1966.0686.030				91
1133	1133	1966.0686.031				91
1134	1134	1966.0686.032				91
1135	1135	1966.0686.033				91
1136	1136	1966.0686.034				91
1137	1137	1966.0686.035				91
1138	1138	1966.0686.036				91
1139	1139	1966.0686.037				91
1140	1140	1966.0686.038				91
1141	1141	1966.0686.039				91
1142	1142	1966.0686.040				91
1143	1143	1966.0686.041				91
1144	1144	1966.0686.042				91
1145	1145	1966.0686.043				91
1146	1146	1966.0686.044				91
1147	1147	1966.0686.045				91
1148	1148	1966.0686.046				91
1149	1149	1966.0686.047				91
1150	1150	1966.0686.048				91
1151	1151	1966.0686.049				91
1152	1152	1966.0686.050				91
1153	1153	1966.0686.051				91
1154	1154	1966.0686.052				91
1155	1155	1966.0686.053				91
1156	1156	1966.0686.054				91
1157	1157	1966.0686.055				91
1158	1158	1966.0686.056				91
1159	1159	1966.0686.057				91
1160	1160	1966.0686.058				91
1161	1161	1966.0686.059				91
1162	1162	1966.0686.060				91
1163	1163	1966.0686.061				91
1164	1164	1966.0686.062				91
1165	1165	1966.0686.063				91
1166	1166	1966.0686.064				91
1167	1167	1966.0686.065				91
1168	1168	1966.0686.066				91
1169	1169	1966.0686.067				91
1170	1170	1966.0686.068				91
1171	1171	1966.0686.069				91
1172	1172	1966.0686.070				91
1173	1173	1966.0686.071				91
1174	1174	1966.0686.072				91
1175	1175	1966.0686.073				91
1176	1176	1966.0686.074				91
1177	1177	1966.0686.075				91
1178	1178	1966.0686.076				91
1179	1179	1966.0686.077				91
1180	1180	1966.0686.078				91
1181	1181	1966.0686.079				91
1182	1182	1966.0686.080				91
1183	1183	1966.0686.081				91
1184	1184	1966.0686.082				91
1185	1185	1966.0686.083				91
1186	1186	1966.0686.084				91
1187	1187	1966.0686.085				91
1188	1188	1966.0686.086				91
1189	1189	1966.0686.087				91
1190	1190	1966.0686.088				91
1191	1191	1966.0686.089				91
1192	1192	1966.0686.090				91
1193	1193	1966.0686.091				91
1195	1195	1966.0687.002				18
1196	1196	1966.0687.003				18
1197	1197	1966.0687.004				18
1198	1198	1966.0687.005				18
1199	1199	1966.0687.006				18
1200	1200	1966.0687.007				18
1201	1201	1966.0687.008				18
1202	1202	1966.0687.009				18
1203	1203	1966.0687.010				18
1204	1204	1966.0687.011				18
1205	1205	1966.0687.012				18
1206	1206	1966.0687.013				18
1207	1207	1966.0687.014				18
1208	1208	1966.0687.015				18
1209	1209	1966.0687.016				18									http://source.techno-science.ca/artifacts-artefacts/images/1966.0687.016.aa.cs.png	http://source.techno-science.ca/artifacts-artefacts/images/1966.0687.016.aa.cs.thumb.png
1210	1210	1966.0687.017				18									http://source.techno-science.ca/artifacts-artefacts/images/1966.0687.017.aa.cs.png	http://source.techno-science.ca/artifacts-artefacts/images/1966.0687.017.aa.cs.thumb.png
1211	1211	1966.0687.018				18									http://source.techno-science.ca/artifacts-artefacts/images/1966.0687.018.aa.cs.png	http://source.techno-science.ca/artifacts-artefacts/images/1966.0687.018.aa.cs.thumb.png
1215	1215	1966.0690.002	PAPER & INK.	Unknown	Canada	2	BLACK INK ON BEIGE OR OFF-WHITE PAPER.	THIS ITEM COLLECTED AS AN EXAMPLE OF DOCUMENTS USED BY NOVA SCOTIA RAILWAY DURING PERIOD 1854- 1867.	.2 PAY LIST: WRITTEN RECORD OF PAYMENT MADE TO SPECIFIC EMPLOYEES.		Railway Transportation	Archives	Operations	paper->;composite->ink
1217	1217	1966.0691.002	PAPER & INK.	Unknown	Canada	2	LIST: BLACK INK ON OFF-WHITE PAPER.	THIS DOCUMENT PROVIDES INFORMATION ON OPERATIONS OF PRINCE EDWARD ISLAND RAILWAY DURING PERIOD 1886- 1899. THIS RAILWAY OPERATED BETWEEN TIGNISH GEORGETOWN & SOURIS WITH SERVICE TO CHARLOTTETOWN AND CAPE TRAVERSE.	TO PROVIDE INFORMATION ABOUT RAILWAY OPERATIONS IN WRITTEN FORM.	PROVIDES DETAILED RECORD OF MILES RUN AND STORES & FUEL CONSUMED DURING 1 MONTH PERIOD (MARCH 1886) BY P.E.I RAILWAY.	Railway Transportation	Archives	Operations	paper->;composite->ink
1219	1219	1966.0692.002				3
1220	1220	1966.0692.003				3
1223	1223	1966.0694.002				13
1224	1224	1966.0694.003				13
1225	1225	1966.0694.004				13
1226	1226	1966.0694.005				13

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE [artefacts] (
   [artifactNumber] TEXT,
   [ObjectName] TEXT,
   [GeneralDescription] TEXT,
   [model] TEXT,
   [SerialNumber] TEXT,
   [Manufacturer] TEXT,
   [ManuCountry] TEXT,
   [ManuProvince] TEXT,
   [ManuCity] TEXT,
   [BeginDate] TEXT,
   [EndDate] TEXT,
   [date_qualifier] TEXT,
   [patent] TEXT,
   [NumberOfComponents] TEXT,
   [ArtifactFinish] TEXT,
   [ContextCanada] TEXT,
   [ContextFunction] TEXT,
   [ContextTechnical] TEXT,
   [group1] TEXT,
   [category1] TEXT,
   [subcategory1] TEXT,
   [group2] TEXT,
   [category2] TEXT,
   [subcategory2] TEXT,
   [group3] TEXT,
   [category3] TEXT,
   [subcategory3] TEXT,
   [material] TEXT,
   [Length] TEXT,
   [Width] TEXT,
   [Height] TEXT,
   [Thickness] TEXT,
   [Weight] TEXT,
   [Diameter] TEXT,
   [image] TEXT,
   [thumbnail] TEXT,
   [] TEXT
);