participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,329 rows where station_code = "AU001K" 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 |
---|---|---|---|---|---|
5561026 | 5561026 | 20241120170829_fEGd6 | AU001K | 2024-11-21T14:10:21.146Z | 2024-11-21T14:10:21.146Z |
5559688 | 5559688 | 20241120105935_EX2kr | AU001K | 2024-11-21T14:06:58.487Z | 2024-11-21T14:06:58.487Z |
5559686 | 5559686 | 20241120105929_zjDp4 | AU001K | 2024-11-21T14:06:58.019Z | 2024-11-21T14:06:58.019Z |
5559444 | 5559444 | 20241120102401_gXXJS | AU001K | 2024-11-21T14:06:21.230Z | 2024-11-21T14:06:21.230Z |
5555928 | 5555928 | 20241119174803_4lE0Z | AU001K | 2024-11-20T14:07:05.344Z | 2024-11-21T14:18:53.390Z |
5555872 | 5555872 | 20241119171745_WaKPd | AU001K | 2024-11-20T14:06:59.620Z | 2024-11-21T14:18:53.371Z |
5555860 | 5555860 | 20241119171345_vBk50 | AU001K | 2024-11-20T14:06:58.475Z | 2024-11-21T14:18:53.368Z |
5555837 | 5555837 | 20241119165954_xveUm | AU001K | 2024-11-20T14:06:54.390Z | 2024-11-21T14:18:53.363Z |
5555828 | 5555828 | 20241119165645_xofnD | AU001K | 2024-11-20T14:06:49.461Z | 2024-11-21T14:18:53.362Z |
5555790 | 5555790 | 20241119163036_MK2J8 | AU001K | 2024-11-20T14:06:41.270Z | 2024-11-21T14:18:53.351Z |
5555786 | 5555786 | 20241119162927_30P8v | AU001K | 2024-11-20T14:06:39.678Z | 2024-11-21T14:18:53.350Z |
5555782 | 5555782 | 20241119162005_pX85h | AU001K | 2024-11-20T14:06:38.493Z | 2024-11-21T14:18:53.349Z |
5555758 | 5555758 | 20241119154222_77wQJ | AU001K | 2024-11-20T14:06:32.848Z | 2024-11-21T14:18:53.343Z |
5555689 | 5555689 | 20241119144935_tG20e | AU001K | 2024-11-20T14:06:25.342Z | 2024-11-21T14:18:53.328Z |
5555618 | 5555618 | 20241119140828_X7eT7 | AU001K | 2024-11-20T14:06:08.416Z | 2024-11-21T14:18:53.312Z |
5551721 | 5551721 | 20241118145638_Rli3h | AU001K | 2024-11-19T14:05:21.143Z | 2024-11-21T14:20:02.047Z |
5551690 | 5551690 | 20241118144439_vGhxi | AU001K | 2024-11-19T14:05:13.606Z | 2024-11-21T14:19:59.837Z |
5551499 | 5551499 | 20241118135858_vqh1a | AU001K | 2024-11-19T14:04:54.116Z | 2024-11-21T14:19:54.435Z |
5551203 | 5551203 | 20241118124505_lg7iH | AU001K | 2024-11-19T14:04:06.742Z | 2024-11-21T14:19:45.785Z |
5551128 | 5551128 | 20241118123001_f2DRy | AU001K | 2024-11-19T14:03:57.074Z | 2024-11-21T14:19:44.100Z |
5551100 | 5551100 | 20241118122543_CFW03 | AU001K | 2024-11-19T14:03:54.915Z | 2024-11-21T14:19:43.147Z |
5545512 | 5545512 | 20241111174041_vR7eg | AU001K | 2024-11-17T14:15:38.951Z | 2024-11-20T14:25:14.178Z |
5545510 | 5545510 | 20241111171109_ZuXrD | AU001K | 2024-11-17T14:15:35.784Z | 2024-11-20T14:25:12.709Z |
5545499 | 5545499 | 20241112170900_qvb4i | AU001K | 2024-11-17T14:11:43.651Z | 2024-11-21T14:25:59.685Z |
5545497 | 5545497 | 20241112164106_2JrsZ | AU001K | 2024-11-17T14:11:39.480Z | 2024-11-21T14:25:58.759Z |
5545495 | 5545495 | 20241112163900_kMIJ4 | AU001K | 2024-11-17T14:11:38.966Z | 2024-11-21T14:25:58.504Z |
5545493 | 5545493 | 20241112163649_KSHKd | AU001K | 2024-11-17T14:11:38.298Z | 2024-11-21T14:25:58.347Z |
5545491 | 5545491 | 20241112163247_DiPdP | AU001K | 2024-11-17T14:11:37.651Z | 2024-11-21T14:25:58.115Z |
5545484 | 5545484 | 20241112161607_kBvsZ | AU001K | 2024-11-17T14:11:34.506Z | 2024-11-21T14:25:57.474Z |
5545482 | 5545482 | 20241112160951_1GXvD | AU001K | 2024-11-17T14:11:33.291Z | 2024-11-21T14:25:57.322Z |
5545465 | 5545465 | 20241112144745_YDWWp | AU001K | 2024-11-17T14:11:21.120Z | 2024-11-21T14:25:54.513Z |
5545456 | 5545456 | 20241112135633_425kG | AU001K | 2024-11-17T14:11:16.689Z | 2024-11-21T14:25:52.051Z |
5545454 | 5545454 | 20241112132720_NZoHd | AU001K | 2024-11-17T14:11:14.742Z | 2024-11-21T14:25:50.815Z |
5545452 | 5545452 | 20241112131941_2ds98 | AU001K | 2024-11-17T14:11:14.310Z | 2024-11-21T14:25:50.763Z |
5545450 | 5545450 | 20241112122112_hVy96 | AU001K | 2024-11-17T14:11:08.678Z | 2024-11-21T14:25:46.850Z |
5545448 | 5545448 | 20241112115029_xcB7a | AU001K | 2024-11-17T14:11:03.518Z | 2024-11-21T14:25:44.408Z |
5545432 | 5545432 | 20241113180142_AAuh9 | AU001K | 2024-11-17T14:08:41.150Z | 2024-11-21T14:25:07.928Z |
5545430 | 5545430 | 20241113175240_G4R7C | AU001K | 2024-11-17T14:08:40.569Z | 2024-11-21T14:25:07.814Z |
5545421 | 5545421 | 20241113164318_f6FFy | AU001K | 2024-11-17T14:08:38.424Z | 2024-11-21T14:25:06.882Z |
5545419 | 5545419 | 20241113162535_OxFPT | AU001K | 2024-11-17T14:08:37.831Z | 2024-11-21T14:25:06.622Z |
5545415 | 5545415 | 20241113151814_Ahben | AU001K | 2024-11-17T14:08:35.585Z | 2024-11-21T14:25:05.677Z |
5545395 | 5545395 | 20241114175527_mQGUv | AU001K | 2024-11-17T14:06:26.688Z | 2024-11-21T14:24:21.178Z |
5545384 | 5545384 | 20241114160326_d8e34 | AU001K | 2024-11-17T14:06:21.489Z | 2024-11-21T14:24:19.862Z |
5545382 | 5545382 | 20241114154235_uBxWn | AU001K | 2024-11-17T14:06:20.183Z | 2024-11-21T14:24:19.623Z |
5545376 | 5545376 | 20241114135722_bllgu | AU001K | 2024-11-17T14:06:17.663Z | 2024-11-21T14:24:18.891Z |
5545372 | 5545372 | 20241114132554_gaq0L | AU001K | 2024-11-17T14:06:17.041Z | 2024-11-21T14:24:18.762Z |
5544926 | 5544926 | 20241115150313_PQRbq | AU001K | 2024-11-17T14:03:14.809Z | 2024-11-21T14:23:35.823Z |
5544923 | 5544923 | 20241115143219_10ad3 | AU001K | 2024-11-17T14:03:13.951Z | 2024-11-21T14:23:35.664Z |
5544919 | 5544919 | 20241115135233_UYHJ1 | AU001K | 2024-11-17T14:03:12.742Z | 2024-11-21T14:23:35.592Z |
5544913 | 5544913 | 20241115113626_422cR | AU001K | 2024-11-17T14:03:04.578Z | 2024-11-21T14:23:32.764Z |
5544911 | 5544911 | 20241115113517_3mLQY | AU001K | 2024-11-17T14:03:04.075Z | 2024-11-21T14:23:32.585Z |
5536329 | 5536329 | 20241112172847_6Uc3z | AU001K | 2024-11-14T14:09:38.187Z | 2024-11-21T14:26:00.117Z |
5536246 | 5536246 | 20241112164902_UfM3v | AU001K | 2024-11-14T14:09:26.313Z | 2024-11-21T14:25:59.035Z |
5536135 | 5536135 | 20241112154828_wyX3X | AU001K | 2024-11-14T14:09:13.551Z | 2024-11-21T14:25:56.946Z |
5534738 | 5534738 | 20241113173632_kFBoY | AU001K | 2024-11-14T14:05:13.448Z | 2024-11-21T14:25:07.557Z |
5534714 | 5534714 | 20241113164540_v3MMt | AU001K | 2024-11-14T14:05:05.812Z | 2024-11-21T14:25:06.948Z |
5534701 | 5534701 | 20241113161412_529Jr | AU001K | 2024-11-14T14:05:00.553Z | 2024-11-21T14:25:06.598Z |
5534686 | 5534686 | 20241113153742_PsiJv | AU001K | 2024-11-14T14:04:56.824Z | 2024-11-21T14:25:06.025Z |
5520453 | 5520453 | 20241111160829_Nhmjs | AU001K | 2024-11-12T14:06:22.550Z | 2024-11-20T14:25:10.322Z |
5514146 | 5514146 | 20241110145041_F3jnR | AU001K | 2024-11-11T14:06:16.161Z | 2024-11-19T14:21:44.291Z |
5513336 | 5513336 | 20241110111736_940SS | AU001K | 2024-11-11T14:04:29.640Z | 2024-11-19T14:21:33.299Z |
5513191 | 5513191 | 20241110105438_nC48R | AU001K | 2024-11-11T14:04:06.738Z | 2024-11-19T14:21:31.865Z |
5512742 | 5512742 | 20241110094225_yHMQh | AU001K | 2024-11-11T14:03:03.830Z | 2024-11-19T14:21:27.768Z |
5512725 | 5512725 | 20241110093945_pPd8c | AU001K | 2024-11-11T14:03:02.181Z | 2024-11-19T14:21:27.681Z |
5500864 | 5500864 | 20241108180239_gIyKu | AU001K | 2024-11-09T14:07:21.521Z | 2024-11-17T14:23:30.402Z |
5500764 | 5500764 | 20241108172629_Zuaxs | AU001K | 2024-11-09T14:07:03.982Z | 2024-11-17T14:23:28.063Z |
5500724 | 5500724 | 20241108170924_bydkI | AU001K | 2024-11-09T14:06:59.573Z | 2024-11-17T14:23:27.030Z |
5500722 | 5500722 | 20241108170920_FrELj | AU001K | 2024-11-09T14:06:58.869Z | 2024-11-17T14:23:27.011Z |
5500702 | 5500702 | 20241108170440_2pdH3 | AU001K | 2024-11-09T14:06:56.628Z | 2024-11-17T14:23:26.718Z |
5500700 | 5500700 | 20241108170359_lW3OO | AU001K | 2024-11-09T14:06:56.297Z | 2024-11-17T14:23:26.703Z |
5500652 | 5500652 | 20241108164543_Soab3 | AU001K | 2024-11-09T14:06:51.678Z | 2024-11-17T14:23:25.978Z |
5500622 | 5500622 | 20241108162736_kpJL1 | AU001K | 2024-11-09T14:06:48.165Z | 2024-11-17T14:23:24.619Z |
5500553 | 5500553 | 20241108160535_89Jpg | AU001K | 2024-11-09T14:06:33.150Z | 2024-11-17T14:23:23.599Z |
5500433 | 5500433 | 20241108154226_FMzAU | AU001K | 2024-11-09T14:06:16.675Z | 2024-11-17T14:23:22.628Z |
5500141 | 5500141 | 20241108145431_P2CA7 | AU001K | 2024-11-09T14:05:51.292Z | 2024-11-17T14:23:19.739Z |
5500084 | 5500084 | 20241108144015_09L28 | AU001K | 2024-11-09T14:05:40.029Z | 2024-11-17T14:23:18.584Z |
5500045 | 5500045 | 20241108143309_RpWG1 | AU001K | 2024-11-09T14:05:35.185Z | 2024-11-17T14:23:18.352Z |
5500035 | 5500035 | 20241108143109_ca2B5 | AU001K | 2024-11-09T14:05:33.382Z | 2024-11-17T14:23:18.189Z |
5500016 | 5500016 | 20241108142347_xkOoN | AU001K | 2024-11-09T14:05:30.444Z | 2024-11-17T14:23:17.974Z |
5500009 | 5500009 | 20241108142201_I2h4f | AU001K | 2024-11-09T14:05:29.172Z | 2024-11-17T14:23:17.947Z |
5499979 | 5499979 | 20241108141905_9fz3a | AU001K | 2024-11-09T14:05:26.703Z | 2024-11-17T14:23:17.841Z |
5499883 | 5499883 | 20241108135320_SGdqz | AU001K | 2024-11-09T14:05:07.563Z | 2024-11-17T14:23:16.660Z |
5499881 | 5499881 | 20241108135306_h4L8j | AU001K | 2024-11-09T14:05:07.027Z | 2024-11-17T14:23:16.650Z |
5499807 | 5499807 | 20241108133416_vhpXE | AU001K | 2024-11-09T14:04:59.560Z | 2024-11-17T14:23:16.212Z |
5499756 | 5499756 | 20241108131712_4MSLq | AU001K | 2024-11-09T14:04:54.506Z | 2024-11-17T14:23:15.835Z |
5499693 | 5499693 | 20241108130057_uKT76 | AU001K | 2024-11-09T14:04:45.321Z | 2024-11-17T14:23:14.534Z |
5499660 | 5499660 | 20241108125311_aGgFG | AU001K | 2024-11-09T14:04:39.488Z | 2024-11-17T14:23:14.252Z |
5499642 | 5499642 | 20241108124829_1W3mN | AU001K | 2024-11-09T14:04:31.658Z | 2024-11-17T14:23:14.031Z |
5499598 | 5499598 | 20241108124202_BYHix | AU001K | 2024-11-09T14:04:25.137Z | 2024-11-17T14:23:13.532Z |
5499307 | 5499307 | 20241108115409_h5MFs | AU001K | 2024-11-09T14:03:43.585Z | 2024-11-17T14:23:09.086Z |
5499132 | 5499132 | 20241108111417_acpNH | AU001K | 2024-11-09T14:03:21.227Z | 2024-11-17T14:23:06.474Z |
5498779 | 5498779 | 20241108095850_D15Ga | AU001K | 2024-11-09T14:02:23.564Z | 2024-11-17T14:22:59.818Z |
5494109 | 5494109 | 20241107153836_blHFf | AU001K | 2024-11-08T14:05:23.496Z | 2024-11-16T14:27:47.859Z |
5493777 | 5493777 | 20241107133734_eEdYP | AU001K | 2024-11-08T14:04:37.942Z | 2024-11-16T14:27:40.934Z |
5493755 | 5493755 | 20241107131851_Jnd6k | AU001K | 2024-11-08T14:04:35.292Z | 2024-11-16T14:27:40.321Z |
5493751 | 5493751 | 20241107131827_YQOOX | AU001K | 2024-11-08T14:04:34.643Z | 2024-11-16T14:27:40.273Z |
5493491 | 5493491 | 20241107122156_OZLm3 | AU001K | 2024-11-08T14:03:52.731Z | 2024-11-16T14:27:34.907Z |
5487471 | 5487471 | 20241106163110_ReQiA | AU001K | 2024-11-07T14:05:56.143Z | 2024-11-15T14:24:40.839Z |
5481204 | 5481204 | 20241104153430_ucDnE | AU001K | 2024-11-06T14:09:41.830Z | 2024-11-13T14:27:26.420Z |
5481116 | 5481116 | 20241104142420_61f40 | AU001K | 2024-11-06T14:09:09.076Z | 2024-11-13T14:27:26.057Z |
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);