participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "USL012" 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 |
---|---|---|---|---|---|
5505584 | 5505584 | 20241108061557_iEItE | USL012 | 2024-11-09T14:16:24.138Z | 2024-11-09T14:16:28.820Z |
5505549 | 5505549 | 20241108060421_oeY2T | USL012 | 2024-11-09T14:16:23.040Z | 2024-11-09T14:16:28.813Z |
5505520 | 5505520 | 20241108055003_2d75P | USL012 | 2024-11-09T14:16:21.593Z | 2024-11-09T14:16:28.805Z |
5505474 | 5505474 | 20241108053143_Udaem | USL012 | 2024-11-09T14:16:19.816Z | 2024-11-09T14:16:28.794Z |
5505306 | 5505306 | 20241108043309_j2UPC | USL012 | 2024-11-09T14:16:07.156Z | 2024-11-09T14:16:28.750Z |
5505105 | 5505105 | 20241108035346_Shy3W | USL012 | 2024-11-09T14:15:44.556Z | 2024-11-09T14:16:28.702Z |
5504634 | 5504634 | 20241108023036_UV0tS | USL012 | 2024-11-09T14:14:59.225Z | 2024-11-09T14:16:28.588Z |
5504536 | 5504536 | 20241108021256_QlmD5 | USL012 | 2024-11-09T14:14:49.311Z | 2024-11-09T14:16:28.564Z |
5499555 | 5499555 | 20241108123622_czN4P | USL012 | 2024-11-09T14:04:18.582Z | 2024-11-09T14:04:18.582Z |
5499290 | 5499290 | 20241108114949_Vu82q | USL012 | 2024-11-09T14:03:42.021Z | 2024-11-09T14:03:42.021Z |
5499225 | 5499225 | 20241108113831_ba28R | USL012 | 2024-11-09T14:03:34.312Z | 2024-11-09T14:03:34.312Z |
5498978 | 5498978 | 20241108103811_yjGJo | USL012 | 2024-11-09T14:02:54.746Z | 2024-11-09T14:02:54.746Z |
5498904 | 5498904 | 20241108102329_A2ur2 | USL012 | 2024-11-09T14:02:45.189Z | 2024-11-09T14:02:45.189Z |
5498864 | 5498864 | 20241108101622_3SD2t | USL012 | 2024-11-09T14:02:38.960Z | 2024-11-09T14:02:38.960Z |
5498637 | 5498637 | 20241108092853_37mPH | USL012 | 2024-11-09T14:02:03.997Z | 2024-11-09T14:02:03.997Z |
5498560 | 5498560 | 20241108090724_nC0Xa | USL012 | 2024-11-09T14:01:47.105Z | 2024-11-09T14:01:47.105Z |
5498262 | 5498262 | 20241108074555_wxtlU | USL012 | 2024-11-09T14:00:58.978Z | 2024-11-09T14:00:58.978Z |
5498188 | 5498188 | 20241108072650_mIN2h | USL012 | 2024-11-09T14:00:46.552Z | 2024-11-09T14:00:46.552Z |
5497930 | 5497930 | 20241107060846_UkASG | USL012 | 2024-11-08T14:14:31.061Z | 2024-11-09T14:18:53.760Z |
5497908 | 5497908 | 20241107060004_2NIzy | USL012 | 2024-11-08T14:14:30.216Z | 2024-11-09T14:18:53.545Z |
5497683 | 5497683 | 20241107042817_zQtGj | USL012 | 2024-11-08T14:14:10.966Z | 2024-11-09T14:18:50.530Z |
5497656 | 5497656 | 20241107041945_lVAqm | USL012 | 2024-11-08T14:14:08.574Z | 2024-11-09T14:18:49.485Z |
5493623 | 5493623 | 20241107124529_3HLGG | USL012 | 2024-11-08T14:04:19.895Z | 2024-11-09T14:16:27.674Z |
5493586 | 5493586 | 20241107124213_pc2bN | USL012 | 2024-11-08T14:04:11.593Z | 2024-11-09T14:16:27.666Z |
5493509 | 5493509 | 20241107122321_3EuYN | USL012 | 2024-11-08T14:03:54.340Z | 2024-11-09T14:16:27.643Z |
5493424 | 5493424 | 20241107120946_PtbPW | USL012 | 2024-11-08T14:03:44.094Z | 2024-11-09T14:16:27.619Z |
5493391 | 5493391 | 20241107120132_TkCc3 | USL012 | 2024-11-08T14:03:40.350Z | 2024-11-09T14:16:27.609Z |
5493236 | 5493236 | 20241107112142_ag2TU | USL012 | 2024-11-08T14:03:15.157Z | 2024-11-09T14:16:27.565Z |
5493104 | 5493104 | 20241107105408_Se2Fo | USL012 | 2024-11-08T14:02:51.451Z | 2024-11-09T14:16:27.533Z |
5492986 | 5492986 | 20241107102930_momFu | USL012 | 2024-11-08T14:02:40.452Z | 2024-11-09T14:16:27.502Z |
5492902 | 5492902 | 20241107101748_F0pJl | USL012 | 2024-11-08T14:02:28.681Z | 2024-11-09T14:16:27.483Z |
5492893 | 5492893 | 20241107101635_2Ynf3 | USL012 | 2024-11-08T14:02:25.448Z | 2024-11-09T14:16:27.480Z |
5492823 | 5492823 | 20241107100039_NaZeg | USL012 | 2024-11-08T14:02:09.891Z | 2024-11-09T14:16:27.462Z |
5492813 | 5492813 | 20241107095822_9iOpK | USL012 | 2024-11-08T14:02:08.561Z | 2024-11-09T14:16:27.459Z |
5492782 | 5492782 | 20241107095512_y4let | USL012 | 2024-11-08T14:02:05.025Z | 2024-11-09T14:16:27.453Z |
5492586 | 5492586 | 20241107091205_avk3M | USL012 | 2024-11-08T14:01:30.363Z | 2024-11-09T14:16:27.407Z |
5492507 | 5492507 | 20241107084625_8EfuQ | USL012 | 2024-11-08T14:01:18.885Z | 2024-11-09T14:16:27.388Z |
5492390 | 5492390 | 20241107082200_msh7D | USL012 | 2024-11-08T14:00:58.733Z | 2024-11-09T14:16:27.361Z |
5492325 | 5492325 | 20241107080829_V6SwY | USL012 | 2024-11-08T14:00:46.908Z | 2024-11-09T14:16:27.344Z |
5492276 | 5492276 | 20241107075304_mnuDm | USL012 | 2024-11-08T14:00:41.045Z | 2024-11-09T14:16:27.333Z |
5492104 | 5492104 | 20241107064012_jRXb6 | USL012 | 2024-11-08T14:00:11.441Z | 2024-11-09T14:16:27.275Z |
5485446 | 5485446 | 20241105054117_rzNWw | USL012 | 2024-11-06T14:18:18.552Z | 2024-11-09T14:21:21.646Z |
5485355 | 5485355 | 20241105050147_P2Yk8 | USL012 | 2024-11-06T14:18:09.431Z | 2024-11-09T14:21:21.016Z |
5480379 | 5480379 | 20241105123754_zRDE3 | USL012 | 2024-11-06T14:05:22.858Z | 2024-11-09T14:19:23.482Z |
5480206 | 5480206 | 20241105120146_RpPbQ | USL012 | 2024-11-06T14:04:57.611Z | 2024-11-09T14:19:20.477Z |
5480099 | 5480099 | 20241105113521_xAza3 | USL012 | 2024-11-06T14:04:30.111Z | 2024-11-09T14:19:17.377Z |
5480076 | 5480076 | 20241105113020_zGOUd | USL012 | 2024-11-06T14:04:26.923Z | 2024-11-09T14:19:16.614Z |
5480066 | 5480066 | 20241105112935_cdVSz | USL012 | 2024-11-06T14:04:25.865Z | 2024-11-09T14:19:16.441Z |
5479823 | 5479823 | 20241105104635_NKtg2 | USL012 | 2024-11-06T14:03:40.103Z | 2024-11-09T14:19:12.698Z |
5479742 | 5479742 | 20241105103008_fZAB3 | USL012 | 2024-11-06T14:03:23.634Z | 2024-11-09T14:19:11.165Z |
5479703 | 5479703 | 20241105102243_2Zit2 | USL012 | 2024-11-06T14:03:07.641Z | 2024-11-09T14:19:10.644Z |
5479646 | 5479646 | 20241105100950_juwte | USL012 | 2024-11-06T14:02:58.792Z | 2024-11-09T14:19:10.158Z |
5479611 | 5479611 | 20241105100457_aVkut | USL012 | 2024-11-06T14:02:53.247Z | 2024-11-09T14:19:09.826Z |
5479529 | 5479529 | 20241105094959_dpcK6 | USL012 | 2024-11-06T14:02:41.419Z | 2024-11-09T14:19:08.415Z |
5479369 | 5479369 | 20241105091304_v3F3R | USL012 | 2024-11-06T14:02:07.448Z | 2024-11-09T14:19:04.883Z |
5479333 | 5479333 | 20241105090543_qvj5J | USL012 | 2024-11-06T14:02:02.896Z | 2024-11-09T14:19:04.315Z |
5479247 | 5479247 | 20241105084526_KrqT5 | USL012 | 2024-11-06T14:01:36.109Z | 2024-11-09T14:19:02.332Z |
5479200 | 5479200 | 20241105082850_uNW2V | USL012 | 2024-11-06T14:01:28.527Z | 2024-11-09T14:19:01.336Z |
5479188 | 5479188 | 20241105082633_OPxW4 | USL012 | 2024-11-06T14:01:23.293Z | 2024-11-09T14:19:01.126Z |
5479087 | 5479087 | 20241105080009_vyWrM | USL012 | 2024-11-06T14:00:57.906Z | 2024-11-09T14:18:59.363Z |
5479005 | 5479005 | 20241105072653_2Xv8k | USL012 | 2024-11-06T14:00:37.824Z | 2024-11-09T14:18:57.939Z |
5478957 | 5478957 | 20241105071016_ZyM19 | USL012 | 2024-11-06T14:00:27.728Z | 2024-11-09T14:18:57.084Z |
5470290 | 5470290 | 20241031061111_SCJDx | USL012 | 2024-11-04T14:25:35.639Z | 2024-11-08T14:23:27.117Z |
5470185 | 5470185 | 20241103062532_KsTJx | USL012 | 2024-11-04T14:17:53.155Z | 2024-11-09T14:23:05.858Z |
5464259 | 5464259 | 20241101062353_O20O8 | USL012 | 2024-11-03T14:22:10.303Z | 2024-11-09T14:24:37.564Z |
5464243 | 5464243 | 20241101060513_Gf0Es | USL012 | 2024-11-03T14:22:09.949Z | 2024-11-09T14:24:37.336Z |
5464240 | 5464240 | 20241101060059_4J28p | USL012 | 2024-11-03T14:22:09.916Z | 2024-11-09T14:24:37.267Z |
5464170 | 5464170 | 20241101040443_Nn2mD | USL012 | 2024-11-03T14:22:04.056Z | 2024-11-09T14:24:32.592Z |
5464159 | 5464159 | 20241101034136_030sZ | USL012 | 2024-11-03T14:22:02.756Z | 2024-11-09T14:24:31.543Z |
5459565 | 5459565 | 20241101111752_SgfKo | USL012 | 2024-11-03T14:12:18.102Z | 2024-11-09T14:23:19.581Z |
5459417 | 5459417 | 20241101105845_GkKVz | USL012 | 2024-11-03T14:11:53.070Z | 2024-11-09T14:23:17.813Z |
5459283 | 5459283 | 20241101103707_T03d3 | USL012 | 2024-11-03T14:11:37.622Z | 2024-11-09T14:23:17.304Z |
5459191 | 5459191 | 20241101102228_GFg1n | USL012 | 2024-11-03T14:11:28.850Z | 2024-11-09T14:23:16.894Z |
5459170 | 5459170 | 20241101101949_aOcji | USL012 | 2024-11-03T14:11:26.773Z | 2024-11-09T14:23:16.860Z |
5458753 | 5458753 | 20241101091250_20eKh | USL012 | 2024-11-03T14:10:34.087Z | 2024-11-09T14:23:14.184Z |
5458688 | 5458688 | 20241101090323_OAdgh | USL012 | 2024-11-03T14:10:28.228Z | 2024-11-09T14:23:13.802Z |
5458660 | 5458660 | 20241101085911_5SRiR | USL012 | 2024-11-03T14:10:17.910Z | 2024-11-09T14:23:13.465Z |
5458651 | 5458651 | 20241101085720_i2Q52 | USL012 | 2024-11-03T14:10:15.699Z | 2024-11-09T14:23:13.338Z |
5458570 | 5458570 | 20241101084419_7u1tI | USL012 | 2024-11-03T14:09:59.693Z | 2024-11-09T14:23:12.864Z |
5458445 | 5458445 | 20241101082653_WYaUH | USL012 | 2024-11-03T14:09:45.871Z | 2024-11-09T14:23:12.105Z |
5458249 | 5458249 | 20241101075117_MnbYX | USL012 | 2024-11-03T14:09:18.755Z | 2024-11-09T14:23:11.040Z |
5458219 | 5458219 | 20241101074007_27eNc | USL012 | 2024-11-03T14:09:12.005Z | 2024-11-09T14:23:10.824Z |
5458208 | 5458208 | 20241101072526_yeJtr | USL012 | 2024-11-03T14:09:07.627Z | 2024-11-09T14:23:10.124Z |
5456799 | 5456799 | 20241102122625_OBI9W | USL012 | 2024-11-03T14:05:42.416Z | 2024-11-09T14:22:45.648Z |
5456704 | 5456704 | 20241102120705_okMKo | USL012 | 2024-11-03T14:05:31.073Z | 2024-11-09T14:22:45.200Z |
5455177 | 5455177 | 20241031064655_nLYky | USL012 | 2024-11-02T12:23:32.177Z | 2024-11-08T14:23:27.758Z |
5455070 | 5455070 | 20241031062049_BiDbK | USL012 | 2024-11-02T12:23:30.345Z | 2024-11-08T14:23:27.191Z |
5455024 | 5455024 | 20241031060908_CTsnu | USL012 | 2024-11-02T12:23:29.730Z | 2024-11-08T14:23:26.895Z |
5454849 | 5454849 | 20241031053210_DR3FI | USL012 | 2024-11-02T12:23:24.942Z | 2024-11-08T14:23:25.938Z |
5454799 | 5454799 | 20241031052011_U5DsG | USL012 | 2024-11-02T12:23:23.710Z | 2024-11-08T14:23:25.682Z |
5454235 | 5454235 | 20241031040112_vnzyT | USL012 | 2024-11-02T12:22:55.628Z | 2024-11-08T14:23:21.662Z |
5448043 | 5448043 | 20241031123600_3LbLf | USL012 | 2024-11-02T12:09:49.754Z | 2024-11-09T14:24:02.540Z |
5447910 | 5447910 | 20241031122220_FNnLV | USL012 | 2024-11-02T12:09:25.038Z | 2024-11-09T14:24:01.637Z |
5447659 | 5447659 | 20241031115957_aQUY3 | USL012 | 2024-11-02T12:08:45.915Z | 2024-11-09T14:24:00.706Z |
5447608 | 5447608 | 20241031115618_0BI51 | USL012 | 2024-11-02T12:08:38.766Z | 2024-11-09T14:24:00.596Z |
5447286 | 5447286 | 20241031112722_th664 | USL012 | 2024-11-02T12:07:41.793Z | 2024-11-09T14:23:58.736Z |
5447274 | 5447274 | 20241031112613_KV1YX | USL012 | 2024-11-02T12:07:40.545Z | 2024-11-09T14:23:58.516Z |
5447208 | 5447208 | 20241031111759_UCBvb | USL012 | 2024-11-02T12:07:29.268Z | 2024-11-09T14:23:58.274Z |
5447041 | 5447041 | 20241031110121_3g7SN | USL012 | 2024-11-02T12:06:59.009Z | 2024-11-09T14:23:57.487Z |
5446996 | 5446996 | 20241031105519_Q7BGr | USL012 | 2024-11-02T12:06:51.578Z | 2024-11-09T14:23:57.329Z |
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);