participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
11,254 rows where station_code = "AU001W" 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 |
---|---|---|---|---|---|
5097127 | 5097127 | 20240912145538_g6YsQ | AU001W | 2024-09-16T12:16:45.937Z | 2024-09-16T12:17:32.042Z |
5097111 | 5097111 | 20240912144213_6C7gB | AU001W | 2024-09-16T12:16:45.410Z | 2024-09-16T12:17:32.037Z |
5097093 | 5097093 | 20240912143415_fIErT | AU001W | 2024-09-16T12:16:44.752Z | 2024-09-16T12:17:32.029Z |
5097072 | 5097072 | 20240912141822_QMeS2 | AU001W | 2024-09-16T12:16:44.264Z | 2024-09-16T12:17:32.021Z |
5096633 | 5096633 | 20240912112542_A8ckb | AU001W | 2024-09-16T12:16:30.152Z | 2024-09-16T12:17:31.828Z |
5085309 | 5085309 | 20240912210727_Y0VLC | AU001W | 2024-09-16T12:03:55.452Z | 2024-09-16T12:17:04.681Z |
5085117 | 5085117 | 20240912204706_uaGmz | AU001W | 2024-09-16T12:03:33.804Z | 2024-09-16T12:17:04.594Z |
5084895 | 5084895 | 20240912203207_rR7u8 | AU001W | 2024-09-16T12:03:09.866Z | 2024-09-16T12:17:04.516Z |
5084826 | 5084826 | 20240912201654_S3ohr | AU001W | 2024-09-16T12:02:58.222Z | 2024-09-16T12:17:04.470Z |
5084699 | 5084699 | 20240912200733_kUBCF | AU001W | 2024-09-16T12:02:49.222Z | 2024-09-16T12:17:04.428Z |
5084553 | 5084553 | 20240912195009_HFQqx | AU001W | 2024-09-16T12:02:23.275Z | 2024-09-16T12:17:04.358Z |
5084386 | 5084386 | 20240912193214_7tirv | AU001W | 2024-09-16T12:02:00.296Z | 2024-09-16T12:17:04.285Z |
5084302 | 5084302 | 20240912191257_c3nql | AU001W | 2024-09-16T12:01:49.994Z | 2024-09-16T12:17:04.237Z |
5084218 | 5084218 | 20240912185920_2hsms | AU001W | 2024-09-16T12:01:35.849Z | 2024-09-16T12:17:04.186Z |
5084209 | 5084209 | 20240912185826_U5au3 | AU001W | 2024-09-16T12:01:34.846Z | 2024-09-16T12:17:04.181Z |
5084198 | 5084198 | 20240912185425_x2QKH | AU001W | 2024-09-16T12:01:33.916Z | 2024-09-16T12:17:04.172Z |
5084174 | 5084174 | 20240912184604_aB1oq | AU001W | 2024-09-16T12:01:25.472Z | 2024-09-16T12:17:04.160Z |
5084132 | 5084132 | 20240912182254_oLYTG | AU001W | 2024-09-16T12:01:13.813Z | 2024-09-16T12:17:04.112Z |
5084127 | 5084127 | 20240912182026_qxoOd | AU001W | 2024-09-16T12:01:13.008Z | 2024-09-16T12:17:04.109Z |
5084103 | 5084103 | 20240912180937_wNbGG | AU001W | 2024-09-16T12:01:09.458Z | 2024-09-16T12:17:04.096Z |
5084083 | 5084083 | 20240912180325_g3n66 | AU001W | 2024-09-16T12:01:06.439Z | 2024-09-16T12:17:04.085Z |
5084065 | 5084065 | 20240912175742_SMXvy | AU001W | 2024-09-16T12:01:03.263Z | 2024-09-16T12:17:04.072Z |
5083975 | 5083975 | 20240912171225_2lk8f | AU001W | 2024-09-16T12:00:45.470Z | 2024-09-16T12:17:04.009Z |
5083946 | 5083946 | 20240912170349_N7zML | AU001W | 2024-09-16T12:00:42.530Z | 2024-09-16T12:17:03.996Z |
5083922 | 5083922 | 20240912164605_cYg11 | AU001W | 2024-09-16T12:00:39.540Z | 2024-09-16T12:17:03.977Z |
5083898 | 5083898 | 20240912163922_LB9G5 | AU001W | 2024-09-16T12:00:36.877Z | 2024-09-16T12:17:03.968Z |
5083891 | 5083891 | 20240912163847_Gopfa | AU001W | 2024-09-16T12:00:36.264Z | 2024-09-16T12:17:03.966Z |
5083859 | 5083859 | 20240912162035_Ev8sw | AU001W | 2024-09-16T12:00:32.585Z | 2024-09-16T12:17:03.952Z |
5083808 | 5083808 | 20240912154703_1Q4Yh | AU001W | 2024-09-16T12:00:25.109Z | 2024-09-16T12:17:03.919Z |
5083747 | 5083747 | 20240911141908_6Us4N | AU001W | 2024-09-15T12:18:45.869Z | 2024-09-16T12:19:20.414Z |
5083711 | 5083711 | 20240911141242_7g8sj | AU001W | 2024-09-15T12:18:45.641Z | 2024-09-16T12:19:20.172Z |
5083666 | 5083666 | 20240911140847_nzvPc | AU001W | 2024-09-15T12:18:45.277Z | 2024-09-16T12:19:20.095Z |
5083541 | 5083541 | 20240911134528_w1ZWs | AU001W | 2024-09-15T12:18:43.480Z | 2024-09-16T12:19:19.412Z |
5083352 | 5083352 | 20240911130020_GrCIz | AU001W | 2024-09-15T12:18:39.968Z | 2024-09-16T12:19:18.092Z |
5083308 | 5083308 | 20240911125158_cPR92 | AU001W | 2024-09-15T12:18:38.693Z | 2024-09-16T12:19:17.905Z |
5082900 | 5082900 | 20240911112347_Hm6Vo | AU001W | 2024-09-15T12:18:29.387Z | 2024-09-16T12:19:15.649Z |
5082829 | 5082829 | 20240911110605_NOZUl | AU001W | 2024-09-15T12:18:26.645Z | 2024-09-16T12:19:14.774Z |
5073418 | 5073418 | 20240911212015_LYdu3 | AU001W | 2024-09-15T12:07:09.149Z | 2024-09-16T12:17:29.243Z |
5073242 | 5073242 | 20240911210953_2U8nt | AU001W | 2024-09-15T12:06:57.266Z | 2024-09-16T12:17:29.218Z |
5073118 | 5073118 | 20240911210008_zrmuR | AU001W | 2024-09-15T12:06:41.955Z | 2024-09-16T12:17:29.198Z |
5073040 | 5073040 | 20240911205626_0zqhB | AU001W | 2024-09-15T12:06:32.016Z | 2024-09-16T12:17:29.191Z |
5073033 | 5073033 | 20240911205446_rhL30 | AU001W | 2024-09-15T12:06:30.315Z | 2024-09-16T12:17:29.188Z |
5073018 | 5073018 | 20240911205213_syV9q | AU001W | 2024-09-15T12:06:26.856Z | 2024-09-16T12:17:29.185Z |
5072981 | 5072981 | 20240911205059_bikva | AU001W | 2024-09-15T12:06:23.266Z | 2024-09-16T12:17:29.179Z |
5072951 | 5072951 | 20240911204826_KZVmh | AU001W | 2024-09-15T12:06:21.036Z | 2024-09-16T12:17:29.174Z |
5072721 | 5072721 | 20240911203819_fvIY3 | AU001W | 2024-09-15T12:06:03.252Z | 2024-09-16T12:17:29.140Z |
5072696 | 5072696 | 20240911203809_JF73a | AU001W | 2024-09-15T12:06:02.295Z | 2024-09-16T12:17:29.138Z |
5072598 | 5072598 | 20240911202750_AphWo | AU001W | 2024-09-15T12:05:43.370Z | 2024-09-16T12:17:29.116Z |
5072478 | 5072478 | 20240911201214_mPOOt | AU001W | 2024-09-15T12:05:27.832Z | 2024-09-16T12:17:29.093Z |
5072419 | 5072419 | 20240911200719_XI34e | AU001W | 2024-09-15T12:05:20.592Z | 2024-09-16T12:17:29.080Z |
5072377 | 5072377 | 20240911200117_gUtUI | AU001W | 2024-09-15T12:05:16.226Z | 2024-09-16T12:17:29.071Z |
5072347 | 5072347 | 20240911195626_GMT8x | AU001W | 2024-09-15T12:05:13.250Z | 2024-09-16T12:17:29.066Z |
5072187 | 5072187 | 20240911194609_BRkWO | AU001W | 2024-09-15T12:04:50.748Z | 2024-09-16T12:17:29.042Z |
5072059 | 5072059 | 20240911192716_h032W | AU001W | 2024-09-15T12:04:33.709Z | 2024-09-16T12:17:29.014Z |
5072036 | 5072036 | 20240911192506_FWBIm | AU001W | 2024-09-15T12:04:29.498Z | 2024-09-16T12:17:29.009Z |
5071999 | 5071999 | 20240911191810_AHhW2 | AU001W | 2024-09-15T12:04:16.109Z | 2024-09-16T12:17:29.000Z |
5071961 | 5071961 | 20240911191101_4WAuR | AU001W | 2024-09-15T12:04:08.241Z | 2024-09-16T12:17:28.990Z |
5071903 | 5071903 | 20240911185536_3MEYT | AU001W | 2024-09-15T12:03:59.031Z | 2024-09-16T12:17:28.974Z |
5071880 | 5071880 | 20240911184651_q3IKM | AU001W | 2024-09-15T12:03:54.807Z | 2024-09-16T12:17:28.966Z |
5071875 | 5071875 | 20240911184531_YcRZB | AU001W | 2024-09-15T12:03:54.117Z | 2024-09-16T12:17:28.965Z |
5071851 | 5071851 | 20240911183443_qkZ1L | AU001W | 2024-09-15T12:03:50.095Z | 2024-09-16T12:17:28.957Z |
5071812 | 5071812 | 20240911182625_5nhDV | AU001W | 2024-09-15T12:03:44.815Z | 2024-09-16T12:17:28.948Z |
5071804 | 5071804 | 20240911182345_qO9Bq | AU001W | 2024-09-15T12:03:40.139Z | 2024-09-16T12:17:28.946Z |
5071791 | 5071791 | 20240911181955_1CDaT | AU001W | 2024-09-15T12:03:33.888Z | 2024-09-16T12:17:28.942Z |
5071774 | 5071774 | 20240911181530_BPvG3 | AU001W | 2024-09-15T12:03:30.220Z | 2024-09-16T12:17:28.937Z |
5071730 | 5071730 | 20240911180323_IzPRb | AU001W | 2024-09-15T12:03:21.421Z | 2024-09-16T12:17:28.915Z |
5071713 | 5071713 | 20240911175742_L8y1c | AU001W | 2024-09-15T12:03:18.477Z | 2024-09-16T12:17:28.911Z |
5071678 | 5071678 | 20240911174340_chVe9 | AU001W | 2024-09-15T12:03:13.401Z | 2024-09-16T12:17:28.893Z |
5071668 | 5071668 | 20240911174209_g0s7b | AU001W | 2024-09-15T12:03:12.757Z | 2024-09-16T12:17:28.892Z |
5071630 | 5071630 | 20240911173116_b5LqY | AU001W | 2024-09-15T12:03:07.017Z | 2024-09-16T12:17:28.881Z |
5071627 | 5071627 | 20240911173112_Uaozf | AU001W | 2024-09-15T12:03:06.643Z | 2024-09-16T12:17:28.880Z |
5071624 | 5071624 | 20240911173027_po64U | AU001W | 2024-09-15T12:03:06.081Z | 2024-09-16T12:17:28.879Z |
5071597 | 5071597 | 20240911172407_ET2pE | AU001W | 2024-09-15T12:03:02.923Z | 2024-09-16T12:17:28.872Z |
5071412 | 5071412 | 20240911164804_qcCH1 | AU001W | 2024-09-15T12:02:29.163Z | 2024-09-16T12:17:28.804Z |
5071368 | 5071368 | 20240911164037_PYS2Y | AU001W | 2024-09-15T12:02:23.130Z | 2024-09-16T12:17:28.793Z |
5071361 | 5071361 | 20240911163919_ekajK | AU001W | 2024-09-15T12:02:22.416Z | 2024-09-16T12:17:28.792Z |
5070661 | 5070661 | 20240911144609_lftT5 | AU001W | 2024-09-15T12:00:28.770Z | 2024-09-16T12:17:28.637Z |
5070537 | 5070537 | 20240911142817_GwMSl | AU001W | 2024-09-15T12:00:15.976Z | 2024-09-16T12:17:28.613Z |
5063198 | 5063198 | 20240909201630_3C2sT | AU001W | 2024-09-14T12:13:39.914Z | 2024-09-16T12:19:42.527Z |
5063180 | 5063180 | 20240909201131_o2Jlx | AU001W | 2024-09-14T12:13:38.112Z | 2024-09-16T12:19:42.480Z |
5062997 | 5062997 | 20240909193157_XMCsD | AU001W | 2024-09-14T12:13:15.566Z | 2024-09-16T12:19:40.744Z |
5062976 | 5062976 | 20240909192535_Y2c2F | AU001W | 2024-09-14T12:13:12.536Z | 2024-09-16T12:19:40.686Z |
5062967 | 5062967 | 20240909192301_DiN2X | AU001W | 2024-09-14T12:13:10.016Z | 2024-09-16T12:19:40.638Z |
5062952 | 5062952 | 20240909192142_8XPn4 | AU001W | 2024-09-14T12:13:07.734Z | 2024-09-16T12:19:40.581Z |
5062848 | 5062848 | 20240909184050_fCRjV | AU001W | 2024-09-14T12:12:58.183Z | 2024-09-16T12:19:39.815Z |
5062840 | 5062840 | 20240909183803_ZpqTN | AU001W | 2024-09-14T12:12:56.779Z | 2024-09-16T12:19:39.792Z |
5062837 | 5062837 | 20240909183629_7M3RM | AU001W | 2024-09-14T12:12:56.503Z | 2024-09-16T12:19:39.789Z |
5062805 | 5062805 | 20240909182751_r5IrT | AU001W | 2024-09-14T12:12:53.527Z | 2024-09-16T12:19:39.648Z |
5062782 | 5062782 | 20240909182345_CORJ8 | AU001W | 2024-09-14T12:12:50.700Z | 2024-09-16T12:19:39.561Z |
5062770 | 5062770 | 20240909181857_KRv3j | AU001W | 2024-09-14T12:12:48.909Z | 2024-09-16T12:19:39.396Z |
5062767 | 5062767 | 20240909181748_Xx2Ru | AU001W | 2024-09-14T12:12:48.398Z | 2024-09-16T12:19:39.286Z |
5062738 | 5062738 | 20240909180930_N1S20 | AU001W | 2024-09-14T12:12:46.517Z | 2024-09-16T12:19:39.190Z |
5062721 | 5062721 | 20240909180422_fbyiD | AU001W | 2024-09-14T12:12:45.178Z | 2024-09-16T12:19:38.902Z |
5062649 | 5062649 | 20240909175426_HBA5W | AU001W | 2024-09-14T12:12:40.610Z | 2024-09-16T12:19:38.327Z |
5062644 | 5062644 | 20240909175401_Q2jhc | AU001W | 2024-09-14T12:12:40.219Z | 2024-09-16T12:19:38.284Z |
5062557 | 5062557 | 20240909174032_THjag | AU001W | 2024-09-14T12:12:33.131Z | 2024-09-16T12:19:37.745Z |
5062489 | 5062489 | 20240909173125_J4Iei | AU001W | 2024-09-14T12:12:27.753Z | 2024-09-16T12:19:37.539Z |
5062468 | 5062468 | 20240909172833_3IuQC | AU001W | 2024-09-14T12:12:24.564Z | 2024-09-16T12:19:37.460Z |
5062204 | 5062204 | 20240909165641_YZybs | AU001W | 2024-09-14T12:11:55.415Z | 2024-09-16T12:19:36.370Z |
5062196 | 5062196 | 20240909165636_dQShA | AU001W | 2024-09-14T12:11:55.083Z | 2024-09-16T12:19:36.357Z |
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);