participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "US0006" 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 |
---|---|---|---|---|---|
5565364 | 5565364 | 20241120042113_qvt7C | US0006 | 2024-11-21T14:18:47.200Z | 2024-11-21T14:18:54.198Z |
5564219 | 5564219 | 20241120024017_t7O4e | US0006 | 2024-11-21T14:17:20.367Z | 2024-11-21T14:18:54.006Z |
5563665 | 5563665 | 20241120015612_kugBq | US0006 | 2024-11-21T14:16:33.114Z | 2024-11-21T14:18:53.898Z |
5560411 | 5560411 | 20241120124845_wk3zR | US0006 | 2024-11-21T14:08:48.482Z | 2024-11-21T14:08:48.482Z |
5560386 | 5560386 | 20241120124624_n2peD | US0006 | 2024-11-21T14:08:46.719Z | 2024-11-21T14:08:46.719Z |
5560360 | 5560360 | 20241120124206_8CPj5 | US0006 | 2024-11-21T14:08:44.400Z | 2024-11-21T14:08:44.400Z |
5560307 | 5560307 | 20241120123322_Tap3g | US0006 | 2024-11-21T14:08:34.843Z | 2024-11-21T14:08:34.843Z |
5560220 | 5560220 | 20241120122004_YDUsJ | US0006 | 2024-11-21T14:08:18.869Z | 2024-11-21T14:08:18.869Z |
5560215 | 5560215 | 20241120121926_3uiqk | US0006 | 2024-11-21T14:08:17.988Z | 2024-11-21T14:08:17.988Z |
5560199 | 5560199 | 20241120121744_rVDl5 | US0006 | 2024-11-21T14:08:15.109Z | 2024-11-21T14:08:15.109Z |
5560162 | 5560162 | 20241120120921_vuXO6 | US0006 | 2024-11-21T14:08:10.161Z | 2024-11-21T14:08:10.161Z |
5559932 | 5559932 | 20241120113555_Zrbn3 | US0006 | 2024-11-21T14:07:36.164Z | 2024-11-21T14:07:36.164Z |
5559739 | 5559739 | 20241120111107_lR8WU | US0006 | 2024-11-21T14:07:05.653Z | 2024-11-21T14:07:05.653Z |
5559719 | 5559719 | 20241120110619_eNtCO | US0006 | 2024-11-21T14:07:03.032Z | 2024-11-21T14:07:03.032Z |
5559712 | 5559712 | 20241120110423_WrMm6 | US0006 | 2024-11-21T14:07:02.236Z | 2024-11-21T14:07:02.236Z |
5559588 | 5559588 | 20241120104650_fQTT7 | US0006 | 2024-11-21T14:06:41.016Z | 2024-11-21T14:06:41.016Z |
5559563 | 5559563 | 20241120104417_7eBIf | US0006 | 2024-11-21T14:06:36.976Z | 2024-11-21T14:06:36.976Z |
5559416 | 5559416 | 20241120102055_y74fx | US0006 | 2024-11-21T14:06:16.836Z | 2024-11-21T14:06:16.836Z |
5559201 | 5559201 | 20241120093740_uhPWs | US0006 | 2024-11-21T14:05:36.141Z | 2024-11-21T14:05:36.141Z |
5559157 | 5559157 | 20241120093052_jitOH | US0006 | 2024-11-21T14:05:29.765Z | 2024-11-21T14:05:29.765Z |
5559074 | 5559074 | 20241120091701_8NIQG | US0006 | 2024-11-21T14:05:14.436Z | 2024-11-21T14:05:14.436Z |
5559013 | 5559013 | 20241120090455_fnMBM | US0006 | 2024-11-21T14:05:02.769Z | 2024-11-21T14:05:02.769Z |
5558894 | 5558894 | 20241120084540_f6Xgh | US0006 | 2024-11-21T14:04:45.202Z | 2024-11-21T14:04:45.202Z |
5558832 | 5558832 | 20241120082228_hOIjN | US0006 | 2024-11-21T14:04:32.316Z | 2024-11-21T14:04:32.316Z |
5558633 | 5558633 | 20241120071304_AEafU | US0006 | 2024-11-21T14:03:53.775Z | 2024-11-21T14:03:53.775Z |
5558592 | 5558592 | 20241120064844_fBm5z | US0006 | 2024-11-21T14:03:46.169Z | 2024-11-21T14:03:46.169Z |
5558398 | 5558398 | 20241120060149_4Ol7n | US0006 | 2024-11-21T14:03:11.757Z | 2024-11-21T14:03:11.757Z |
5558361 | 5558361 | 20241120055914_ojZjX | US0006 | 2024-11-21T14:03:07.494Z | 2024-11-21T14:03:07.494Z |
5558359 | 5558359 | 20241120055851_NYn8u | US0006 | 2024-11-21T14:03:07.046Z | 2024-11-21T14:03:07.046Z |
5558280 | 5558280 | 20241120055153_2F7WU | US0006 | 2024-11-21T14:02:55.658Z | 2024-11-21T14:02:55.658Z |
5557373 | 5557373 | 20241120044131_O8lWX | US0006 | 2024-11-21T14:00:38.609Z | 2024-11-21T14:00:38.609Z |
5556856 | 5556856 | 20241119021848_wF5HJ | US0006 | 2024-11-20T14:11:34.605Z | 2024-11-21T14:20:37.438Z |
5556781 | 5556781 | 20241119014850_8mG68 | US0006 | 2024-11-20T14:11:27.647Z | 2024-11-21T14:20:35.091Z |
5555149 | 5555149 | 20241119115610_2hySj | US0006 | 2024-11-20T14:04:34.137Z | 2024-11-21T14:18:53.212Z |
5555111 | 5555111 | 20241119114723_i11BM | US0006 | 2024-11-20T14:04:28.791Z | 2024-11-21T14:18:53.204Z |
5555092 | 5555092 | 20241119114227_5KXIg | US0006 | 2024-11-20T14:04:26.906Z | 2024-11-21T14:18:53.201Z |
5555025 | 5555025 | 20241119112312_DrkRp | US0006 | 2024-11-20T14:04:08.961Z | 2024-11-21T14:18:53.186Z |
5554988 | 5554988 | 20241119111718_9DduN | US0006 | 2024-11-20T14:04:01.062Z | 2024-11-21T14:18:53.179Z |
5554827 | 5554827 | 20241119104527_zDAeM | US0006 | 2024-11-20T14:03:24.709Z | 2024-11-21T14:18:53.142Z |
5554757 | 5554757 | 20241119102956_cr80e | US0006 | 2024-11-20T14:03:12.615Z | 2024-11-21T14:18:53.126Z |
5554649 | 5554649 | 20241119095846_5GD4Q | US0006 | 2024-11-20T14:02:56.489Z | 2024-11-21T14:18:53.103Z |
5554642 | 5554642 | 20241119095357_9cdtI | US0006 | 2024-11-20T14:02:55.257Z | 2024-11-21T14:18:53.101Z |
5554631 | 5554631 | 20241119095200_7BJ3N | US0006 | 2024-11-20T14:02:51.474Z | 2024-11-21T14:18:53.099Z |
5554603 | 5554603 | 20241119094740_iaLxl | US0006 | 2024-11-20T14:02:37.136Z | 2024-11-21T14:18:53.092Z |
5554549 | 5554549 | 20241119093258_Agdn5 | US0006 | 2024-11-20T14:02:25.744Z | 2024-11-21T14:18:53.079Z |
5554527 | 5554527 | 20241119092708_wbI2m | US0006 | 2024-11-20T14:02:22.278Z | 2024-11-21T14:18:53.075Z |
5554522 | 5554522 | 20241119092626_1AYY3 | US0006 | 2024-11-20T14:02:21.829Z | 2024-11-21T14:18:53.074Z |
5554415 | 5554415 | 20241119084808_FKShj | US0006 | 2024-11-20T14:01:58.432Z | 2024-11-21T14:18:53.051Z |
5554014 | 5554014 | 20241119052646_LEzk9 | US0006 | 2024-11-20T14:00:24.353Z | 2024-11-21T14:18:52.956Z |
5551198 | 5551198 | 20241118124353_4kcFF | US0006 | 2024-11-19T14:04:06.138Z | 2024-11-21T14:19:45.677Z |
5550892 | 5550892 | 20241118114430_2YgCU | US0006 | 2024-11-19T14:03:20.565Z | 2024-11-21T14:19:36.605Z |
5550840 | 5550840 | 20241118113443_arkXA | US0006 | 2024-11-19T14:03:11.847Z | 2024-11-21T14:19:34.404Z |
5550803 | 5550803 | 20241118113034_zZhuK | US0006 | 2024-11-19T14:03:08.050Z | 2024-11-21T14:19:33.294Z |
5546684 | 5546684 | 20241117121359_nnPdV | US0006 | 2024-11-18T14:03:49.305Z | 2024-11-21T14:21:24.105Z |
5545971 | 5545971 | 20241117082926_QI5Gk | US0006 | 2024-11-18T14:01:36.340Z | 2024-11-21T14:21:07.273Z |
5545790 | 5545790 | 20241117070029_ZtbJW | US0006 | 2024-11-18T14:00:58.065Z | 2024-11-21T14:21:00.418Z |
5544570 | 5544570 | 20241116124033_yFlNe | US0006 | 2024-11-17T14:01:35.229Z | 2024-11-21T14:22:36.934Z |
5544566 | 5544566 | 20241116124023_KEP0H | US0006 | 2024-11-17T14:01:34.839Z | 2024-11-21T14:22:36.914Z |
5544512 | 5544512 | 20241116120324_gSWAz | US0006 | 2024-11-17T14:01:21.813Z | 2024-11-21T14:22:35.407Z |
5544472 | 5544472 | 20241116114047_v1YKd | US0006 | 2024-11-17T14:01:15.714Z | 2024-11-21T14:22:34.468Z |
5544446 | 5544446 | 20241116111320_G6iQP | US0006 | 2024-11-17T14:01:10.976Z | 2024-11-21T14:22:34.123Z |
5544425 | 5544425 | 20241116105730_qvIwd | US0006 | 2024-11-17T14:01:06.965Z | 2024-11-21T14:22:33.507Z |
5544354 | 5544354 | 20241116101825_j6eQO | US0006 | 2024-11-17T14:00:56.013Z | 2024-11-21T14:22:32.098Z |
5544332 | 5544332 | 20241116100530_aK8k5 | US0006 | 2024-11-17T14:00:52.860Z | 2024-11-21T14:22:31.439Z |
5544316 | 5544316 | 20241116095741_sqi6o | US0006 | 2024-11-17T14:00:50.786Z | 2024-11-21T14:22:31.076Z |
5544297 | 5544297 | 20241116094427_XiUuj | US0006 | 2024-11-17T14:00:48.305Z | 2024-11-21T14:22:30.618Z |
5544292 | 5544292 | 20241116094321_4KV15 | US0006 | 2024-11-17T14:00:46.963Z | 2024-11-21T14:22:30.486Z |
5544200 | 5544200 | 20241116080742_cKmTO | US0006 | 2024-11-17T14:00:26.887Z | 2024-11-21T14:22:28.508Z |
5544180 | 5544180 | 20241116073220_d4x7f | US0006 | 2024-11-17T14:00:23.990Z | 2024-11-21T14:22:28.339Z |
5544145 | 5544145 | 20241116065946_p4koy | US0006 | 2024-11-17T14:00:18.941Z | 2024-11-21T14:22:28.000Z |
5544133 | 5544133 | 20241116064621_xlj6J | US0006 | 2024-11-17T14:00:17.765Z | 2024-11-21T14:22:27.916Z |
5544022 | 5544022 | 20241115051651_lTIf4 | US0006 | 2024-11-16T14:07:49.755Z | 2024-11-21T14:24:37.806Z |
5543875 | 5543875 | 20241115035809_6IKd4 | US0006 | 2024-11-16T14:07:34.738Z | 2024-11-21T14:24:35.462Z |
5543832 | 5543832 | 20241115034715_uVxK2 | US0006 | 2024-11-16T14:07:22.059Z | 2024-11-21T14:24:34.482Z |
5542770 | 5542770 | 20241115122520_SnltS | US0006 | 2024-11-16T14:02:30.910Z | 2024-11-21T14:23:34.763Z |
5542723 | 5542723 | 20241115120627_vADOJ | US0006 | 2024-11-16T14:02:17.027Z | 2024-11-21T14:23:33.980Z |
5542694 | 5542694 | 20241115115210_dSeK5 | US0006 | 2024-11-16T14:02:12.603Z | 2024-11-21T14:23:33.305Z |
5542683 | 5542683 | 20241115114731_O524K | US0006 | 2024-11-16T14:02:11.254Z | 2024-11-21T14:23:33.256Z |
5542660 | 5542660 | 20241115113951_42Fk1 | US0006 | 2024-11-16T14:02:08.787Z | 2024-11-21T14:23:32.908Z |
5542648 | 5542648 | 20241115113108_K8SxK | US0006 | 2024-11-16T14:02:06.856Z | 2024-11-21T14:23:32.441Z |
5542555 | 5542555 | 20241115105510_T20L0 | US0006 | 2024-11-16T14:01:46.095Z | 2024-11-21T14:23:29.617Z |
5542551 | 5542551 | 20241115105357_9DPmL | US0006 | 2024-11-16T14:01:45.207Z | 2024-11-21T14:23:29.568Z |
5542514 | 5542514 | 20241115103556_s90QS | US0006 | 2024-11-16T14:01:33.704Z | 2024-11-21T14:23:28.939Z |
5542464 | 5542464 | 20241115095906_GWnHi | US0006 | 2024-11-16T14:01:25.881Z | 2024-11-21T14:23:27.761Z |
5542436 | 5542436 | 20241115094411_2NCaI | US0006 | 2024-11-16T14:01:16.582Z | 2024-11-21T14:23:27.207Z |
5542411 | 5542411 | 20241115091909_hiUwO | US0006 | 2024-11-16T14:01:12.911Z | 2024-11-21T14:23:26.840Z |
5542398 | 5542398 | 20241115091334_Baq5G | US0006 | 2024-11-16T14:01:09.512Z | 2024-11-21T14:23:26.556Z |
5542353 | 5542353 | 20241115085315_17jAP | US0006 | 2024-11-16T14:01:02.873Z | 2024-11-21T14:23:25.987Z |
5542314 | 5542314 | 20241115082402_7as0Z | US0006 | 2024-11-16T14:00:57.570Z | 2024-11-21T14:23:25.248Z |
5542189 | 5542189 | 20241115065826_9VgqP | US0006 | 2024-11-16T14:00:34.564Z | 2024-11-21T14:23:22.491Z |
5542185 | 5542185 | 20241115065303_vepg3 | US0006 | 2024-11-16T14:00:33.279Z | 2024-11-21T14:23:22.069Z |
5542177 | 5542177 | 20241115064110_gYiXM | US0006 | 2024-11-16T14:00:30.695Z | 2024-11-21T14:23:21.993Z |
5541009 | 5541009 | 20241114124446_uwqGP | US0006 | 2024-11-15T14:04:56.180Z | 2024-11-21T14:24:18.279Z |
5540997 | 5540997 | 20241114124222_VNsGI | US0006 | 2024-11-15T14:04:54.906Z | 2024-11-21T14:24:18.167Z |
5540980 | 5540980 | 20241114123817_tUSRt | US0006 | 2024-11-15T14:04:53.640Z | 2024-11-21T14:24:17.933Z |
5540966 | 5540966 | 20241114123515_p8Rw4 | US0006 | 2024-11-15T14:04:51.988Z | 2024-11-21T14:24:17.656Z |
5540818 | 5540818 | 20241114121119_J2ECc | US0006 | 2024-11-15T14:04:31.561Z | 2024-11-21T14:24:16.564Z |
5540795 | 5540795 | 20241114120601_Q5Bk4 | US0006 | 2024-11-15T14:04:28.811Z | 2024-11-21T14:24:16.419Z |
5540431 | 5540431 | 20241114110511_w2Vs2 | US0006 | 2024-11-15T14:03:46.044Z | 2024-11-21T14:24:11.248Z |
5540384 | 5540384 | 20241114105242_OnkfU | US0006 | 2024-11-15T14:03:33.622Z | 2024-11-21T14:24:10.994Z |
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);