participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
8,332 rows where station_code = "USL019" sorted by created_at descending
This data as json, copyable, CSV (advanced)
Suggested facets: created_at (date), updated_at (date)
Link | rowid | meteor_unique_trajectory_identifier | station_code | created_at ▲ | updated_at |
---|---|---|---|---|---|
5491900 | 5491900 | 20241106061301_lIeaP | USL019 | 2024-11-07T14:17:18.835Z | 2024-11-08T14:17:07.577Z |
5471597 | 5471597 | 20241104120728_v29Ks | USL019 | 2024-11-05T14:04:00.777Z | 2024-11-08T14:17:36.975Z |
5471564 | 5471564 | 20241104120400_vkFYa | USL019 | 2024-11-05T14:03:56.554Z | 2024-11-08T14:17:36.024Z |
5471389 | 5471389 | 20241104113804_ynPmn | USL019 | 2024-11-05T14:03:38.933Z | 2024-11-08T14:17:33.172Z |
5471360 | 5471360 | 20241104113151_TL5z7 | USL019 | 2024-11-05T14:03:31.844Z | 2024-11-08T14:17:32.761Z |
5464080 | 5464080 | 20241101013443_ZG1iD | USL019 | 2024-11-03T14:21:49.791Z | 2024-11-08T14:22:32.223Z |
5463953 | 5463953 | 20241102061947_Z8q33 | USL019 | 2024-11-03T14:19:26.877Z | 2024-11-08T14:21:55.718Z |
5463640 | 5463640 | 20241102042551_9Ej9e | USL019 | 2024-11-03T14:19:05.863Z | 2024-11-08T14:21:54.094Z |
5463609 | 5463609 | 20241102042005_8c8ab | USL019 | 2024-11-03T14:19:02.205Z | 2024-11-08T14:21:53.996Z |
5463015 | 5463015 | 20241102021549_5hcfy | USL019 | 2024-11-03T14:18:14.488Z | 2024-11-08T14:21:50.900Z |
5456836 | 5456836 | 20241102123613_rVSko | USL019 | 2024-11-03T14:05:47.377Z | 2024-11-08T14:20:34.469Z |
5456697 | 5456697 | 20241102120603_xJhkA | USL019 | 2024-11-03T14:05:29.468Z | 2024-11-08T14:20:32.786Z |
5456508 | 5456508 | 20241102113620_EeFa3 | USL019 | 2024-11-03T14:04:52.702Z | 2024-11-08T14:20:31.295Z |
5456506 | 5456506 | 20241102113546_6oRF0 | USL019 | 2024-11-03T14:04:52.254Z | 2024-11-08T14:20:31.271Z |
5456503 | 5456503 | 20241102113539_sybSc | USL019 | 2024-11-03T14:04:51.822Z | 2024-11-08T14:20:31.244Z |
5456319 | 5456319 | 20241102105855_2HK12 | USL019 | 2024-11-03T14:04:12.038Z | 2024-11-08T14:20:28.818Z |
5456267 | 5456267 | 20241102105039_DJRHq | USL019 | 2024-11-03T14:04:00.820Z | 2024-11-08T14:20:28.442Z |
5456247 | 5456247 | 20241102104707_pvBlY | USL019 | 2024-11-03T14:03:53.666Z | 2024-11-08T14:20:28.272Z |
5456210 | 5456210 | 20241102104332_BHGCL | USL019 | 2024-11-03T14:03:48.601Z | 2024-11-08T14:20:27.847Z |
5456189 | 5456189 | 20241102103805_Gs2rl | USL019 | 2024-11-03T14:03:45.018Z | 2024-11-08T14:20:27.689Z |
5456153 | 5456153 | 20241102103011_3ysxc | USL019 | 2024-11-03T14:03:33.230Z | 2024-11-08T14:20:27.044Z |
5456119 | 5456119 | 20241102102444_L0PIT | USL019 | 2024-11-03T14:03:23.731Z | 2024-11-08T14:20:26.860Z |
5456117 | 5456117 | 20241102102432_Yu2FQ | USL019 | 2024-11-03T14:03:23.067Z | 2024-11-08T14:20:26.850Z |
5456005 | 5456005 | 20241102100559_9h547 | USL019 | 2024-11-03T14:03:05.543Z | 2024-11-08T14:20:26.151Z |
5455862 | 5455862 | 20241102093528_Y3EXW | USL019 | 2024-11-03T14:02:30.930Z | 2024-11-08T14:20:24.621Z |
5455830 | 5455830 | 20241102092550_vMxPK | USL019 | 2024-11-03T14:02:25.919Z | 2024-11-08T14:20:24.317Z |
5455763 | 5455763 | 20241102091309_qE0I0 | USL019 | 2024-11-03T14:02:15.289Z | 2024-11-08T14:20:23.521Z |
5455716 | 5455716 | 20241102090442_7xaxr | USL019 | 2024-11-03T14:02:03.064Z | 2024-11-08T14:20:23.255Z |
5455698 | 5455698 | 20241102085937_kZACX | USL019 | 2024-11-03T14:01:58.109Z | 2024-11-08T14:20:23.137Z |
5455648 | 5455648 | 20241102085055_kj5M4 | USL019 | 2024-11-03T14:01:47.191Z | 2024-11-08T14:20:22.801Z |
5455606 | 5455606 | 20241102084234_b0q4J | USL019 | 2024-11-03T14:01:39.193Z | 2024-11-08T14:20:22.527Z |
5455229 | 5455229 | 20241102065220_X02ou | USL019 | 2024-11-03T14:00:12.436Z | 2024-11-08T14:20:19.457Z |
5455141 | 5455141 | 20241031063823_MYgBu | USL019 | 2024-11-02T12:23:31.832Z | 2024-11-08T14:23:27.545Z |
5455044 | 5455044 | 20241031061054_2tCIj | USL019 | 2024-11-02T12:23:29.962Z | 2024-11-08T14:23:27.116Z |
5454997 | 5454997 | 20241031060333_PnA5T | USL019 | 2024-11-02T12:23:29.183Z | 2024-11-08T14:23:26.637Z |
5454661 | 5454661 | 20241031045238_P6yvi | USL019 | 2024-11-02T12:23:15.870Z | 2024-11-08T14:23:24.642Z |
5454510 | 5454510 | 20241031043138_vqeyO | USL019 | 2024-11-02T12:23:09.032Z | 2024-11-08T14:23:23.438Z |
5454393 | 5454393 | 20241031041425_v5S9k | USL019 | 2024-11-02T12:23:05.267Z | 2024-11-08T14:23:22.638Z |
5454281 | 5454281 | 20241031040440_orLV0 | USL019 | 2024-11-02T12:22:58.660Z | 2024-11-08T14:23:21.998Z |
5453873 | 5453873 | 20241031031101_zyyPg | USL019 | 2024-11-02T12:22:44.000Z | 2024-11-08T14:23:19.598Z |
5453338 | 5453338 | 20241031020331_87v3p | USL019 | 2024-11-02T12:22:32.027Z | 2024-11-08T14:23:16.771Z |
5448105 | 5448105 | 20241031124316_AQlhF | USL019 | 2024-11-02T12:09:58.324Z | 2024-11-08T14:22:14.661Z |
5447833 | 5447833 | 20241031121509_JzdSN | USL019 | 2024-11-02T12:09:15.796Z | 2024-11-08T14:22:13.642Z |
5447793 | 5447793 | 20241031121113_lj919 | USL019 | 2024-11-02T12:09:06.101Z | 2024-11-08T14:22:13.519Z |
5447559 | 5447559 | 20241031115235_S1OOg | USL019 | 2024-11-02T12:08:27.110Z | 2024-11-08T14:22:12.559Z |
5447549 | 5447549 | 20241031115152_La2ew | USL019 | 2024-11-02T12:08:25.598Z | 2024-11-08T14:22:12.512Z |
5447458 | 5447458 | 20241031114358_fVget | USL019 | 2024-11-02T12:08:13.467Z | 2024-11-08T14:22:12.127Z |
5447250 | 5447250 | 20241031112337_3y74Z | USL019 | 2024-11-02T12:07:36.807Z | 2024-11-08T14:22:11.256Z |
5447222 | 5447222 | 20241031112013_O7DC4 | USL019 | 2024-11-02T12:07:31.648Z | 2024-11-08T14:22:11.186Z |
5446762 | 5446762 | 20241031102835_emcIF | USL019 | 2024-11-02T12:06:11.664Z | 2024-11-08T14:22:08.884Z |
5446734 | 5446734 | 20241031102712_qO2xo | USL019 | 2024-11-02T12:06:09.064Z | 2024-11-08T14:22:08.820Z |
5446315 | 5446315 | 20241031094821_mJgA7 | USL019 | 2024-11-02T12:04:52.635Z | 2024-11-08T14:22:05.975Z |
5446236 | 5446236 | 20241031093859_Undmq | USL019 | 2024-11-02T12:04:39.918Z | 2024-11-08T14:22:05.378Z |
5446123 | 5446123 | 20241031092934_ijW7c | USL019 | 2024-11-02T12:04:18.444Z | 2024-11-08T14:22:04.474Z |
5446089 | 5446089 | 20241031092502_FdyrU | USL019 | 2024-11-02T12:04:13.137Z | 2024-11-08T14:22:04.402Z |
5446049 | 5446049 | 20241031092052_5CKmY | USL019 | 2024-11-02T12:04:04.427Z | 2024-11-08T14:22:04.305Z |
5446017 | 5446017 | 20241031091754_kfL3u | USL019 | 2024-11-02T12:03:59.374Z | 2024-11-08T14:22:04.211Z |
5445978 | 5445978 | 20241031091324_QbNnV | USL019 | 2024-11-02T12:03:54.961Z | 2024-11-08T14:22:04.140Z |
5445839 | 5445839 | 20241031085300_BqZZk | USL019 | 2024-11-02T12:03:20.757Z | 2024-11-08T14:22:03.710Z |
5445800 | 5445800 | 20241031085036_1srhM | USL019 | 2024-11-02T12:03:15.473Z | 2024-11-08T14:22:03.568Z |
5445633 | 5445633 | 20241031082905_yE4M0 | USL019 | 2024-11-02T12:02:42.256Z | 2024-11-08T14:22:02.481Z |
5445606 | 5445606 | 20241031082532_5BbNn | USL019 | 2024-11-02T12:02:34.246Z | 2024-11-08T14:22:02.370Z |
5445520 | 5445520 | 20241031081405_tF0yt | USL019 | 2024-11-02T12:02:14.653Z | 2024-11-08T14:22:01.720Z |
5445504 | 5445504 | 20241031081246_dvryL | USL019 | 2024-11-02T12:02:12.115Z | 2024-11-08T14:22:01.619Z |
5445457 | 5445457 | 20241031080329_hr9cS | USL019 | 2024-11-02T12:02:04.716Z | 2024-11-08T14:22:01.389Z |
5445375 | 5445375 | 20241031075346_LjpVf | USL019 | 2024-11-02T12:01:54.709Z | 2024-11-08T14:22:00.740Z |
5445366 | 5445366 | 20241031075201_3u4zG | USL019 | 2024-11-02T12:01:53.128Z | 2024-11-08T14:22:00.668Z |
5445345 | 5445345 | 20241031074440_pjpcM | USL019 | 2024-11-02T12:01:44.922Z | 2024-11-08T14:22:00.413Z |
5445127 | 5445127 | 20241031070249_r5x5w | USL019 | 2024-11-02T12:01:00.175Z | 2024-11-08T14:21:58.959Z |
5442700 | 5442700 | 20241030021657_eUMYj | USL019 | 2024-11-01T12:20:05.692Z | 2024-11-07T14:26:47.719Z |
5435925 | 5435925 | 20241030121106_58h3U | USL019 | 2024-11-01T12:06:22.423Z | 2024-11-08T14:22:52.136Z |
5435909 | 5435909 | 20241030120917_RF77l | USL019 | 2024-11-01T12:06:20.098Z | 2024-11-08T14:22:52.106Z |
5435644 | 5435644 | 20241030114704_mXBTx | USL019 | 2024-11-01T12:05:42.679Z | 2024-11-08T14:22:51.333Z |
5435416 | 5435416 | 20241030112656_UmU3B | USL019 | 2024-11-01T12:05:07.107Z | 2024-11-08T14:22:50.420Z |
5435339 | 5435339 | 20241030111906_31EAZ | USL019 | 2024-11-01T12:04:56.770Z | 2024-11-08T14:22:50.239Z |
5435312 | 5435312 | 20241030111539_gjwvX | USL019 | 2024-11-01T12:04:48.687Z | 2024-11-08T14:22:50.037Z |
5435086 | 5435086 | 20241030104829_rhCRd | USL019 | 2024-11-01T12:04:16.572Z | 2024-11-08T14:22:49.155Z |
5434429 | 5434429 | 20241030092209_XUEd2 | USL019 | 2024-11-01T12:02:22.707Z | 2024-11-08T14:22:46.530Z |
5434130 | 5434130 | 20241030082421_A6P5a | USL019 | 2024-11-01T12:01:21.338Z | 2024-11-08T14:22:44.945Z |
5434113 | 5434113 | 20241030082205_Xg7h7 | USL019 | 2024-11-01T12:01:17.197Z | 2024-11-08T14:22:44.774Z |
5434062 | 5434062 | 20241030081242_3b2z3 | USL019 | 2024-11-01T12:01:05.806Z | 2024-11-08T14:22:44.691Z |
5423531 | 5423531 | 20241029104823_CMvgS | USL019 | 2024-10-31T12:01:46.959Z | 2024-11-07T14:26:26.742Z |
5400118 | 5400118 | 20241026054149_pVLXr | USL019 | 2024-10-28T12:20:23.467Z | 2024-11-03T14:27:41.352Z |
5400079 | 5400079 | 20241026053719_MpvA2 | USL019 | 2024-10-28T12:20:21.832Z | 2024-11-03T14:27:41.269Z |
5400046 | 5400046 | 20241026052900_AGLgo | USL019 | 2024-10-28T12:20:20.379Z | 2024-11-03T14:27:41.179Z |
5399845 | 5399845 | 20241026050647_zMwkI | USL019 | 2024-10-28T12:20:13.573Z | 2024-11-03T14:27:40.608Z |
5399495 | 5399495 | 20241026042849_Fc3Y2 | USL019 | 2024-10-28T12:20:00.932Z | 2024-11-03T14:27:39.861Z |
5399329 | 5399329 | 20241026041029_Lqfbl | USL019 | 2024-10-28T12:19:54.838Z | 2024-11-03T14:27:39.459Z |
5398921 | 5398921 | 20241026033821_30EtK | USL019 | 2024-10-28T12:19:40.236Z | 2024-11-03T14:27:38.614Z |
5398332 | 5398332 | 20241026024447_4TnLl | USL019 | 2024-10-28T12:19:10.961Z | 2024-11-03T14:27:35.901Z |
5391641 | 5391641 | 20241026122452_dfyi4 | USL019 | 2024-10-28T12:06:00.006Z | 2024-11-04T14:28:35.882Z |
5391584 | 5391584 | 20241026121843_p39Qp | USL019 | 2024-10-28T12:05:52.976Z | 2024-11-04T14:28:35.721Z |
5391558 | 5391558 | 20241026121458_x4XqT | USL019 | 2024-10-28T12:05:50.161Z | 2024-11-04T14:28:35.670Z |
5391511 | 5391511 | 20241026121144_Rra6O | USL019 | 2024-10-28T12:05:45.355Z | 2024-11-04T14:28:35.294Z |
5391442 | 5391442 | 20241026115555_sDVU3 | USL019 | 2024-10-28T12:05:30.795Z | 2024-11-04T14:28:34.663Z |
5391105 | 5391105 | 20241026111301_THP6S | USL019 | 2024-10-28T12:04:42.454Z | 2024-11-04T14:28:33.507Z |
5391032 | 5391032 | 20241026110335_9imU9 | USL019 | 2024-10-28T12:04:35.649Z | 2024-11-04T14:28:33.275Z |
5390981 | 5390981 | 20241026105804_NNYMu | USL019 | 2024-10-28T12:04:30.393Z | 2024-11-04T14:28:32.902Z |
5390834 | 5390834 | 20241026103654_5QG6g | USL019 | 2024-10-28T12:04:05.237Z | 2024-11-04T14:28:32.022Z |
5390768 | 5390768 | 20241026103012_NAGE2 | USL019 | 2024-10-28T12:03:58.904Z | 2024-11-04T14:28:31.699Z |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE participating_station ( meteor_unique_trajectory_identifier text NOT NULL, station_code text NOT NULL, created_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), updated_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), FOREIGN KEY (meteor_unique_trajectory_identifier) REFERENCES meteor (unique_trajectory_identifier), FOREIGN KEY (station_code) REFERENCES station (code), UNIQUE (meteor_unique_trajectory_identifier, station_code) ON CONFLICT IGNORE ); CREATE INDEX participating_station_station_code_covering_index ON participating_station (station_code, meteor_unique_trajectory_identifier); CREATE INDEX participating_station_created_at_index ON participating_station (created_at); CREATE INDEX participating_station_updated_at_index ON participating_station (updated_at);