participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "US000E" 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 |
---|---|---|---|---|---|
5565366 | 5565366 | 20241120042113_qvt7C | US000E | 2024-11-21T14:18:47.200Z | 2024-11-21T14:18:54.198Z |
5565059 | 5565059 | 20241120034732_ZPyDE | US000E | 2024-11-21T14:18:26.044Z | 2024-11-21T14:18:54.147Z |
5564707 | 5564707 | 20241120032130_73XAl | US000E | 2024-11-21T14:17:58.993Z | 2024-11-21T14:18:54.086Z |
5564610 | 5564610 | 20241120031406_xl83i | US000E | 2024-11-21T14:17:53.050Z | 2024-11-21T14:18:54.071Z |
5564220 | 5564220 | 20241120024017_t7O4e | US000E | 2024-11-21T14:17:20.367Z | 2024-11-21T14:18:54.006Z |
5563738 | 5563738 | 20241120020032_2rUsg | US000E | 2024-11-21T14:16:37.452Z | 2024-11-21T14:18:53.906Z |
5563666 | 5563666 | 20241120015612_kugBq | US000E | 2024-11-21T14:16:33.114Z | 2024-11-21T14:18:53.898Z |
5560389 | 5560389 | 20241120124624_n2peD | US000E | 2024-11-21T14:08:46.719Z | 2024-11-21T14:08:46.719Z |
5560334 | 5560334 | 20241120123909_6eJF1 | US000E | 2024-11-21T14:08:41.320Z | 2024-11-21T14:08:41.320Z |
5560302 | 5560302 | 20241120123241_YPwOE | US000E | 2024-11-21T14:08:33.740Z | 2024-11-21T14:08:33.740Z |
5560163 | 5560163 | 20241120120921_vuXO6 | US000E | 2024-11-21T14:08:10.161Z | 2024-11-21T14:08:10.161Z |
5560123 | 5560123 | 20241120120439_0C0Bu | US000E | 2024-11-21T14:08:06.062Z | 2024-11-21T14:08:06.062Z |
5560088 | 5560088 | 20241120115758_E2N2i | US000E | 2024-11-21T14:08:01.420Z | 2024-11-21T14:08:01.420Z |
5559969 | 5559969 | 20241120113949_IFWsQ | US000E | 2024-11-21T14:07:42.590Z | 2024-11-21T14:07:42.590Z |
5559849 | 5559849 | 20241120112402_LV93V | US000E | 2024-11-21T14:07:19.920Z | 2024-11-21T14:07:19.920Z |
5559794 | 5559794 | 20241120111817_JE5Wq | US000E | 2024-11-21T14:07:12.278Z | 2024-11-21T14:07:12.278Z |
5559786 | 5559786 | 20241120111713_Q9xRR | US000E | 2024-11-21T14:07:11.144Z | 2024-11-21T14:07:11.144Z |
5559715 | 5559715 | 20241120110423_WrMm6 | US000E | 2024-11-21T14:07:02.236Z | 2024-11-21T14:07:02.236Z |
5559679 | 5559679 | 20241120105735_S3zXY | US000E | 2024-11-21T14:06:56.880Z | 2024-11-21T14:06:56.880Z |
5559580 | 5559580 | 20241120104505_JR6hc | US000E | 2024-11-21T14:06:39.234Z | 2024-11-21T14:06:39.234Z |
5559564 | 5559564 | 20241120104417_7eBIf | US000E | 2024-11-21T14:06:36.976Z | 2024-11-21T14:06:36.976Z |
5559549 | 5559549 | 20241120104129_Cciva | US000E | 2024-11-21T14:06:34.903Z | 2024-11-21T14:06:34.903Z |
5559509 | 5559509 | 20241120103559_bbyj1 | US000E | 2024-11-21T14:06:29.704Z | 2024-11-21T14:06:29.704Z |
5559489 | 5559489 | 20241120103250_mGn5q | US000E | 2024-11-21T14:06:26.827Z | 2024-11-21T14:06:26.827Z |
5559479 | 5559479 | 20241120102848_y8IIN | US000E | 2024-11-21T14:06:25.325Z | 2024-11-21T14:06:25.325Z |
5559442 | 5559442 | 20241120102354_ZRE9o | US000E | 2024-11-21T14:06:20.841Z | 2024-11-21T14:06:20.841Z |
5559431 | 5559431 | 20241120102212_PD2YI | US000E | 2024-11-21T14:06:18.779Z | 2024-11-21T14:06:18.779Z |
5559413 | 5559413 | 20241120102016_eZ4KZ | US000E | 2024-11-21T14:06:16.427Z | 2024-11-21T14:06:16.427Z |
5559300 | 5559300 | 20241120095803_cZ4TX | US000E | 2024-11-21T14:05:53.589Z | 2024-11-21T14:05:53.589Z |
5559055 | 5559055 | 20241120090829_QMPUy | US000E | 2024-11-21T14:05:10.045Z | 2024-11-21T14:05:10.045Z |
5558818 | 5558818 | 20241120081304_HYsYB | US000E | 2024-11-21T14:04:28.744Z | 2024-11-21T14:04:28.744Z |
5558471 | 5558471 | 20241120061029_6ztFO | US000E | 2024-11-21T14:03:22.004Z | 2024-11-21T14:03:22.004Z |
5558360 | 5558360 | 20241120055851_NYn8u | US000E | 2024-11-21T14:03:07.046Z | 2024-11-21T14:03:07.046Z |
5558355 | 5558355 | 20241120055845_tGxYp | US000E | 2024-11-21T14:03:06.506Z | 2024-11-21T14:03:06.506Z |
5558203 | 5558203 | 20241120054507_2D26O | US000E | 2024-11-21T14:02:43.476Z | 2024-11-21T14:02:43.476Z |
5558019 | 5558019 | 20241120053205_RrKv6 | US000E | 2024-11-21T14:02:19.679Z | 2024-11-21T14:02:19.679Z |
5557208 | 5557208 | 20241119043209_ACKsP | US000E | 2024-11-20T14:12:27.907Z | 2024-11-21T14:20:49.713Z |
5557196 | 5557196 | 20241119042858_42hrz | US000E | 2024-11-20T14:12:26.904Z | 2024-11-21T14:20:49.379Z |
5556951 | 5556951 | 20241119030537_h43bo | US000E | 2024-11-20T14:11:45.850Z | 2024-11-21T14:20:41.797Z |
5556840 | 5556840 | 20241119021039_I3PaN | US000E | 2024-11-20T14:11:32.833Z | 2024-11-21T14:20:37.088Z |
5555252 | 5555252 | 20241119122452_i6lHd | US000E | 2024-11-20T14:05:01.172Z | 2024-11-21T14:18:53.236Z |
5555152 | 5555152 | 20241119115610_2hySj | US000E | 2024-11-20T14:04:34.137Z | 2024-11-21T14:18:53.212Z |
5555130 | 5555130 | 20241119115340_4hKH3 | US000E | 2024-11-20T14:04:31.465Z | 2024-11-21T14:18:53.208Z |
5555125 | 5555125 | 20241119115154_bH84g | US000E | 2024-11-20T14:04:31.159Z | 2024-11-21T14:18:53.207Z |
5555095 | 5555095 | 20241119114227_5KXIg | US000E | 2024-11-20T14:04:26.906Z | 2024-11-21T14:18:53.201Z |
5555083 | 5555083 | 20241119113617_h307W | US000E | 2024-11-20T14:04:25.788Z | 2024-11-21T14:18:53.199Z |
5555032 | 5555032 | 20241119112327_LMfHO | US000E | 2024-11-20T14:04:09.592Z | 2024-11-21T14:18:53.187Z |
5555028 | 5555028 | 20241119112312_DrkRp | US000E | 2024-11-20T14:04:08.961Z | 2024-11-21T14:18:53.186Z |
5555011 | 5555011 | 20241119111935_A52W4 | US000E | 2024-11-20T14:04:06.234Z | 2024-11-21T14:18:53.183Z |
5554950 | 5554950 | 20241119111001_AWS3B | US000E | 2024-11-20T14:03:52.977Z | 2024-11-21T14:18:53.171Z |
5554944 | 5554944 | 20241119110914_gvZ3V | US000E | 2024-11-20T14:03:52.136Z | 2024-11-21T14:18:53.169Z |
5554938 | 5554938 | 20241119110730_bMoKe | US000E | 2024-11-20T14:03:50.849Z | 2024-11-21T14:18:53.168Z |
5554908 | 5554908 | 20241119110033_KmDxW | US000E | 2024-11-20T14:03:47.456Z | 2024-11-21T14:18:53.161Z |
5554831 | 5554831 | 20241119104621_oOK3g | US000E | 2024-11-20T14:03:26.218Z | 2024-11-21T14:18:53.143Z |
5554818 | 5554818 | 20241119104410_EmUOd | US000E | 2024-11-20T14:03:23.009Z | 2024-11-21T14:18:53.140Z |
5554760 | 5554760 | 20241119102956_cr80e | US000E | 2024-11-20T14:03:12.615Z | 2024-11-21T14:18:53.127Z |
5554738 | 5554738 | 20241119102017_zFAJU | US000E | 2024-11-20T14:03:10.226Z | 2024-11-21T14:18:53.123Z |
5554716 | 5554716 | 20241119101619_RwwLS | US000E | 2024-11-20T14:03:06.716Z | 2024-11-21T14:18:53.118Z |
5554690 | 5554690 | 20241119100731_x2TrZ | US000E | 2024-11-20T14:03:01.224Z | 2024-11-21T14:18:53.110Z |
5554651 | 5554651 | 20241119095846_5GD4Q | US000E | 2024-11-20T14:02:56.489Z | 2024-11-21T14:18:53.103Z |
5554514 | 5554514 | 20241119092515_cNYRh | US000E | 2024-11-20T14:02:20.749Z | 2024-11-21T14:18:53.073Z |
5554510 | 5554510 | 20241119092406_FQ2Xk | US000E | 2024-11-20T14:02:20.193Z | 2024-11-21T14:18:53.071Z |
5554505 | 5554505 | 20241119092009_voEo2 | US000E | 2024-11-20T14:02:19.465Z | 2024-11-21T14:18:53.070Z |
5554469 | 5554469 | 20241119091131_2IwjK | US000E | 2024-11-20T14:02:14.811Z | 2024-11-21T14:18:53.063Z |
5554465 | 5554465 | 20241119090920_mWNQs | US000E | 2024-11-20T14:02:14.310Z | 2024-11-21T14:18:53.062Z |
5554022 | 5554022 | 20241119053010_tzVx8 | US000E | 2024-11-20T14:00:26.017Z | 2024-11-21T14:18:52.958Z |
5554015 | 5554015 | 20241119052646_LEzk9 | US000E | 2024-11-20T14:00:24.353Z | 2024-11-21T14:18:52.956Z |
5553994 | 5553994 | 20241119051218_m15Bd | US000E | 2024-11-20T14:00:20.067Z | 2024-11-21T14:18:52.951Z |
5544585 | 5544585 | 20241116124320_ZaZ0N | US000E | 2024-11-17T14:01:36.697Z | 2024-11-21T14:22:37.058Z |
5544581 | 5544581 | 20241116124256_3gN22 | US000E | 2024-11-17T14:01:36.357Z | 2024-11-21T14:22:37.037Z |
5544567 | 5544567 | 20241116124023_KEP0H | US000E | 2024-11-17T14:01:34.839Z | 2024-11-21T14:22:36.914Z |
5544551 | 5544551 | 20241116122027_GR5Ha | US000E | 2024-11-17T14:01:31.930Z | 2024-11-21T14:22:36.680Z |
5544525 | 5544525 | 20241116121443_35O9Q | US000E | 2024-11-17T14:01:27.159Z | 2024-11-21T14:22:35.855Z |
5544495 | 5544495 | 20241116114832_DiFOs | US000E | 2024-11-17T14:01:17.994Z | 2024-11-21T14:22:34.876Z |
5544477 | 5544477 | 20241116114334_mKq9N | US000E | 2024-11-17T14:01:16.133Z | 2024-11-21T14:22:34.524Z |
5544463 | 5544463 | 20241116112853_AunSc | US000E | 2024-11-17T14:01:14.073Z | 2024-11-21T14:22:34.285Z |
5544443 | 5544443 | 20241116110942_wtXkl | US000E | 2024-11-17T14:01:10.517Z | 2024-11-21T14:22:34.048Z |
5544431 | 5544431 | 20241116110013_J0P0e | US000E | 2024-11-17T14:01:07.963Z | 2024-11-21T14:22:33.570Z |
5544426 | 5544426 | 20241116105730_qvIwd | US000E | 2024-11-17T14:01:06.965Z | 2024-11-21T14:22:33.507Z |
5544415 | 5544415 | 20241116105456_uDJNN | US000E | 2024-11-17T14:01:04.383Z | 2024-11-21T14:22:33.319Z |
5544403 | 5544403 | 20241116104949_8CZEL | US000E | 2024-11-17T14:01:02.097Z | 2024-11-21T14:22:33.147Z |
5544388 | 5544388 | 20241116104225_b3Md3 | US000E | 2024-11-17T14:01:00.047Z | 2024-11-21T14:22:32.688Z |
5544365 | 5544365 | 20241116102241_s9pe2 | US000E | 2024-11-17T14:00:57.039Z | 2024-11-21T14:22:32.279Z |
5544357 | 5544357 | 20241116101825_j6eQO | US000E | 2024-11-17T14:00:56.013Z | 2024-11-21T14:22:32.098Z |
5544328 | 5544328 | 20241116100318_6NbsT | US000E | 2024-11-17T14:00:52.582Z | 2024-11-21T14:22:31.213Z |
5544325 | 5544325 | 20241116100237_I67KH | US000E | 2024-11-17T14:00:52.201Z | 2024-11-21T14:22:31.158Z |
5544320 | 5544320 | 20241116095942_IxbJN | US000E | 2024-11-17T14:00:51.477Z | 2024-11-21T14:22:31.120Z |
5544309 | 5544309 | 20241116095006_j8obR | US000E | 2024-11-17T14:00:49.716Z | 2024-11-21T14:22:30.864Z |
5544293 | 5544293 | 20241116094321_4KV15 | US000E | 2024-11-17T14:00:46.963Z | 2024-11-21T14:22:30.486Z |
5544209 | 5544209 | 20241116082911_kzOHj | US000E | 2024-11-17T14:00:28.463Z | 2024-11-21T14:22:28.643Z |
5544197 | 5544197 | 20241116080610_ijcqr | US000E | 2024-11-17T14:00:26.532Z | 2024-11-21T14:22:28.470Z |
5544165 | 5544165 | 20241116071355_40Aar | US000E | 2024-11-17T14:00:21.634Z | 2024-11-21T14:22:28.163Z |
5544158 | 5544158 | 20241116070556_32vN9 | US000E | 2024-11-17T14:00:20.875Z | 2024-11-21T14:22:28.140Z |
5544136 | 5544136 | 20241116064621_xlj6J | US000E | 2024-11-17T14:00:17.783Z | 2024-11-21T14:22:27.916Z |
5544129 | 5544129 | 20241116064137_NbRam | US000E | 2024-11-17T14:00:17.030Z | 2024-11-21T14:22:27.886Z |
5544119 | 5544119 | 20241116062813_jjvt5 | US000E | 2024-11-17T14:00:15.410Z | 2024-11-21T14:22:27.776Z |
5544110 | 5544110 | 20241116061138_WeuB4 | US000E | 2024-11-17T14:00:14.065Z | 2024-11-21T14:22:27.677Z |
5542800 | 5542800 | 20241115124102_texZl | US000E | 2024-11-16T14:02:36.651Z | 2024-11-21T14:23:35.063Z |
5542798 | 5542798 | 20241115123852_UFSFT | US000E | 2024-11-16T14:02:35.970Z | 2024-11-21T14:23:35.035Z |
5542756 | 5542756 | 20241115122025_lkjCs | US000E | 2024-11-16T14:02:26.727Z | 2024-11-21T14:23:34.589Z |
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);