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

108,463 rows sorted by group1

descending

Link	rowid	artifactNumber	ObjectName	NumberOfComponents	image	thumbnail
919	919	1966.0549.005	Photograph	14	http://source.techno-science.ca/artifacts-artefacts/images/1966.0549.005.aa.cs.png	http://source.techno-science.ca/artifacts-artefacts/images/1966.0549.005.aa.cs.thumb.png
920	920	1966.0549.006	Photograph	14	http://source.techno-science.ca/artifacts-artefacts/images/1966.0549.006.aa.cs.png	http://source.techno-science.ca/artifacts-artefacts/images/1966.0549.006.aa.cs.thumb.png
921	921	1966.0549.007	Photograph	14	http://source.techno-science.ca/artifacts-artefacts/images/1966.0549.007.aa.cs.png	http://source.techno-science.ca/artifacts-artefacts/images/1966.0549.007.aa.cs.thumb.png
922	922	1966.0549.008	Photograph	14	http://source.techno-science.ca/artifacts-artefacts/images/1966.0549.008.aa.cs.png	http://source.techno-science.ca/artifacts-artefacts/images/1966.0549.008.aa.cs.thumb.png
923	923	1966.0549.009	Photograph	14	http://source.techno-science.ca/artifacts-artefacts/images/1966.0549.009.aa.cs.png	http://source.techno-science.ca/artifacts-artefacts/images/1966.0549.009.aa.cs.thumb.png
924	924	1966.0549.010	Photograph	14	http://source.techno-science.ca/artifacts-artefacts/images/1966.0549.010.aa.cs.png	http://source.techno-science.ca/artifacts-artefacts/images/1966.0549.010.aa.cs.thumb.png
925	925	1966.0549.011	Photograph	14	http://source.techno-science.ca/artifacts-artefacts/images/1966.0549.011.aa.cs.png	http://source.techno-science.ca/artifacts-artefacts/images/1966.0549.011.aa.cs.thumb.png
926	926	1966.0549.012	Photograph	14	http://source.techno-science.ca/artifacts-artefacts/images/1966.0549.012.aa.cs.png	http://source.techno-science.ca/artifacts-artefacts/images/1966.0549.012.aa.cs.thumb.png
927	927	1966.0549.013	Photograph	14	http://source.techno-science.ca/artifacts-artefacts/images/1966.0549.013.aa.cs.png	http://source.techno-science.ca/artifacts-artefacts/images/1966.0549.013.aa.cs.thumb.png
928	928	1966.0549.014	Photograph	14	http://source.techno-science.ca/artifacts-artefacts/images/1966.0549.014.aa.cs.png	http://source.techno-science.ca/artifacts-artefacts/images/1966.0549.014.aa.cs.thumb.png
933	933	1966.0553.002	Photograph	7
934	934	1966.0553.003	Photograph	7
935	935	1966.0553.004	Photograph	7
936	936	1966.0553.005	Photograph	7
937	937	1966.0553.006	Photograph	7
938	938	1966.0553.007	Photograph	7
954	954	1966.0568.002	Box vacuum tube	2
996	996	1966.0604.002		2	http://source.techno-science.ca/artifacts-artefacts/images/1966.0604.002.aa.cs.png	http://source.techno-science.ca/artifacts-artefacts/images/1966.0604.002.aa.cs.thumb.png
998	998	1966.0605.002		2
1011	1011	1966.0616.002		2
1052	1052	1966.0656.002	Photograph	14
1053	1053	1966.0656.003	Photograph	14
1054	1054	1966.0656.004	Photograph	14
1055	1055	1966.0656.005	Photograph	14
1056	1056	1966.0656.006	Photograph	14
1057	1057	1966.0656.007	Photograph	14
1058	1058	1966.0656.008	Photograph	14
1059	1059	1966.0656.009	Photograph	14
1060	1060	1966.0656.010	Photograph	14
1061	1061	1966.0656.011	Photograph	14
1062	1062	1966.0656.012	Photograph	14
1063	1063	1966.0656.013	Photograph	14
1064	1064	1966.0656.014	Photograph	14
1073	1073	1966.0664.002		2
1075	1075	1966.0665.002		2
1104	1104	1966.0686.002		91
1105	1105	1966.0686.003		91
1106	1106	1966.0686.004		91
1107	1107	1966.0686.005		91
1108	1108	1966.0686.006		91
1109	1109	1966.0686.007		91
1110	1110	1966.0686.008		91
1111	1111	1966.0686.009		91
1112	1112	1966.0686.010		91
1113	1113	1966.0686.011		91
1114	1114	1966.0686.012		91
1115	1115	1966.0686.013		91
1116	1116	1966.0686.014		91
1117	1117	1966.0686.015		91
1118	1118	1966.0686.016		91
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

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
);