participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,045 rows where station_code = "AU0047" 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 |
---|---|---|---|---|---|
5315422 | 5315422 | 20241015130502_xZDL8 | AU0047 | 2024-10-17T12:04:40.574Z | 2024-10-18T12:06:26.992Z |
5314698 | 5314698 | 20241016151124_2rlic | AU0047 | 2024-10-17T12:02:41.211Z | 2024-10-18T12:04:36.345Z |
5309221 | 5309221 | 20241014114346_BbvuV | AU0047 | 2024-10-16T12:05:00.317Z | 2024-10-18T12:08:50.998Z |
5305794 | 5305794 | 20241013174618_ZQ4Y7 | AU0047 | 2024-10-15T12:05:24.963Z | 2024-10-18T12:12:40.149Z |
5305367 | 5305367 | 20241013145121_O3vV0 | AU0047 | 2024-10-15T12:04:21.975Z | 2024-10-18T12:12:18.593Z |
5298774 | 5298774 | 20241012171019_j6TEt | AU0047 | 2024-10-14T12:11:07.906Z | 2024-10-18T12:15:22.746Z |
5298744 | 5298744 | 20241012170605_tyyKD | AU0047 | 2024-10-14T12:11:06.146Z | 2024-10-18T12:15:22.499Z |
5298719 | 5298719 | 20241012170400_CwvjK | AU0047 | 2024-10-14T12:11:04.383Z | 2024-10-18T12:15:22.124Z |
5298664 | 5298664 | 20241012165206_NjqEB | AU0047 | 2024-10-14T12:10:59.555Z | 2024-10-18T12:15:21.262Z |
5298624 | 5298624 | 20241012164821_CKuw6 | AU0047 | 2024-10-14T12:10:56.414Z | 2024-10-18T12:15:20.812Z |
5298571 | 5298571 | 20241012163717_tPaD5 | AU0047 | 2024-10-14T12:10:44.752Z | 2024-10-18T12:15:19.997Z |
5298359 | 5298359 | 20241012161208_Cx0ft | AU0047 | 2024-10-14T12:10:14.987Z | 2024-10-18T12:15:13.219Z |
5297813 | 5297813 | 20241012143946_Oaiha | AU0047 | 2024-10-14T12:09:12.855Z | 2024-10-18T12:15:04.393Z |
5290632 | 5290632 | 20241011183356_rCDKf | AU0047 | 2024-10-13T12:12:59.272Z | 2024-10-18T12:19:12.469Z |
5290606 | 5290606 | 20241011183118_3oDsb | AU0047 | 2024-10-13T12:12:55.706Z | 2024-10-18T12:19:12.286Z |
5290482 | 5290482 | 20241011180001_Exk6H | AU0047 | 2024-10-13T12:12:35.314Z | 2024-10-18T12:19:11.478Z |
5290338 | 5290338 | 20241011171856_37AQ3 | AU0047 | 2024-10-13T12:12:11.654Z | 2024-10-18T12:19:10.098Z |
5290316 | 5290316 | 20241011171437_2kIh9 | AU0047 | 2024-10-13T12:12:10.256Z | 2024-10-18T12:19:09.955Z |
5290222 | 5290222 | 20241011164727_0S3Tz | AU0047 | 2024-10-13T12:12:03.263Z | 2024-10-18T12:19:09.299Z |
5289770 | 5289770 | 20241011160237_F34Ku | AU0047 | 2024-10-13T12:11:23.738Z | 2024-10-18T12:19:07.272Z |
5289133 | 5289133 | 20241011150118_IVL6o | AU0047 | 2024-10-13T12:10:25.925Z | 2024-10-18T12:19:02.529Z |
5288809 | 5288809 | 20241011143037_ZIXRx | AU0047 | 2024-10-13T12:09:56.649Z | 2024-10-18T12:18:59.304Z |
5288788 | 5288788 | 20241011142830_mhXl1 | AU0047 | 2024-10-13T12:09:55.165Z | 2024-10-18T12:18:59.161Z |
5288293 | 5288293 | 20241011133830_51wNE | AU0047 | 2024-10-13T12:09:09.081Z | 2024-10-18T12:18:52.610Z |
5288105 | 5288105 | 20241011130214_XVugl | AU0047 | 2024-10-13T12:08:45.679Z | 2024-10-18T12:18:50.044Z |
5281299 | 5281299 | 20241010180944_kuBqv | AU0047 | 2024-10-12T12:13:55.134Z | 2024-10-18T12:20:58.971Z |
5281284 | 5281284 | 20241010180637_zxtbH | AU0047 | 2024-10-12T12:13:51.935Z | 2024-10-18T12:20:58.840Z |
5280982 | 5280982 | 20241010171233_eHgCM | AU0047 | 2024-10-12T12:13:13.912Z | 2024-10-18T12:20:55.925Z |
5280973 | 5280973 | 20241010171058_uPz3F | AU0047 | 2024-10-12T12:13:12.863Z | 2024-10-18T12:20:55.828Z |
5280663 | 5280663 | 20241010162816_gceAs | AU0047 | 2024-10-12T12:12:41.350Z | 2024-10-18T12:20:52.369Z |
5280553 | 5280553 | 20241010162043_WtCUe | AU0047 | 2024-10-12T12:12:34.897Z | 2024-10-18T12:20:51.596Z |
5280395 | 5280395 | 20241010160515_CHTdt | AU0047 | 2024-10-12T12:12:26.567Z | 2024-10-18T12:20:50.800Z |
5280370 | 5280370 | 20241010160325_zqM6X | AU0047 | 2024-10-12T12:12:25.247Z | 2024-10-18T12:20:50.643Z |
5280173 | 5280173 | 20241010154741_A9W45 | AU0047 | 2024-10-12T12:11:59.031Z | 2024-10-18T12:20:49.585Z |
5280172 | 5280172 | 20241010154717_o6GmS | AU0047 | 2024-10-12T12:11:58.786Z | 2024-10-18T12:20:49.577Z |
5279964 | 5279964 | 20241010153342_Of36W | AU0047 | 2024-10-12T12:11:38.594Z | 2024-10-18T12:20:48.289Z |
5279909 | 5279909 | 20241010152904_Qrv8T | AU0047 | 2024-10-12T12:11:33.115Z | 2024-10-18T12:20:48.095Z |
5278899 | 5278899 | 20241010133931_BL3M6 | AU0047 | 2024-10-12T12:09:55.657Z | 2024-10-18T12:20:37.237Z |
5278898 | 5278898 | 20241010133901_JoEz5 | AU0047 | 2024-10-12T12:09:55.469Z | 2024-10-18T12:20:36.937Z |
5278451 | 5278451 | 20241011102657_2OQwK | AU0047 | 2024-10-12T12:06:11.116Z | 2024-10-18T12:18:27.466Z |
5273816 | 5273816 | 20241009184107_6UsMq | AU0047 | 2024-10-11T12:13:18.399Z | 2024-10-18T12:22:04.631Z |
5273797 | 5273797 | 20241009183542_tKmkb | AU0047 | 2024-10-11T12:13:14.800Z | 2024-10-18T12:22:04.451Z |
5273756 | 5273756 | 20241009182355_b2Ui3 | AU0047 | 2024-10-11T12:13:10.476Z | 2024-10-18T12:22:04.284Z |
5273674 | 5273674 | 20241009181056_xh69y | AU0047 | 2024-10-11T12:12:57.818Z | 2024-10-18T12:22:03.713Z |
5273554 | 5273554 | 20241009175335_VeRlF | AU0047 | 2024-10-11T12:12:41.575Z | 2024-10-18T12:22:02.596Z |
5273510 | 5273510 | 20241009174409_QolGg | AU0047 | 2024-10-11T12:12:36.810Z | 2024-10-18T12:22:02.346Z |
5273475 | 5273475 | 20241009173535_x6GhC | AU0047 | 2024-10-11T12:12:31.002Z | 2024-10-18T12:22:02.017Z |
5273419 | 5273419 | 20241009172349_d4a0o | AU0047 | 2024-10-11T12:12:24.686Z | 2024-10-18T12:22:01.595Z |
5273376 | 5273376 | 20241009171624_2ANuq | AU0047 | 2024-10-11T12:12:20.788Z | 2024-10-18T12:22:01.408Z |
5273374 | 5273374 | 20241009171601_G2JMz | AU0047 | 2024-10-11T12:12:20.632Z | 2024-10-18T12:22:01.407Z |
5273366 | 5273366 | 20241009171419_9Aj3u | AU0047 | 2024-10-11T12:12:19.587Z | 2024-10-18T12:22:01.400Z |
5273356 | 5273356 | 20241009171314_sKznp | AU0047 | 2024-10-11T12:12:18.810Z | 2024-10-18T12:22:01.387Z |
5273350 | 5273350 | 20241009171021_m2NIT | AU0047 | 2024-10-11T12:12:18.076Z | 2024-10-18T12:22:01.375Z |
5273217 | 5273217 | 20241009164045_xmogM | AU0047 | 2024-10-11T12:12:08.306Z | 2024-10-18T12:22:00.432Z |
5273085 | 5273085 | 20241009161859_YhUsE | AU0047 | 2024-10-11T12:11:59.186Z | 2024-10-18T12:21:59.675Z |
5273016 | 5273016 | 20241009160956_IdIvl | AU0047 | 2024-10-11T12:11:54.231Z | 2024-10-18T12:21:59.416Z |
5272994 | 5272994 | 20241009160455_Ryfyr | AU0047 | 2024-10-11T12:11:50.860Z | 2024-10-18T12:21:59.310Z |
5272817 | 5272817 | 20241009152841_Gwo11 | AU0047 | 2024-10-11T12:11:25.948Z | 2024-10-18T12:21:58.424Z |
5272410 | 5272410 | 20241009141518_mQIPG | AU0047 | 2024-10-11T12:10:38.519Z | 2024-10-18T12:21:55.984Z |
5272336 | 5272336 | 20241009135613_65sJQ | AU0047 | 2024-10-11T12:10:33.158Z | 2024-10-18T12:21:55.568Z |
5272322 | 5272322 | 20241009135350_Injcb | AU0047 | 2024-10-11T12:10:31.500Z | 2024-10-18T12:21:55.510Z |
5272319 | 5272319 | 20241009135310_7s0gY | AU0047 | 2024-10-11T12:10:31.276Z | 2024-10-18T12:21:55.499Z |
5272134 | 5272134 | 20241009131405_QHcHx | AU0047 | 2024-10-11T12:10:11.089Z | 2024-10-18T12:21:54.801Z |
5272068 | 5272068 | 20241009125731_QgWWH | AU0047 | 2024-10-11T12:09:55.587Z | 2024-10-18T12:21:54.439Z |
5272066 | 5272066 | 20241009125718_l1zQ0 | AU0047 | 2024-10-11T12:09:55.259Z | 2024-10-18T12:21:54.433Z |
5272063 | 5272063 | 20241009125520_pmGCP | AU0047 | 2024-10-11T12:09:53.777Z | 2024-10-18T12:21:54.416Z |
5271788 | 5271788 | 20241009114940_tR8wv | AU0047 | 2024-10-11T12:09:25.749Z | 2024-10-18T12:21:51.334Z |
5271325 | 5271325 | 20241010114248_3xHki | AU0047 | 2024-10-11T12:06:33.353Z | 2024-10-18T12:20:27.309Z |
5270700 | 5270700 | 20241010102122_iK4qH | AU0047 | 2024-10-11T12:05:08.816Z | 2024-10-18T12:20:18.229Z |
5267027 | 5267027 | 20241008182911_fxvfd | AU0047 | 2024-10-10T12:13:16.091Z | 2024-10-17T12:20:07.965Z |
5267013 | 5267013 | 20241008182429_i1d86 | AU0047 | 2024-10-10T12:13:13.843Z | 2024-10-17T12:20:07.853Z |
5266986 | 5266986 | 20241008181413_BB3c9 | AU0047 | 2024-10-10T12:13:10.786Z | 2024-10-17T12:20:07.816Z |
5266957 | 5266957 | 20241008180458_apyHk | AU0047 | 2024-10-10T12:13:06.305Z | 2024-10-17T12:20:07.642Z |
5266914 | 5266914 | 20241008174313_l1fIZ | AU0047 | 2024-10-10T12:13:01.246Z | 2024-10-17T12:20:07.570Z |
5266888 | 5266888 | 20241008173945_XNTuP | AU0047 | 2024-10-10T12:12:58.039Z | 2024-10-17T12:20:07.439Z |
5266875 | 5266875 | 20241008173135_T1VTP | AU0047 | 2024-10-10T12:12:55.497Z | 2024-10-17T12:20:07.361Z |
5266869 | 5266869 | 20241008172958_IcDlB | AU0047 | 2024-10-10T12:12:54.942Z | 2024-10-17T12:20:07.310Z |
5266865 | 5266865 | 20241008172933_jTSYe | AU0047 | 2024-10-10T12:12:54.221Z | 2024-10-17T12:20:07.307Z |
5266834 | 5266834 | 20241008171412_2qoZ8 | AU0047 | 2024-10-10T12:12:50.635Z | 2024-10-17T12:20:07.158Z |
5266830 | 5266830 | 20241008170818_EYMsc | AU0047 | 2024-10-10T12:12:49.886Z | 2024-10-17T12:20:07.122Z |
5266810 | 5266810 | 20241008165450_i1Ayy | AU0047 | 2024-10-10T12:12:45.659Z | 2024-10-17T12:20:06.620Z |
5266788 | 5266788 | 20241008164804_JDuWA | AU0047 | 2024-10-10T12:12:42.810Z | 2024-10-17T12:20:06.355Z |
5266730 | 5266730 | 20241008163631_WFiVk | AU0047 | 2024-10-10T12:12:34.684Z | 2024-10-17T12:20:05.984Z |
5266662 | 5266662 | 20241008161459_3QIIM | AU0047 | 2024-10-10T12:12:21.554Z | 2024-10-17T12:20:05.663Z |
5266515 | 5266515 | 20241008153100_tFvRK | AU0047 | 2024-10-10T12:12:00.187Z | 2024-10-17T12:20:04.968Z |
5266478 | 5266478 | 20241008152010_Xwgqy | AU0047 | 2024-10-10T12:11:52.102Z | 2024-10-17T12:20:04.665Z |
5266461 | 5266461 | 20241008151512_Q6FFx | AU0047 | 2024-10-10T12:11:50.791Z | 2024-10-17T12:20:04.652Z |
5266445 | 5266445 | 20241008151412_RUoel | AU0047 | 2024-10-10T12:11:49.649Z | 2024-10-17T12:20:04.631Z |
5266430 | 5266430 | 20241008150957_bltGY | AU0047 | 2024-10-10T12:11:47.860Z | 2024-10-17T12:20:04.436Z |
5266382 | 5266382 | 20241008145450_vwTzA | AU0047 | 2024-10-10T12:11:42.653Z | 2024-10-17T12:20:04.325Z |
5266376 | 5266376 | 20241008145314_BFICQ | AU0047 | 2024-10-10T12:11:42.429Z | 2024-10-17T12:20:04.314Z |
5266362 | 5266362 | 20241008144529_vcvjv | AU0047 | 2024-10-10T12:11:41.365Z | 2024-10-17T12:20:03.722Z |
5266335 | 5266335 | 20241008143901_Mh8bV | AU0047 | 2024-10-10T12:11:39.513Z | 2024-10-17T12:20:03.585Z |
5266274 | 5266274 | 20241008140836_3MsNa | AU0047 | 2024-10-10T12:11:34.428Z | 2024-10-17T12:20:03.279Z |
5266214 | 5266214 | 20241008134223_Amuu3 | AU0047 | 2024-10-10T12:11:30.391Z | 2024-10-17T12:20:03.024Z |
5266203 | 5266203 | 20241008134047_AT2Yj | AU0047 | 2024-10-10T12:11:29.513Z | 2024-10-17T12:20:03.016Z |
5266200 | 5266200 | 20241008134016_a7jtr | AU0047 | 2024-10-10T12:11:29.368Z | 2024-10-17T12:20:03.013Z |
5266155 | 5266155 | 20241008131712_36rTE | AU0047 | 2024-10-10T12:11:25.302Z | 2024-10-17T12:20:02.940Z |
5266150 | 5266150 | 20241008131655_N2TaC | AU0047 | 2024-10-10T12:11:24.262Z | 2024-10-17T12:20:02.913Z |
5266129 | 5266129 | 20241008131146_I9Ysr | AU0047 | 2024-10-10T12:11:17.862Z | 2024-10-17T12:20:02.892Z |
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);