participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
13,416 rows where station_code = "AU001A" 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 |
---|---|---|---|---|---|
5097125 | 5097125 | 20240912145303_XYKNk | AU001A | 2024-09-16T12:16:45.659Z | 2024-09-16T12:17:32.040Z |
5097122 | 5097122 | 20240912144441_yCVmT | AU001A | 2024-09-16T12:16:45.641Z | 2024-09-16T12:17:32.039Z |
5097115 | 5097115 | 20240912144340_EfPyx | AU001A | 2024-09-16T12:16:45.516Z | 2024-09-16T12:17:32.037Z |
5097107 | 5097107 | 20240912143913_Y1pwf | AU001A | 2024-09-16T12:16:45.187Z | 2024-09-16T12:17:32.034Z |
5097078 | 5097078 | 20240912142100_Z1eBb | AU001A | 2024-09-16T12:16:44.347Z | 2024-09-16T12:17:32.023Z |
5097074 | 5097074 | 20240912142008_pGvBj | AU001A | 2024-09-16T12:16:44.305Z | 2024-09-16T12:17:32.022Z |
5097063 | 5097063 | 20240912141023_h33zs | AU001A | 2024-09-16T12:16:43.882Z | 2024-09-16T12:17:32.017Z |
5097054 | 5097054 | 20240912140718_lamCW | AU001A | 2024-09-16T12:16:43.663Z | 2024-09-16T12:17:32.014Z |
5097040 | 5097040 | 20240912140100_H6192 | AU001A | 2024-09-16T12:16:43.194Z | 2024-09-16T12:17:32.009Z |
5097037 | 5097037 | 20240912135933_aSbzR | AU001A | 2024-09-16T12:16:43.017Z | 2024-09-16T12:17:32.008Z |
5097014 | 5097014 | 20240912133850_Xn4Ko | AU001A | 2024-09-16T12:16:42.288Z | 2024-09-16T12:17:31.997Z |
5097007 | 5097007 | 20240912133508_HzBfY | AU001A | 2024-09-16T12:16:42.012Z | 2024-09-16T12:17:31.995Z |
5096991 | 5096991 | 20240912132228_bqMqv | AU001A | 2024-09-16T12:16:41.757Z | 2024-09-16T12:17:31.990Z |
5096972 | 5096972 | 20240912131455_7UTP0 | AU001A | 2024-09-16T12:16:40.988Z | 2024-09-16T12:17:31.984Z |
5096946 | 5096946 | 20240912123905_2SJa5 | AU001A | 2024-09-16T12:16:39.803Z | 2024-09-16T12:17:31.972Z |
5096918 | 5096918 | 20240912121926_LXJDZ | AU001A | 2024-09-16T12:16:37.623Z | 2024-09-16T12:17:31.962Z |
5096679 | 5096679 | 20240912112947_o1835 | AU001A | 2024-09-16T12:16:31.422Z | 2024-09-16T12:17:31.849Z |
5096642 | 5096642 | 20240912112654_at913 | AU001A | 2024-09-16T12:16:30.750Z | 2024-09-16T12:17:31.836Z |
5085360 | 5085360 | 20240912211411_kFIyT | AU001A | 2024-09-16T12:04:08.894Z | 2024-09-16T12:17:04.705Z |
5085312 | 5085312 | 20240912210731_X9IBG | AU001A | 2024-09-16T12:03:56.485Z | 2024-09-16T12:17:04.682Z |
5085125 | 5085125 | 20240912204942_IN2qm | AU001A | 2024-09-16T12:03:34.931Z | 2024-09-16T12:17:04.600Z |
5084879 | 5084879 | 20240912202918_H9jMP | AU001A | 2024-09-16T12:03:07.940Z | 2024-09-16T12:17:04.508Z |
5084772 | 5084772 | 20240912201221_52IUa | AU001A | 2024-09-16T12:02:53.066Z | 2024-09-16T12:17:04.449Z |
5084704 | 5084704 | 20240912200748_2RXid | AU001A | 2024-09-16T12:02:49.523Z | 2024-09-16T12:17:04.430Z |
5084663 | 5084663 | 20240912200153_MUpUK | AU001A | 2024-09-16T12:02:44.686Z | 2024-09-16T12:17:04.409Z |
5084620 | 5084620 | 20240912195721_S4Zs4 | AU001A | 2024-09-16T12:02:39.615Z | 2024-09-16T12:17:04.392Z |
5084532 | 5084532 | 20240912194746_hnIpl | AU001A | 2024-09-16T12:02:16.228Z | 2024-09-16T12:17:04.346Z |
5084413 | 5084413 | 20240912193620_sa262 | AU001A | 2024-09-16T12:02:03.351Z | 2024-09-16T12:17:04.297Z |
5084354 | 5084354 | 20240912192632_eATSL | AU001A | 2024-09-16T12:01:56.255Z | 2024-09-16T12:17:04.262Z |
5084274 | 5084274 | 20240912190445_ZdxyJ | AU001A | 2024-09-16T12:01:45.260Z | 2024-09-16T12:17:04.216Z |
5084237 | 5084237 | 20240912190157_62KMS | AU001A | 2024-09-16T12:01:37.932Z | 2024-09-16T12:17:04.194Z |
5084188 | 5084188 | 20240912185316_27zLR | AU001A | 2024-09-16T12:01:30.009Z | 2024-09-16T12:17:04.167Z |
5084181 | 5084181 | 20240912184748_ZjMg9 | AU001A | 2024-09-16T12:01:27.653Z | 2024-09-16T12:17:04.163Z |
5084145 | 5084145 | 20240912182955_dU8WO | AU001A | 2024-09-16T12:01:15.550Z | 2024-09-16T12:17:04.135Z |
5084116 | 5084116 | 20240912181712_FcViC | AU001A | 2024-09-16T12:01:11.375Z | 2024-09-16T12:17:04.103Z |
5084100 | 5084100 | 20240912180837_qK8iO | AU001A | 2024-09-16T12:01:09.038Z | 2024-09-16T12:17:04.096Z |
5084090 | 5084090 | 20240912180553_kuq3q | AU001A | 2024-09-16T12:01:07.399Z | 2024-09-16T12:17:04.089Z |
5084087 | 5084087 | 20240912180522_T69RT | AU001A | 2024-09-16T12:01:06.740Z | 2024-09-16T12:17:04.086Z |
5084074 | 5084074 | 20240912180203_MQwxc | AU001A | 2024-09-16T12:01:05.270Z | 2024-09-16T12:17:04.080Z |
5084042 | 5084042 | 20240912174652_SRlz9 | AU001A | 2024-09-16T12:00:59.208Z | 2024-09-16T12:17:04.057Z |
5084035 | 5084035 | 20240912174216_O7Fo2 | AU001A | 2024-09-16T12:00:58.521Z | 2024-09-16T12:17:04.054Z |
5084023 | 5084023 | 20240912173938_1hhHO | AU001A | 2024-09-16T12:00:56.887Z | 2024-09-16T12:17:04.042Z |
5084018 | 5084018 | 20240912173833_6p3rQ | AU001A | 2024-09-16T12:00:55.947Z | 2024-09-16T12:17:04.037Z |
5083995 | 5083995 | 20240912172531_GEkGa | AU001A | 2024-09-16T12:00:52.208Z | 2024-09-16T12:17:04.021Z |
5083983 | 5083983 | 20240912171352_c4vX2 | AU001A | 2024-09-16T12:00:46.179Z | 2024-09-16T12:17:04.013Z |
5083968 | 5083968 | 20240912171152_hDL7x | AU001A | 2024-09-16T12:00:44.843Z | 2024-09-16T12:17:04.006Z |
5083938 | 5083938 | 20240912170044_uxZ38 | AU001A | 2024-09-16T12:00:42.007Z | 2024-09-16T12:17:03.993Z |
5083890 | 5083890 | 20240912163847_Gopfa | AU001A | 2024-09-16T12:00:36.264Z | 2024-09-16T12:17:03.965Z |
5083878 | 5083878 | 20240912163127_zpikX | AU001A | 2024-09-16T12:00:34.781Z | 2024-09-16T12:17:03.960Z |
5083872 | 5083872 | 20240912162722_bOSXs | AU001A | 2024-09-16T12:00:34.058Z | 2024-09-16T12:17:03.957Z |
5083867 | 5083867 | 20240912162639_zw3wC | AU001A | 2024-09-16T12:00:33.356Z | 2024-09-16T12:17:03.954Z |
5083845 | 5083845 | 20240912161316_E3YPl | AU001A | 2024-09-16T12:00:30.886Z | 2024-09-16T12:17:03.944Z |
5083825 | 5083825 | 20240912160214_pl6G8 | AU001A | 2024-09-16T12:00:27.352Z | 2024-09-16T12:17:03.928Z |
5083804 | 5083804 | 20240912154658_M20vO | AU001A | 2024-09-16T12:00:24.691Z | 2024-09-16T12:17:03.918Z |
5083802 | 5083802 | 20240912154434_x4iz0 | AU001A | 2024-09-16T12:00:24.266Z | 2024-09-16T12:17:03.916Z |
5083795 | 5083795 | 20240912154221_ZtqU0 | AU001A | 2024-09-16T12:00:23.495Z | 2024-09-16T12:17:03.912Z |
5083792 | 5083792 | 20240912153535_q6uth | AU001A | 2024-09-16T12:00:22.825Z | 2024-09-16T12:17:03.909Z |
5083763 | 5083763 | 20240912151420_rAlW9 | AU001A | 2024-09-16T12:00:16.886Z | 2024-09-16T12:17:03.881Z |
5083668 | 5083668 | 20240911140935_x02qs | AU001A | 2024-09-15T12:18:45.298Z | 2024-09-16T12:19:20.098Z |
5083663 | 5083663 | 20240911140823_lKAgz | AU001A | 2024-09-15T12:18:45.237Z | 2024-09-16T12:19:20.094Z |
5083530 | 5083530 | 20240911134127_kskys | AU001A | 2024-09-15T12:18:43.372Z | 2024-09-16T12:19:19.395Z |
5083501 | 5083501 | 20240911133327_bkovf | AU001A | 2024-09-15T12:18:42.754Z | 2024-09-16T12:19:18.723Z |
5083305 | 5083305 | 20240911125158_cPR92 | AU001A | 2024-09-15T12:18:38.693Z | 2024-09-16T12:19:17.905Z |
5083287 | 5083287 | 20240911124616_hojaY | AU001A | 2024-09-15T12:18:38.332Z | 2024-09-16T12:19:17.704Z |
5083152 | 5083152 | 20240911121526_czfOD | AU001A | 2024-09-15T12:18:36.235Z | 2024-09-16T12:19:16.943Z |
5083108 | 5083108 | 20240911120545_IXKFN | AU001A | 2024-09-15T12:18:35.848Z | 2024-09-16T12:19:16.682Z |
5082965 | 5082965 | 20240911113646_Angyg | AU001A | 2024-09-15T12:18:31.903Z | 2024-09-16T12:19:16.151Z |
5072192 | 5072192 | 20240911194706_AIkJZ | AU001A | 2024-09-15T12:04:52.089Z | 2024-09-16T12:17:29.044Z |
5072096 | 5072096 | 20240911193307_1AWw5 | AU001A | 2024-09-15T12:04:38.748Z | 2024-09-16T12:17:29.024Z |
5072047 | 5072047 | 20240911192703_qYSIo | AU001A | 2024-09-15T12:04:32.234Z | 2024-09-16T12:17:29.012Z |
5072025 | 5072025 | 20240911192356_5JVro | AU001A | 2024-09-15T12:04:24.568Z | 2024-09-16T12:17:29.007Z |
5072005 | 5072005 | 20240911192015_Ew7FI | AU001A | 2024-09-15T12:04:17.681Z | 2024-09-16T12:17:29.001Z |
5072001 | 5072001 | 20240911191940_dAv3R | AU001A | 2024-09-15T12:04:17.064Z | 2024-09-16T12:17:29.000Z |
5071967 | 5071967 | 20240911191243_6uZGv | AU001A | 2024-09-15T12:04:09.441Z | 2024-09-16T12:17:28.992Z |
5071948 | 5071948 | 20240911190850_q1EBF | AU001A | 2024-09-15T12:04:05.875Z | 2024-09-16T12:17:28.987Z |
5071906 | 5071906 | 20240911185603_KmTlc | AU001A | 2024-09-15T12:03:59.719Z | 2024-09-16T12:17:28.975Z |
5071900 | 5071900 | 20240911185536_3MEYT | AU001A | 2024-09-15T12:03:59.031Z | 2024-09-16T12:17:28.974Z |
5071845 | 5071845 | 20240911183443_tv1af | AU001A | 2024-09-15T12:03:49.762Z | 2024-09-16T12:17:28.957Z |
5071843 | 5071843 | 20240911183416_VBHli | AU001A | 2024-09-15T12:03:49.419Z | 2024-09-16T12:17:28.956Z |
5071828 | 5071828 | 20240911183147_gctqx | AU001A | 2024-09-15T12:03:47.649Z | 2024-09-16T12:17:28.952Z |
5071755 | 5071755 | 20240911181042_3mrFf | AU001A | 2024-09-15T12:03:25.397Z | 2024-09-16T12:17:28.921Z |
5071727 | 5071727 | 20240911180309_LcCGo | AU001A | 2024-09-15T12:03:20.921Z | 2024-09-16T12:17:28.914Z |
5071715 | 5071715 | 20240911175824_51nbC | AU001A | 2024-09-15T12:03:19.052Z | 2024-09-16T12:17:28.911Z |
5071710 | 5071710 | 20240911175611_qpqkC | AU001A | 2024-09-15T12:03:18.092Z | 2024-09-16T12:17:28.910Z |
5071708 | 5071708 | 20240911175550_7G3Ph | AU001A | 2024-09-15T12:03:17.787Z | 2024-09-16T12:17:28.909Z |
5071697 | 5071697 | 20240911175257_pnoqM | AU001A | 2024-09-15T12:03:16.761Z | 2024-09-16T12:17:28.899Z |
5071688 | 5071688 | 20240911175018_OBbGJ | AU001A | 2024-09-15T12:03:15.411Z | 2024-09-16T12:17:28.897Z |
5071660 | 5071660 | 20240911173828_Z2D4i | AU001A | 2024-09-15T12:03:11.609Z | 2024-09-16T12:17:28.890Z |
5071656 | 5071656 | 20240911173703_WZGHT | AU001A | 2024-09-15T12:03:11.275Z | 2024-09-16T12:17:28.889Z |
5071607 | 5071607 | 20240911172548_ZKCBj | AU001A | 2024-09-15T12:03:03.665Z | 2024-09-16T12:17:28.874Z |
5071583 | 5071583 | 20240911172148_834dl | AU001A | 2024-09-15T12:03:00.983Z | 2024-09-16T12:17:28.869Z |
5071538 | 5071538 | 20240911171231_hgPDt | AU001A | 2024-09-15T12:02:51.383Z | 2024-09-16T12:17:28.857Z |
5071532 | 5071532 | 20240911171214_psJJy | AU001A | 2024-09-15T12:02:49.770Z | 2024-09-16T12:17:28.856Z |
5071515 | 5071515 | 20240911171016_7piOx | AU001A | 2024-09-15T12:02:45.870Z | 2024-09-16T12:17:28.851Z |
5071511 | 5071511 | 20240911170945_A9HWi | AU001A | 2024-09-15T12:02:44.869Z | 2024-09-16T12:17:28.850Z |
5071487 | 5071487 | 20240911170219_oYtUM | AU001A | 2024-09-15T12:02:39.761Z | 2024-09-16T12:17:28.843Z |
5071387 | 5071387 | 20240911164507_P7KLz | AU001A | 2024-09-15T12:02:25.855Z | 2024-09-16T12:17:28.798Z |
5071336 | 5071336 | 20240911163501_4uxsV | AU001A | 2024-09-15T12:02:19.444Z | 2024-09-16T12:17:28.786Z |
5071297 | 5071297 | 20240911163014_jEswr | AU001A | 2024-09-15T12:02:11.806Z | 2024-09-16T12:17:28.779Z |
5071269 | 5071269 | 20240911162552_mBU73 | AU001A | 2024-09-15T12:02:06.923Z | 2024-09-16T12:17:28.773Z |
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);