Skip to content

Instantly share code, notes, and snippets.

@mrtomeq

mrtomeq/sample_measurements.sql

Created September 18, 2020 18:19
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mrtomeq/a304d48e3273639a48c6255ff6bacbcb to your computer and use it in GitHub Desktop.
Save mrtomeq/a304d48e3273639a48c6255ff6bacbcb to your computer and use it in GitHub Desktop.
Download ZIP
Sample measurements
Raw
sample_measurements.sql
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,231.9187413,'2020-09-09T09:51:25-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,233.3271292,'2020-09-09T11:30:00-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,231.532118,'2020-09-09T13:08:34-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,233.2763528,'2020-09-09T14:47:08-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,231.7268046,'2020-09-09T16:25:42-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,233.2779324,'2020-09-09T18:04:17-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,233.1495872,'2020-09-09T19:42:51-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,231.4580773,'2020-09-09T21:21:25-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,231.4529563,'2020-09-09T23:00:00-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,232.7954328,'2020-09-10T01:38:34-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,233.44,'2020-09-10T03:17:08-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,231.4964483,'2020-09-10T04:55:42-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,231.6603316,'2020-09-10T06:34:17-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,231.5117754,'2020-09-10T08:12:51-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,233.235303,'2020-09-10T09:51:25-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,233.4128228,'2020-09-10T11:30:00-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,231.7286957,'2020-09-10T13:08:34-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,232.244688,'2020-09-10T14:47:08-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,231.8804988,'2020-09-10T16:25:42-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,233.2386476,'2020-09-10T18:04:17-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,232.6128493,'2020-09-10T19:42:51-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,231.5502677,'2020-09-10T21:21:25-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,232.5007366,'2020-09-10T23:00:00-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,232.8487961,'2020-09-11T01:38:34-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,233.1611967,'2020-09-11T03:17:08-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,233.3886504,'2020-09-11T04:55:42-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,233.3682971,'2020-09-11T06:34:17-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,233.0473101,'2020-09-11T08:12:51-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,231.5284828,'2020-09-11T09:51:25-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,233.44,'2020-09-11T11:30:00-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,233.4342118,'2020-09-11T13:08:34-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,233.4071951,'2020-09-11T14:47:08-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,231.440667,'2020-09-11T16:25:42-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,232.1098306,'2020-09-11T18:04:17-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,231.4923676,'2020-09-11T19:42:51-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,233.2665553,'2020-09-11T21:21:25-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,233.3580154,'2020-09-11T23:00:00-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,233.405383,'2020-09-12T01:38:34-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,232.8863284,'2020-09-12T03:17:08-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,233.1568964,'2020-09-12T04:55:42-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,231.467761,'2020-09-12T06:34:17-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,233.4227872,'2020-09-12T08:12:51-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,231.4919638,'2020-09-12T09:51:25-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,231.6059957,'2020-09-12T11:30:00-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,231.625003,'2020-09-12T13:08:34-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,232.781309,'2020-09-12T14:47:08-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,231.4790285,'2020-09-12T16:25:42-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,234.1196676,'2020-09-12T18:04:17-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,233.4179195,'2020-09-12T19:42:51-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,231.4112648,'2020-09-12T21:21:25-04:00');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment