participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,212 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 |
---|---|---|---|---|---|
5461311 | 5461311 | 20241101175239_ScEJv | AU001K | 2024-11-03T14:15:08.154Z | 2024-11-03T14:19:33.724Z |
5461291 | 5461291 | 20241101173607_wJGPz | AU001K | 2024-11-03T14:15:03.885Z | 2024-11-03T14:19:33.718Z |
5461242 | 5461242 | 20241101171152_j2QR7 | AU001K | 2024-11-03T14:14:56.609Z | 2024-11-03T14:19:33.706Z |
5461210 | 5461210 | 20241101165900_qO5LX | AU001K | 2024-11-03T14:14:51.686Z | 2024-11-03T14:19:33.699Z |
5461208 | 5461208 | 20241101165851_BbaGB | AU001K | 2024-11-03T14:14:51.596Z | 2024-11-03T14:19:33.698Z |
5461177 | 5461177 | 20241101163028_0hxOX | AU001K | 2024-11-03T14:14:48.079Z | 2024-11-03T14:19:33.690Z |
5461173 | 5461173 | 20241101162816_53H3G | AU001K | 2024-11-03T14:14:47.730Z | 2024-11-03T14:19:33.689Z |
5461163 | 5461163 | 20241101161904_9vH5f | AU001K | 2024-11-03T14:14:46.663Z | 2024-11-03T14:19:33.686Z |
5461123 | 5461123 | 20241101160638_gNqzJ | AU001K | 2024-11-03T14:14:44.675Z | 2024-11-03T14:19:33.678Z |
5461102 | 5461102 | 20241101155729_4X9JG | AU001K | 2024-11-03T14:14:43.479Z | 2024-11-03T14:19:33.672Z |
5461046 | 5461046 | 20241101154027_pmLCw | AU001K | 2024-11-03T14:14:40.785Z | 2024-11-03T14:19:33.661Z |
5460690 | 5460690 | 20241101144933_3C7PA | AU001K | 2024-11-03T14:14:14.586Z | 2024-11-03T14:19:33.597Z |
5460568 | 5460568 | 20241101143128_3euep | AU001K | 2024-11-03T14:13:59.755Z | 2024-11-03T14:19:33.577Z |
5460541 | 5460541 | 20241101142824_AcqOD | AU001K | 2024-11-03T14:13:57.430Z | 2024-11-03T14:19:33.571Z |
5460371 | 5460371 | 20241101135911_7eu5B | AU001K | 2024-11-03T14:13:38.861Z | 2024-11-03T14:19:33.532Z |
5460287 | 5460287 | 20241101133533_2Qfbd | AU001K | 2024-11-03T14:13:33.414Z | 2024-11-03T14:19:33.515Z |
5460260 | 5460260 | 20241101132450_24Vyf | AU001K | 2024-11-03T14:13:31.371Z | 2024-11-03T14:19:33.509Z |
5460168 | 5460168 | 20241101130108_697kc | AU001K | 2024-11-03T14:13:25.946Z | 2024-11-03T14:19:33.491Z |
5460137 | 5460137 | 20241101125256_sKtID | AU001K | 2024-11-03T14:13:23.944Z | 2024-11-03T14:19:33.485Z |
5460084 | 5460084 | 20241101124015_3gT2T | AU001K | 2024-11-03T14:13:20.255Z | 2024-11-03T14:19:33.474Z |
5459915 | 5459915 | 20241101121630_rhK3k | AU001K | 2024-11-03T14:12:50.071Z | 2024-11-03T14:19:33.444Z |
5459673 | 5459673 | 20241101113623_KlyKd | AU001K | 2024-11-03T14:12:27.261Z | 2024-11-03T14:19:33.395Z |
5459373 | 5459373 | 20241101104937_3Uy5x | AU001K | 2024-11-03T14:11:46.041Z | 2024-11-03T14:19:33.330Z |
5459096 | 5459096 | 20241101100653_UjTrZ | AU001K | 2024-11-03T14:11:19.468Z | 2024-11-03T14:19:33.267Z |
5458847 | 5458847 | 20241101092636_A3uy3 | AU001K | 2024-11-03T14:10:42.053Z | 2024-11-03T14:19:33.211Z |
5458114 | 5458114 | 20241102180601_IxmfP | AU001K | 2024-11-03T14:08:51.833Z | 2024-11-03T14:08:51.833Z |
5458112 | 5458112 | 20241102175103_THmw4 | AU001K | 2024-11-03T14:08:51.581Z | 2024-11-03T14:08:51.581Z |
5458104 | 5458104 | 20241102173020_J8xz3 | AU001K | 2024-11-03T14:08:50.350Z | 2024-11-03T14:08:50.350Z |
5458102 | 5458102 | 20241102172808_bTUMG | AU001K | 2024-11-03T14:08:50.014Z | 2024-11-03T14:08:50.014Z |
5458100 | 5458100 | 20241102172332_vxZWf | AU001K | 2024-11-03T14:08:49.695Z | 2024-11-03T14:08:49.695Z |
5458091 | 5458091 | 20241102164337_qzju8 | AU001K | 2024-11-03T14:08:48.535Z | 2024-11-03T14:08:48.535Z |
5457994 | 5457994 | 20241102155542_mOUJL | AU001K | 2024-11-03T14:08:30.962Z | 2024-11-03T14:08:30.962Z |
5457959 | 5457959 | 20241102154732_emuhB | AU001K | 2024-11-03T14:08:24.286Z | 2024-11-03T14:08:24.286Z |
5457548 | 5457548 | 20241102144406_tcJI7 | AU001K | 2024-11-03T14:07:38.303Z | 2024-11-03T14:07:38.303Z |
5457291 | 5457291 | 20241102140547_Fz7FS | AU001K | 2024-11-03T14:07:03.689Z | 2024-11-03T14:07:03.689Z |
5457207 | 5457207 | 20241102134827_pDVSs | AU001K | 2024-11-03T14:06:48.410Z | 2024-11-03T14:06:48.410Z |
5456949 | 5456949 | 20241102125725_fC2N3 | AU001K | 2024-11-03T14:06:08.144Z | 2024-11-03T14:06:08.144Z |
5456762 | 5456762 | 20241102121923_fnSW6 | AU001K | 2024-11-03T14:05:38.769Z | 2024-11-03T14:05:38.769Z |
5456745 | 5456745 | 20241102121339_xEIjj | AU001K | 2024-11-03T14:05:36.526Z | 2024-11-03T14:05:36.526Z |
5456700 | 5456700 | 20241102120637_lh2kC | AU001K | 2024-11-03T14:05:30.456Z | 2024-11-03T14:05:30.456Z |
5456201 | 5456201 | 20241102104105_35Pur | AU001K | 2024-11-03T14:03:46.999Z | 2024-11-03T14:03:46.999Z |
5456100 | 5456100 | 20241102102127_taOsI | AU001K | 2024-11-03T14:03:20.986Z | 2024-11-03T14:03:20.986Z |
5455936 | 5455936 | 20241102094837_jlhHy | AU001K | 2024-11-03T14:02:52.610Z | 2024-11-03T14:02:52.610Z |
5450127 | 5450127 | 20241031175833_dn4pt | AU001K | 2024-11-02T12:14:37.238Z | 2024-11-03T14:21:06.100Z |
5450098 | 5450098 | 20241031175423_u1CK5 | AU001K | 2024-11-02T12:14:33.007Z | 2024-11-03T14:21:05.270Z |
5450089 | 5450089 | 20241031175130_42DGD | AU001K | 2024-11-02T12:14:31.362Z | 2024-11-03T14:21:05.110Z |
5449983 | 5449983 | 20241031172809_efc21 | AU001K | 2024-11-02T12:14:04.342Z | 2024-11-03T14:21:02.448Z |
5449957 | 5449957 | 20241031172338_ER0Ox | AU001K | 2024-11-02T12:14:02.495Z | 2024-11-03T14:21:02.065Z |
5449942 | 5449942 | 20241031172139_ref2h | AU001K | 2024-11-02T12:13:59.749Z | 2024-11-03T14:21:01.835Z |
5449808 | 5449808 | 20241031164501_PtdQL | AU001K | 2024-11-02T12:13:47.549Z | 2024-11-03T14:20:59.041Z |
5449800 | 5449800 | 20241031164407_r474h | AU001K | 2024-11-02T12:13:47.055Z | 2024-11-03T14:20:59.001Z |
5449658 | 5449658 | 20241031160435_q1Dr6 | AU001K | 2024-11-02T12:13:17.560Z | 2024-11-03T14:20:56.203Z |
5449517 | 5449517 | 20241031154651_2EW1P | AU001K | 2024-11-02T12:13:02.979Z | 2024-11-03T14:20:54.027Z |
5449329 | 5449329 | 20241031152019_lbPNI | AU001K | 2024-11-02T12:12:32.743Z | 2024-11-03T14:20:51.658Z |
5449183 | 5449183 | 20241031150221_k3rjD | AU001K | 2024-11-02T12:12:13.410Z | 2024-11-03T14:20:49.347Z |
5449143 | 5449143 | 20241031145856_s3i01 | AU001K | 2024-11-02T12:12:09.769Z | 2024-11-03T14:20:49.161Z |
5449063 | 5449063 | 20241031144804_VwSmz | AU001K | 2024-11-02T12:12:01.532Z | 2024-11-03T14:20:48.092Z |
5438826 | 5438826 | 20241030181120_RGNZa | AU001K | 2024-11-01T12:12:30.035Z | 2024-11-03T14:22:44.512Z |
5438802 | 5438802 | 20241030180525_ylv0K | AU001K | 2024-11-01T12:12:28.193Z | 2024-11-03T14:22:44.438Z |
5438733 | 5438733 | 20241030175647_AxE7n | AU001K | 2024-11-01T12:12:21.239Z | 2024-11-03T14:22:43.972Z |
5438609 | 5438609 | 20241030174124_atV2r | AU001K | 2024-11-01T12:12:05.359Z | 2024-11-03T14:22:43.480Z |
5438368 | 5438368 | 20241030170843_bQPq1 | AU001K | 2024-11-01T12:11:36.368Z | 2024-11-03T14:22:42.533Z |
5438252 | 5438252 | 20241030165054_N6hqB | AU001K | 2024-11-01T12:11:24.843Z | 2024-11-03T14:22:42.028Z |
5438206 | 5438206 | 20241030164045_3zmFy | AU001K | 2024-11-01T12:11:18.913Z | 2024-11-03T14:22:41.939Z |
5438086 | 5438086 | 20241030162002_yD9SF | AU001K | 2024-11-01T12:10:57.092Z | 2024-11-03T14:22:41.523Z |
5437801 | 5437801 | 20241030154607_3oiEr | AU001K | 2024-11-01T12:10:21.949Z | 2024-11-03T14:22:40.621Z |
5437798 | 5437798 | 20241030154531_u3Bog | AU001K | 2024-11-01T12:10:21.714Z | 2024-11-03T14:22:40.615Z |
5437577 | 5437577 | 20241030152347_WI9Ys | AU001K | 2024-11-01T12:10:02.440Z | 2024-11-03T14:22:40.051Z |
5437437 | 5437437 | 20241030150841_Odjd6 | AU001K | 2024-11-01T12:09:36.781Z | 2024-11-03T14:22:39.603Z |
5437369 | 5437369 | 20241030150020_cnroD | AU001K | 2024-11-01T12:09:28.215Z | 2024-11-03T14:22:39.368Z |
5437117 | 5437117 | 20241030142936_sX40y | AU001K | 2024-11-01T12:08:57.607Z | 2024-11-03T14:22:38.599Z |
5437096 | 5437096 | 20241030142759_B1eUZ | AU001K | 2024-11-01T12:08:53.809Z | 2024-11-03T14:22:38.571Z |
5436900 | 5436900 | 20241030140354_AmB32 | AU001K | 2024-11-01T12:08:34.062Z | 2024-11-03T14:22:38.014Z |
5436667 | 5436667 | 20241030133442_SFLGT | AU001K | 2024-11-01T12:08:02.589Z | 2024-11-03T14:22:37.453Z |
5436606 | 5436606 | 20241030132730_z6Pid | AU001K | 2024-11-01T12:07:57.055Z | 2024-11-03T14:22:37.245Z |
5436579 | 5436579 | 20241030132331_fr31f | AU001K | 2024-11-01T12:07:54.548Z | 2024-11-03T14:22:37.119Z |
5436396 | 5436396 | 20241030130018_BEMdW | AU001K | 2024-11-01T12:07:28.353Z | 2024-11-03T14:22:36.491Z |
5436358 | 5436358 | 20241030125717_yKm0e | AU001K | 2024-11-01T12:07:23.228Z | 2024-11-03T14:22:36.358Z |
5436263 | 5436263 | 20241030124303_lZMHT | AU001K | 2024-11-01T12:07:11.582Z | 2024-11-03T14:22:36.061Z |
5436130 | 5436130 | 20241030123054_qpa9t | AU001K | 2024-11-01T12:06:51.788Z | 2024-11-03T14:22:35.380Z |
5435834 | 5435834 | 20241030120149_LLznu | AU001K | 2024-11-01T12:06:02.209Z | 2024-11-03T14:22:34.236Z |
5434561 | 5434561 | 20241030094224_tfBC3 | AU001K | 2024-11-01T12:02:41.787Z | 2024-11-03T14:22:23.659Z |
5434506 | 5434506 | 20241030093630_4esCo | AU001K | 2024-11-01T12:02:32.844Z | 2024-11-03T14:22:23.112Z |
5428718 | 5428718 | 20241028175929_2cpoP | AU001K | 2024-10-31T12:15:27.156Z | 2024-11-03T14:24:53.587Z |
5428631 | 5428631 | 20241028174408_pRfqy | AU001K | 2024-10-31T12:15:20.983Z | 2024-11-03T14:24:52.853Z |
5428482 | 5428482 | 20241028172009_MhDIp | AU001K | 2024-10-31T12:15:11.839Z | 2024-11-03T14:24:51.912Z |
5428444 | 5428444 | 20241028171549_RDLRI | AU001K | 2024-10-31T12:15:09.934Z | 2024-11-03T14:24:51.767Z |
5428369 | 5428369 | 20241028165928_ZUFy0 | AU001K | 2024-10-31T12:15:05.118Z | 2024-11-03T14:24:51.560Z |
5428356 | 5428356 | 20241028165738_jsTHI | AU001K | 2024-10-31T12:15:04.777Z | 2024-11-03T14:24:51.543Z |
5428311 | 5428311 | 20241028165029_mbY32 | AU001K | 2024-10-31T12:14:58.871Z | 2024-11-03T14:24:51.447Z |
5428229 | 5428229 | 20241028163852_KuoEe | AU001K | 2024-10-31T12:14:48.083Z | 2024-11-03T14:24:50.662Z |
5428219 | 5428219 | 20241028163828_3zbAs | AU001K | 2024-10-31T12:14:47.489Z | 2024-11-03T14:24:50.658Z |
5428203 | 5428203 | 20241028163633_nuD8J | AU001K | 2024-10-31T12:14:45.244Z | 2024-11-03T14:24:50.619Z |
5428197 | 5428197 | 20241028163538_EpMN9 | AU001K | 2024-10-31T12:14:44.738Z | 2024-11-03T14:24:50.603Z |
5427984 | 5427984 | 20241028160939_Xcheo | AU001K | 2024-10-31T12:14:22.008Z | 2024-11-03T14:24:49.420Z |
5427694 | 5427694 | 20241028153424_qx0yW | AU001K | 2024-10-31T12:13:48.772Z | 2024-11-03T14:24:48.461Z |
5427662 | 5427662 | 20241028152832_JJqvQ | AU001K | 2024-10-31T12:13:45.798Z | 2024-11-03T14:24:48.293Z |
5427454 | 5427454 | 20241028150817_hfBWm | AU001K | 2024-10-31T12:13:32.817Z | 2024-11-03T14:24:47.722Z |
5427388 | 5427388 | 20241028150141_PneGc | AU001K | 2024-10-31T12:13:29.832Z | 2024-11-03T14:24:47.602Z |
5426984 | 5426984 | 20241028141816_Ue2dg | AU001K | 2024-10-31T12:12:46.447Z | 2024-11-03T14:24:45.594Z |
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);