participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,868 rows where station_code = "UK009S" 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 |
---|---|---|---|---|---|
5570048 | 5570048 | 20241120182936_zfOy8 | UK009S | 2024-11-22T14:14:47.258Z | 2024-11-22T14:19:21.851Z |
5570029 | 5570029 | 20241120182539_VESN6 | UK009S | 2024-11-22T14:14:46.056Z | 2024-11-22T14:19:21.849Z |
5569813 | 5569813 | 20241120173541_2oF5y | UK009S | 2024-11-22T14:14:15.966Z | 2024-11-22T14:19:21.810Z |
5565474 | 5565474 | 20241120042920_9KRta | UK009S | 2024-11-21T14:18:50.200Z | 2024-11-22T14:21:47.482Z |
5565443 | 5565443 | 20241120042605_p4qsS | UK009S | 2024-11-21T14:18:49.326Z | 2024-11-22T14:21:47.207Z |
5565408 | 5565408 | 20241120042321_CbdS2 | UK009S | 2024-11-21T14:18:48.147Z | 2024-11-22T14:21:46.483Z |
5565380 | 5565380 | 20241120042149_x4jjK | UK009S | 2024-11-21T14:18:47.561Z | 2024-11-22T14:21:46.292Z |
5565166 | 5565166 | 20241120035838_c3qp1 | UK009S | 2024-11-21T14:18:34.726Z | 2024-11-22T14:21:42.810Z |
5565147 | 5565147 | 20241120035640_BCjQl | UK009S | 2024-11-21T14:18:33.821Z | 2024-11-22T14:21:42.569Z |
5565118 | 5565118 | 20241120035257_J2769 | UK009S | 2024-11-21T14:18:31.286Z | 2024-11-22T14:21:41.812Z |
5564937 | 5564937 | 20241120034010_Iiau5 | UK009S | 2024-11-21T14:18:15.598Z | 2024-11-22T14:21:39.661Z |
5564930 | 5564930 | 20241120033942_SXlR2 | UK009S | 2024-11-21T14:18:15.432Z | 2024-11-22T14:21:39.654Z |
5564778 | 5564778 | 20241120032537_O9I35 | UK009S | 2024-11-21T14:18:02.738Z | 2024-11-22T14:21:36.330Z |
5564769 | 5564769 | 20241120032522_PLRQM | UK009S | 2024-11-21T14:18:02.524Z | 2024-11-22T14:21:36.329Z |
5564762 | 5564762 | 20241120032509_aOjw1 | UK009S | 2024-11-21T14:18:02.512Z | 2024-11-22T14:21:36.319Z |
5564734 | 5564734 | 20241120032404_SX2pG | UK009S | 2024-11-21T14:18:01.085Z | 2024-11-22T14:21:36.073Z |
5564702 | 5564702 | 20241120032124_6mw4v | UK009S | 2024-11-21T14:17:58.786Z | 2024-11-22T14:21:35.740Z |
5564665 | 5564665 | 20241120031711_01xdN | UK009S | 2024-11-21T14:17:56.524Z | 2024-11-22T14:21:35.175Z |
5564597 | 5564597 | 20241120031206_WOsiJ | UK009S | 2024-11-21T14:17:52.290Z | 2024-11-22T14:21:33.947Z |
5564517 | 5564517 | 20241120030524_q8bDr | UK009S | 2024-11-21T14:17:44.796Z | 2024-11-22T14:21:33.099Z |
5564327 | 5564327 | 20241120024821_HgXM0 | UK009S | 2024-11-21T14:17:27.541Z | 2024-11-22T14:21:30.498Z |
5564103 | 5564103 | 20241120022833_wJJzG | UK009S | 2024-11-21T14:17:09.904Z | 2024-11-22T14:21:26.919Z |
5564044 | 5564044 | 20241120022502_zIoHJ | UK009S | 2024-11-21T14:17:06.031Z | 2024-11-22T14:21:26.659Z |
5563932 | 5563932 | 20241120021657_hKzAn | UK009S | 2024-11-21T14:16:59.251Z | 2024-11-22T14:21:25.537Z |
5563651 | 5563651 | 20241120015430_O6XYk | UK009S | 2024-11-21T14:16:31.604Z | 2024-11-22T14:21:20.309Z |
5563316 | 5563316 | 20241120011610_CVvcP | UK009S | 2024-11-21T14:15:52.810Z | 2024-11-22T14:21:12.856Z |
5563190 | 5563190 | 20241120010334_JwEWt | UK009S | 2024-11-21T14:15:40.104Z | 2024-11-22T14:21:10.629Z |
5563044 | 5563044 | 20241120004451_7pxI9 | UK009S | 2024-11-21T14:15:32.581Z | 2024-11-22T14:21:07.941Z |
5562770 | 5562770 | 20241120001011_bzvpf | UK009S | 2024-11-21T14:15:20.858Z | 2024-11-22T14:21:03.672Z |
5562579 | 5562579 | 20241119235306_Nak4W | UK009S | 2024-11-21T14:15:10.815Z | 2024-11-22T14:21:00.730Z |
5562548 | 5562548 | 20241119235114_Ut22e | UK009S | 2024-11-21T14:15:07.979Z | 2024-11-22T14:21:00.245Z |
5562540 | 5562540 | 20241119234903_NDZLV | UK009S | 2024-11-21T14:15:06.632Z | 2024-11-22T14:21:00.014Z |
5562304 | 5562304 | 20241119232023_Fqa4N | UK009S | 2024-11-21T14:14:41.402Z | 2024-11-22T14:20:55.637Z |
5562262 | 5562262 | 20241119231747_w28Oy | UK009S | 2024-11-21T14:14:39.043Z | 2024-11-22T14:20:54.881Z |
5562189 | 5562189 | 20241119230853_SBsHs | UK009S | 2024-11-21T14:14:31.459Z | 2024-11-22T14:20:53.868Z |
5562158 | 5562158 | 20241119230623_Tyc0K | UK009S | 2024-11-21T14:14:29.368Z | 2024-11-22T14:20:53.498Z |
5562003 | 5562003 | 20241119224222_diDSH | UK009S | 2024-11-21T14:14:19.090Z | 2024-11-22T14:20:51.085Z |
5561470 | 5561470 | 20241119204240_EhpUm | UK009S | 2024-11-21T14:13:19.598Z | 2024-11-22T14:20:37.625Z |
5561241 | 5561241 | 20241119191505_pRdrh | UK009S | 2024-11-21T14:12:43.757Z | 2024-11-22T14:20:27.219Z |
5561215 | 5561215 | 20241119190437_nD0So | UK009S | 2024-11-21T14:12:38.709Z | 2024-11-22T14:20:26.382Z |
5561166 | 5561166 | 20241119184525_tI2zK | UK009S | 2024-11-21T14:12:31.902Z | 2024-11-22T14:20:23.804Z |
5561085 | 5561085 | 20241119180238_2olzW | UK009S | 2024-11-21T14:12:21.309Z | 2024-11-22T14:20:19.633Z |
5557371 | 5557371 | 20241120044111_M0LK2 | UK009S | 2024-11-21T14:00:37.720Z | 2024-11-22T14:19:21.058Z |
5557296 | 5557296 | 20241120043408_HlMfl | UK009S | 2024-11-21T14:00:27.134Z | 2024-11-22T14:19:21.049Z |
5543830 | 5543830 | 20241115034709_W791j | UK009S | 2024-11-16T14:07:21.590Z | 2024-11-22T14:24:01.795Z |
5543813 | 5543813 | 20241115034012_nWmIM | UK009S | 2024-11-16T14:07:17.088Z | 2024-11-22T14:24:01.685Z |
5543756 | 5543756 | 20241115031842_D96BS | UK009S | 2024-11-16T14:07:08.874Z | 2024-11-22T14:24:01.262Z |
5543744 | 5543744 | 20241115031529_3L0Yy | UK009S | 2024-11-16T14:07:07.383Z | 2024-11-22T14:24:01.108Z |
5543710 | 5543710 | 20241115030315_yR23r | UK009S | 2024-11-16T14:07:03.638Z | 2024-11-22T14:24:00.866Z |
5543705 | 5543705 | 20241115030201_DwSZR | UK009S | 2024-11-16T14:07:03.356Z | 2024-11-22T14:24:00.856Z |
5543654 | 5543654 | 20241115024254_rW6gI | UK009S | 2024-11-16T14:06:58.263Z | 2024-11-22T14:24:00.574Z |
5543639 | 5543639 | 20241115024117_L5aPX | UK009S | 2024-11-16T14:06:57.729Z | 2024-11-22T14:24:00.548Z |
5543627 | 5543627 | 20241115023831_ccU2s | UK009S | 2024-11-16T14:06:57.041Z | 2024-11-22T14:24:00.520Z |
5543608 | 5543608 | 20241115022653_8LRO6 | UK009S | 2024-11-16T14:06:55.220Z | 2024-11-22T14:24:00.350Z |
5543586 | 5543586 | 20241115022127_ugKWc | UK009S | 2024-11-16T14:06:53.044Z | 2024-11-22T14:24:00.214Z |
5543555 | 5543555 | 20241115020124_PBJHy | UK009S | 2024-11-16T14:06:40.513Z | 2024-11-22T14:23:59.992Z |
5543513 | 5543513 | 20241115015212_Wh8vE | UK009S | 2024-11-16T14:06:34.055Z | 2024-11-22T14:23:59.819Z |
5543501 | 5543501 | 20241115014742_feGyp | UK009S | 2024-11-16T14:06:32.177Z | 2024-11-22T14:23:59.730Z |
5543497 | 5543497 | 20241115014728_6SQi4 | UK009S | 2024-11-16T14:06:31.983Z | 2024-11-22T14:23:59.724Z |
5543456 | 5543456 | 20241115012859_dQ8jg | UK009S | 2024-11-16T14:06:23.801Z | 2024-11-22T14:23:59.371Z |
5543433 | 5543433 | 20241115012149_0Odkx | UK009S | 2024-11-16T14:06:20.119Z | 2024-11-22T14:23:59.346Z |
5543383 | 5543383 | 20241115004955_VMucr | UK009S | 2024-11-16T14:06:12.325Z | 2024-11-22T14:23:58.494Z |
5543363 | 5543363 | 20241115003749_VDPMs | UK009S | 2024-11-16T14:06:08.948Z | 2024-11-22T14:23:58.389Z |
5543336 | 5543336 | 20241115001812_9T6B2 | UK009S | 2024-11-16T14:06:07.272Z | 2024-11-22T14:23:58.309Z |
5543333 | 5543333 | 20241115001755_FrgIW | UK009S | 2024-11-16T14:06:06.985Z | 2024-11-22T14:23:58.291Z |
5543321 | 5543321 | 20241115001013_3w5J3 | UK009S | 2024-11-16T14:06:05.468Z | 2024-11-22T14:23:58.171Z |
5543288 | 5543288 | 20241114234951_Rx6zR | UK009S | 2024-11-16T14:06:00.276Z | 2024-11-22T14:23:57.911Z |
5543269 | 5543269 | 20241114233508_gu9X1 | UK009S | 2024-11-16T14:05:56.617Z | 2024-11-22T14:23:57.825Z |
5543238 | 5543238 | 20241114231943_VA9xx | UK009S | 2024-11-16T14:05:48.904Z | 2024-11-22T14:23:57.670Z |
5543204 | 5543204 | 20241114230055_krM5u | UK009S | 2024-11-16T14:05:43.374Z | 2024-11-22T14:23:57.446Z |
5543200 | 5543200 | 20241114225455_FEefJ | UK009S | 2024-11-16T14:05:42.967Z | 2024-11-22T14:23:57.437Z |
5543196 | 5543196 | 20241114225317_12wdV | UK009S | 2024-11-16T14:05:42.592Z | 2024-11-22T14:23:57.424Z |
5543150 | 5543150 | 20241114215307_Lw0As | UK009S | 2024-11-16T14:05:37.277Z | 2024-11-22T14:23:57.210Z |
5543142 | 5543142 | 20241114214953_HFqqh | UK009S | 2024-11-16T14:05:36.885Z | 2024-11-22T14:23:57.176Z |
5542141 | 5542141 | 20241115060309_aDrjF | UK009S | 2024-11-16T14:00:23.788Z | 2024-11-22T14:23:23.420Z |
5541385 | 5541385 | 20241114011551_Jxbyg | UK009S | 2024-11-15T14:07:32.918Z | 2024-11-22T14:24:18.462Z |
5541359 | 5541359 | 20241114005255_8EJGX | UK009S | 2024-11-15T14:07:30.611Z | 2024-11-22T14:24:18.301Z |
5541222 | 5541222 | 20241113202056_875UL | UK009S | 2024-11-15T14:06:58.278Z | 2024-11-22T14:24:17.114Z |
5541199 | 5541199 | 20241113192754_ZFMqQ | UK009S | 2024-11-15T14:06:54.411Z | 2024-11-22T14:24:16.494Z |
5541194 | 5541194 | 20241113192257_1cxL2 | UK009S | 2024-11-15T14:06:52.401Z | 2024-11-22T14:24:16.453Z |
5541186 | 5541186 | 20241113185414_ZHH2T | UK009S | 2024-11-15T14:06:51.355Z | 2024-11-22T14:24:16.340Z |
5538258 | 5538258 | 20241113025308_gCNXP | UK009S | 2024-11-14T14:13:10.087Z | 2024-11-21T14:26:22.834Z |
5538243 | 5538243 | 20241113024647_MUBqN | UK009S | 2024-11-14T14:13:08.372Z | 2024-11-21T14:26:22.618Z |
5538134 | 5538134 | 20241113021819_bV7Ec | UK009S | 2024-11-14T14:12:54.232Z | 2024-11-21T14:26:20.991Z |
5538032 | 5538032 | 20241113015739_Vum20 | UK009S | 2024-11-14T14:12:45.132Z | 2024-11-21T14:26:19.438Z |
5537963 | 5537963 | 20241113014402_hUug2 | UK009S | 2024-11-14T14:12:40.164Z | 2024-11-21T14:26:17.498Z |
5537923 | 5537923 | 20241113013100_oLZ3e | UK009S | 2024-11-14T14:12:37.830Z | 2024-11-21T14:26:17.257Z |
5537574 | 5537574 | 20241112234147_IGlZ0 | UK009S | 2024-11-14T14:12:11.456Z | 2024-11-21T14:26:14.519Z |
5537561 | 5537561 | 20241112233940_YLQYz | UK009S | 2024-11-14T14:12:09.814Z | 2024-11-21T14:26:14.184Z |
5537384 | 5537384 | 20241112223245_sI5A0 | UK009S | 2024-11-14T14:11:43.282Z | 2024-11-21T14:26:11.840Z |
5537274 | 5537274 | 20241112214520_CHAtW | UK009S | 2024-11-14T14:11:29.647Z | 2024-11-21T14:26:10.762Z |
5537253 | 5537253 | 20241112213052_V5g2j | UK009S | 2024-11-14T14:11:27.196Z | 2024-11-21T14:26:10.701Z |
5537251 | 5537251 | 20241112212708_AQhEE | UK009S | 2024-11-14T14:11:25.544Z | 2024-11-21T14:26:10.683Z |
5537118 | 5537118 | 20241112202943_X264Q | UK009S | 2024-11-14T14:11:04.083Z | 2024-11-21T14:26:09.101Z |
5537108 | 5537108 | 20241112202828_71a8G | UK009S | 2024-11-14T14:11:03.193Z | 2024-11-21T14:26:08.857Z |
5536480 | 5536480 | 20241112181134_vf2eH | UK009S | 2024-11-14T14:10:02.632Z | 2024-11-21T14:26:01.279Z |
5536441 | 5536441 | 20241112180300_6kbEW | UK009S | 2024-11-14T14:09:57.058Z | 2024-11-21T14:26:00.958Z |
5532705 | 5532705 | 20241112055354_42gIk | UK009S | 2024-11-13T14:17:10.755Z | 2024-11-20T14:26:25.716Z |
5532419 | 5532419 | 20241112051905_73Gir | UK009S | 2024-11-13T14:16:43.359Z | 2024-11-20T14:26:22.752Z |
5532253 | 5532253 | 20241112045757_YnuNA | UK009S | 2024-11-13T14:16:31.520Z | 2024-11-20T14:26:21.433Z |
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);