participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
7,763 rows where station_code = "USL015" 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 |
---|---|---|---|---|---|
5524655 | 5524655 | 20241111050014_w2pVy | USL015 | 2024-11-12T14:17:51.155Z | 2024-11-12T14:18:08.721Z |
5524388 | 5524388 | 20241111040657_FnNaM | USL015 | 2024-11-12T14:17:13.746Z | 2024-11-12T14:18:08.597Z |
5519438 | 5519438 | 20241111112336_euCgI | USL015 | 2024-11-12T14:04:00.914Z | 2024-11-12T14:04:00.914Z |
5518727 | 5518727 | 20241111090137_xVFzw | USL015 | 2024-11-12T14:01:47.665Z | 2024-11-12T14:01:47.665Z |
5518396 | 5518396 | 20241111072648_0zKKj | USL015 | 2024-11-12T14:00:50.308Z | 2024-11-12T14:00:50.308Z |
5518260 | 5518260 | 20241111064322_yn950 | USL015 | 2024-11-12T14:00:24.060Z | 2024-11-12T14:00:24.060Z |
5518072 | 5518072 | 20241110055315_KmhJl | USL015 | 2024-11-11T14:15:11.583Z | 2024-11-12T14:22:01.613Z |
5517889 | 5517889 | 20241110050837_YMipx | USL015 | 2024-11-11T14:14:59.661Z | 2024-11-12T14:21:57.808Z |
5517708 | 5517708 | 20241110043303_Y4OhD | USL015 | 2024-11-11T14:14:46.004Z | 2024-11-12T14:21:52.591Z |
5517333 | 5517333 | 20241110032720_FgXkq | USL015 | 2024-11-11T14:14:16.224Z | 2024-11-12T14:21:38.171Z |
5513794 | 5513794 | 20241110122120_CHy9d | USL015 | 2024-11-11T14:05:28.895Z | 2024-11-12T14:18:06.648Z |
5513769 | 5513769 | 20241110121928_acUPt | USL015 | 2024-11-11T14:05:26.817Z | 2024-11-12T14:18:06.640Z |
5513602 | 5513602 | 20241110115619_poqO5 | USL015 | 2024-11-11T14:04:56.990Z | 2024-11-12T14:18:06.571Z |
5513532 | 5513532 | 20241110114613_uS3zX | USL015 | 2024-11-11T14:04:47.053Z | 2024-11-12T14:18:06.538Z |
5513478 | 5513478 | 20241110113545_z2yuw | USL015 | 2024-11-11T14:04:42.358Z | 2024-11-12T14:18:06.513Z |
5513402 | 5513402 | 20241110112549_9cOiH | USL015 | 2024-11-11T14:04:35.101Z | 2024-11-12T14:18:06.478Z |
5513393 | 5513393 | 20241110112522_dJ3po | USL015 | 2024-11-11T14:04:34.560Z | 2024-11-12T14:18:06.476Z |
5513236 | 5513236 | 20241110110137_3QLW3 | USL015 | 2024-11-11T14:04:12.576Z | 2024-11-12T14:18:06.405Z |
5513020 | 5513020 | 20241110102312_nJfZ7 | USL015 | 2024-11-11T14:03:45.347Z | 2024-11-12T14:18:06.309Z |
5513002 | 5513002 | 20241110101958_Oqkrz | USL015 | 2024-11-11T14:03:43.619Z | 2024-11-12T14:18:06.300Z |
5512879 | 5512879 | 20241110100353_muchW | USL015 | 2024-11-11T14:03:23.789Z | 2024-11-12T14:18:06.255Z |
5512463 | 5512463 | 20241110085409_KZ6Ld | USL015 | 2024-11-11T14:02:22.338Z | 2024-11-12T14:18:06.087Z |
5512413 | 5512413 | 20241110084510_M2bqy | USL015 | 2024-11-11T14:02:16.329Z | 2024-11-12T14:18:06.067Z |
5511962 | 5511962 | 20241110073251_1i24O | USL015 | 2024-11-11T14:01:12.520Z | 2024-11-12T14:18:05.876Z |
5511822 | 5511822 | 20241110070449_kqrcO | USL015 | 2024-11-11T14:00:53.131Z | 2024-11-12T14:18:05.819Z |
5511265 | 5511265 | 20241109052746_6jye7 | USL015 | 2024-11-10T14:16:36.859Z | 2024-11-12T14:23:47.585Z |
5511127 | 5511127 | 20241109043459_otZty | USL015 | 2024-11-10T14:16:18.616Z | 2024-11-12T14:23:45.323Z |
5510867 | 5510867 | 20241109034554_zxoh5 | USL015 | 2024-11-10T14:15:47.567Z | 2024-11-12T14:23:41.828Z |
5507789 | 5507789 | 20241109122615_h9pBx | USL015 | 2024-11-10T14:06:11.638Z | 2024-11-12T14:19:11.050Z |
5507652 | 5507652 | 20241109120358_GQ7S9 | USL015 | 2024-11-10T14:05:42.391Z | 2024-11-12T14:19:05.953Z |
5507549 | 5507549 | 20241109114913_4MwQ2 | USL015 | 2024-11-10T14:05:31.503Z | 2024-11-12T14:19:01.925Z |
5507461 | 5507461 | 20241109113235_zpkuK | USL015 | 2024-11-10T14:05:16.762Z | 2024-11-12T14:18:57.467Z |
5507398 | 5507398 | 20241109112346_42tWG | USL015 | 2024-11-10T14:05:00.521Z | 2024-11-12T14:18:55.533Z |
5507308 | 5507308 | 20241109111005_AA84f | USL015 | 2024-11-10T14:04:48.419Z | 2024-11-12T14:18:51.481Z |
5507177 | 5507177 | 20241109104843_cDtYu | USL015 | 2024-11-10T14:04:35.608Z | 2024-11-12T14:18:49.489Z |
5506944 | 5506944 | 20241109100252_kS7R8 | USL015 | 2024-11-10T14:03:54.593Z | 2024-11-12T14:18:41.184Z |
5506884 | 5506884 | 20241109095319_z5uUA | USL015 | 2024-11-10T14:03:39.212Z | 2024-11-12T14:18:37.792Z |
5506860 | 5506860 | 20241109094931_EpRuI | USL015 | 2024-11-10T14:03:31.514Z | 2024-11-12T14:18:36.091Z |
5506808 | 5506808 | 20241109093912_DKCvS | USL015 | 2024-11-10T14:03:22.274Z | 2024-11-12T14:18:34.249Z |
5506570 | 5506570 | 20241109090128_rF3Bj | USL015 | 2024-11-10T14:02:34.945Z | 2024-11-12T14:18:25.983Z |
5506521 | 5506521 | 20241109085230_CbfOz | USL015 | 2024-11-10T14:02:28.158Z | 2024-11-12T14:18:25.004Z |
5506399 | 5506399 | 20241109083425_dtASx | USL015 | 2024-11-10T14:02:06.319Z | 2024-11-12T14:18:23.594Z |
5506394 | 5506394 | 20241109083356_c33rQ | USL015 | 2024-11-10T14:02:02.983Z | 2024-11-12T14:18:23.503Z |
5506347 | 5506347 | 20241109082338_Bhqni | USL015 | 2024-11-10T14:01:52.679Z | 2024-11-12T14:18:22.879Z |
5506314 | 5506314 | 20241109081927_jEadu | USL015 | 2024-11-10T14:01:48.109Z | 2024-11-12T14:18:22.283Z |
5506194 | 5506194 | 20241109075245_CtS16 | USL015 | 2024-11-10T14:01:32.506Z | 2024-11-12T14:18:18.980Z |
5506139 | 5506139 | 20241109074414_ILXo1 | USL015 | 2024-11-10T14:01:19.162Z | 2024-11-12T14:18:17.440Z |
5506062 | 5506062 | 20241109073236_kmjfB | USL015 | 2024-11-10T14:01:08.616Z | 2024-11-12T14:18:16.415Z |
5506024 | 5506024 | 20241109072648_gAcVH | USL015 | 2024-11-10T14:01:03.639Z | 2024-11-12T14:18:15.813Z |
5505953 | 5505953 | 20241109071154_7ZUcm | USL015 | 2024-11-10T14:00:53.221Z | 2024-11-12T14:18:14.624Z |
5505712 | 5505712 | 20241109062346_auvJ4 | USL015 | 2024-11-10T14:00:13.794Z | 2024-11-12T14:18:11.296Z |
5504537 | 5504537 | 20241108021256_QlmD5 | USL015 | 2024-11-09T14:14:49.311Z | 2024-11-12T14:25:04.804Z |
5499652 | 5499652 | 20241108125137_NQboU | USL015 | 2024-11-09T14:04:34.055Z | 2024-11-12T14:22:37.103Z |
5499556 | 5499556 | 20241108123622_czN4P | USL015 | 2024-11-09T14:04:18.582Z | 2024-11-12T14:22:34.771Z |
5499518 | 5499518 | 20241108123117_RgqPj | USL015 | 2024-11-09T14:04:15.072Z | 2024-11-12T14:22:33.616Z |
5499461 | 5499461 | 20241108122216_pWh8Q | USL015 | 2024-11-09T14:04:08.542Z | 2024-11-12T14:22:32.783Z |
5499335 | 5499335 | 20241108120006_rohN6 | USL015 | 2024-11-09T14:03:47.588Z | 2024-11-12T14:22:31.181Z |
5498459 | 5498459 | 20241108083712_C96JQ | USL015 | 2024-11-09T14:01:32.400Z | 2024-11-12T14:22:14.012Z |
5498263 | 5498263 | 20241108074555_wxtlU | USL015 | 2024-11-09T14:00:58.978Z | 2024-11-12T14:22:10.040Z |
5498247 | 5498247 | 20241108074205_xDyjR | USL015 | 2024-11-09T14:00:56.403Z | 2024-11-12T14:22:09.655Z |
5498204 | 5498204 | 20241108072759_1deTg | USL015 | 2024-11-09T14:00:49.290Z | 2024-11-12T14:22:08.679Z |
5498039 | 5498039 | 20241108063146_ZVPL4 | USL015 | 2024-11-09T14:00:16.661Z | 2024-11-12T14:22:05.480Z |
5497684 | 5497684 | 20241107042817_zQtGj | USL015 | 2024-11-08T14:14:10.967Z | 2024-11-12T14:26:13.775Z |
5497648 | 5497648 | 20241107041715_AaFeH | USL015 | 2024-11-08T14:14:07.911Z | 2024-11-12T14:26:13.643Z |
5493425 | 5493425 | 20241107120946_PtbPW | USL015 | 2024-11-08T14:03:44.094Z | 2024-11-12T14:24:11.013Z |
5493392 | 5493392 | 20241107120132_TkCc3 | USL015 | 2024-11-08T14:03:40.350Z | 2024-11-12T14:24:10.685Z |
5493309 | 5493309 | 20241107114546_SNXKg | USL015 | 2024-11-08T14:03:31.341Z | 2024-11-12T14:24:09.612Z |
5493152 | 5493152 | 20241107110702_Z87Il | USL015 | 2024-11-08T14:02:58.760Z | 2024-11-12T14:24:07.627Z |
5493108 | 5493108 | 20241107105504_bPqzv | USL015 | 2024-11-08T14:02:51.696Z | 2024-11-12T14:24:06.827Z |
5493105 | 5493105 | 20241107105408_Se2Fo | USL015 | 2024-11-08T14:02:51.451Z | 2024-11-12T14:24:06.794Z |
5492894 | 5492894 | 20241107101635_2Ynf3 | USL015 | 2024-11-08T14:02:25.448Z | 2024-11-12T14:24:03.208Z |
5492824 | 5492824 | 20241107100039_NaZeg | USL015 | 2024-11-08T14:02:09.891Z | 2024-11-12T14:24:02.020Z |
5492814 | 5492814 | 20241107095822_9iOpK | USL015 | 2024-11-08T14:02:08.561Z | 2024-11-12T14:24:01.936Z |
5492783 | 5492783 | 20241107095512_y4let | USL015 | 2024-11-08T14:02:05.025Z | 2024-11-12T14:24:01.544Z |
5492587 | 5492587 | 20241107091205_avk3M | USL015 | 2024-11-08T14:01:30.363Z | 2024-11-12T14:23:58.371Z |
5492508 | 5492508 | 20241107084625_8EfuQ | USL015 | 2024-11-08T14:01:18.885Z | 2024-11-12T14:23:57.340Z |
5492278 | 5492278 | 20241107075304_mnuDm | USL015 | 2024-11-08T14:00:41.045Z | 2024-11-12T14:23:54.324Z |
5492208 | 5492208 | 20241107072823_X9IoH | USL015 | 2024-11-08T14:00:29.020Z | 2024-11-12T14:23:53.650Z |
5492186 | 5492186 | 20241107072422_3Pmlb | USL015 | 2024-11-08T14:00:25.193Z | 2024-11-12T14:23:53.393Z |
5488144 | 5488144 | 20241105080745_oR30r | USL015 | 2024-11-07T14:08:00.125Z | 2024-11-12T14:26:20.624Z |
5485497 | 5485497 | 20241105060648_jtQSp | USL015 | 2024-11-06T14:18:22.862Z | 2024-11-12T14:27:38.868Z |
5485447 | 5485447 | 20241105054117_rzNWw | USL015 | 2024-11-06T14:18:18.552Z | 2024-11-12T14:27:38.749Z |
5485356 | 5485356 | 20241105050147_P2Yk8 | USL015 | 2024-11-06T14:18:09.431Z | 2024-11-12T14:27:38.401Z |
5485349 | 5485349 | 20241105050056_hi12u | USL015 | 2024-11-06T14:18:09.284Z | 2024-11-12T14:27:38.400Z |
5485231 | 5485231 | 20241105042607_Bmpop | USL015 | 2024-11-06T14:17:56.789Z | 2024-11-12T14:27:37.477Z |
5480381 | 5480381 | 20241105123754_zRDE3 | USL015 | 2024-11-06T14:05:22.858Z | 2024-11-12T14:26:31.191Z |
5480207 | 5480207 | 20241105120146_RpPbQ | USL015 | 2024-11-06T14:04:57.611Z | 2024-11-12T14:26:28.726Z |
5480088 | 5480088 | 20241105113356_s9zNn | USL015 | 2024-11-06T14:04:28.621Z | 2024-11-12T14:26:27.783Z |
5480078 | 5480078 | 20241105113020_zGOUd | USL015 | 2024-11-06T14:04:26.923Z | 2024-11-12T14:26:27.738Z |
5480067 | 5480067 | 20241105112935_cdVSz | USL015 | 2024-11-06T14:04:25.865Z | 2024-11-12T14:26:27.700Z |
5479761 | 5479761 | 20241105103405_RdDZX | USL015 | 2024-11-06T14:03:30.333Z | 2024-11-12T14:26:25.890Z |
5479744 | 5479744 | 20241105103008_fZAB3 | USL015 | 2024-11-06T14:03:23.634Z | 2024-11-12T14:26:25.813Z |
5479647 | 5479647 | 20241105100950_juwte | USL015 | 2024-11-06T14:02:58.792Z | 2024-11-12T14:26:25.423Z |
5479569 | 5479569 | 20241105095836_Ufx8x | USL015 | 2024-11-06T14:02:47.140Z | 2024-11-12T14:26:24.890Z |
5479530 | 5479530 | 20241105094959_dpcK6 | USL015 | 2024-11-06T14:02:41.419Z | 2024-11-12T14:26:24.544Z |
5479417 | 5479417 | 20241105092500_f7W2K | USL015 | 2024-11-06T14:02:13.821Z | 2024-11-12T14:26:23.676Z |
5479370 | 5479370 | 20241105091304_v3F3R | USL015 | 2024-11-06T14:02:07.448Z | 2024-11-12T14:26:23.252Z |
5479335 | 5479335 | 20241105090543_qvj5J | USL015 | 2024-11-06T14:02:02.896Z | 2024-11-12T14:26:22.979Z |
5479248 | 5479248 | 20241105084526_KrqT5 | USL015 | 2024-11-06T14:01:36.109Z | 2024-11-12T14:26:22.114Z |
5479201 | 5479201 | 20241105082850_uNW2V | USL015 | 2024-11-06T14:01:28.527Z | 2024-11-12T14:26:21.568Z |
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);