participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,308 rows where station_code = "NZ002T" 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 |
---|---|---|---|---|---|
5461064 | 5461064 | 20241101154455_34qXR | NZ002T | 2024-11-03T14:14:41.523Z | 2024-11-03T14:19:33.664Z |
5461037 | 5461037 | 20241101153838_JJdO1 | NZ002T | 2024-11-03T14:14:40.260Z | 2024-11-03T14:19:33.659Z |
5460962 | 5460962 | 20241101152603_DgX0J | NZ002T | 2024-11-03T14:14:36.453Z | 2024-11-03T14:19:33.645Z |
5460958 | 5460958 | 20241101152504_mHeAX | NZ002T | 2024-11-03T14:14:36.121Z | 2024-11-03T14:19:33.644Z |
5460804 | 5460804 | 20241101150622_JgEkK | NZ002T | 2024-11-03T14:14:28.091Z | 2024-11-03T14:19:33.617Z |
5460783 | 5460783 | 20241101150223_OoOt8 | NZ002T | 2024-11-03T14:14:25.028Z | 2024-11-03T14:19:33.613Z |
5460763 | 5460763 | 20241101150003_c3HMp | NZ002T | 2024-11-03T14:14:22.975Z | 2024-11-03T14:19:33.609Z |
5460695 | 5460695 | 20241101145249_cw2b2 | NZ002T | 2024-11-03T14:14:14.755Z | 2024-11-03T14:19:33.598Z |
5460628 | 5460628 | 20241101143950_lvSOX | NZ002T | 2024-11-03T14:14:05.303Z | 2024-11-03T14:19:33.586Z |
5460577 | 5460577 | 20241101143248_8daXS | NZ002T | 2024-11-03T14:14:00.034Z | 2024-11-03T14:19:33.578Z |
5460462 | 5460462 | 20241101141414_KinT5 | NZ002T | 2024-11-03T14:13:46.569Z | 2024-11-03T14:19:33.552Z |
5460450 | 5460450 | 20241101141210_eaFIp | NZ002T | 2024-11-03T14:13:45.441Z | 2024-11-03T14:19:33.550Z |
5460427 | 5460427 | 20241101140555_SA36v | NZ002T | 2024-11-03T14:13:43.379Z | 2024-11-03T14:19:33.543Z |
5460398 | 5460398 | 20241101140208_ewttj | NZ002T | 2024-11-03T14:13:41.657Z | 2024-11-03T14:19:33.537Z |
5460369 | 5460369 | 20241101135823_Xn13q | NZ002T | 2024-11-03T14:13:38.660Z | 2024-11-03T14:19:33.531Z |
5460359 | 5460359 | 20241101135759_K66Xk | NZ002T | 2024-11-03T14:13:38.359Z | 2024-11-03T14:19:33.530Z |
5460328 | 5460328 | 20241101134828_DYXWV | NZ002T | 2024-11-03T14:13:36.132Z | 2024-11-03T14:19:33.524Z |
5460263 | 5460263 | 20241101132454_0rOfU | NZ002T | 2024-11-03T14:13:31.588Z | 2024-11-03T14:19:33.509Z |
5460238 | 5460238 | 20241101132036_B5mW3 | NZ002T | 2024-11-03T14:13:30.485Z | 2024-11-03T14:19:33.505Z |
5460231 | 5460231 | 20241101132005_4qo9S | NZ002T | 2024-11-03T14:13:29.954Z | 2024-11-03T14:19:33.504Z |
5460226 | 5460226 | 20241101131511_mRcAl | NZ002T | 2024-11-03T14:13:29.297Z | 2024-11-03T14:19:33.502Z |
5460217 | 5460217 | 20241101131137_2Yfp2 | NZ002T | 2024-11-03T14:13:28.341Z | 2024-11-03T14:19:33.499Z |
5460204 | 5460204 | 20241101130959_o2TSl | NZ002T | 2024-11-03T14:13:27.922Z | 2024-11-03T14:19:33.497Z |
5460182 | 5460182 | 20241101130250_NjXB3 | NZ002T | 2024-11-03T14:13:26.899Z | 2024-11-03T14:19:33.493Z |
5460055 | 5460055 | 20241101123625_MUmj2 | NZ002T | 2024-11-03T14:13:15.380Z | 2024-11-03T14:19:33.468Z |
5460049 | 5460049 | 20241101123555_LTuSz | NZ002T | 2024-11-03T14:13:14.810Z | 2024-11-03T14:19:33.468Z |
5459985 | 5459985 | 20241101122743_NFtKg | NZ002T | 2024-11-03T14:13:03.068Z | 2024-11-03T14:19:33.458Z |
5459730 | 5459730 | 20241101114436_fp8kX | NZ002T | 2024-11-03T14:12:31.475Z | 2024-11-03T14:19:33.407Z |
5459458 | 5459458 | 20241101110209_ZhjzZ | NZ002T | 2024-11-03T14:11:57.813Z | 2024-11-03T14:19:33.346Z |
5458014 | 5458014 | 20241102155751_usACH | NZ002T | 2024-11-03T14:08:32.878Z | 2024-11-03T14:08:32.878Z |
5457976 | 5457976 | 20241102155121_HWSI6 | NZ002T | 2024-11-03T14:08:26.849Z | 2024-11-03T14:08:26.849Z |
5457968 | 5457968 | 20241102155009_fTjPg | NZ002T | 2024-11-03T14:08:25.238Z | 2024-11-03T14:08:25.238Z |
5457904 | 5457904 | 20241102153818_aXX27 | NZ002T | 2024-11-03T14:08:19.861Z | 2024-11-03T14:08:19.861Z |
5457875 | 5457875 | 20241102153407_OZIIB | NZ002T | 2024-11-03T14:08:17.567Z | 2024-11-03T14:08:17.567Z |
5457785 | 5457785 | 20241102152337_CzSN1 | NZ002T | 2024-11-03T14:08:10.871Z | 2024-11-03T14:08:10.871Z |
5457705 | 5457705 | 20241102151218_YbS9Z | NZ002T | 2024-11-03T14:07:52.954Z | 2024-11-03T14:07:52.954Z |
5457546 | 5457546 | 20241102144332_2yAHr | NZ002T | 2024-11-03T14:07:37.931Z | 2024-11-03T14:07:37.931Z |
5457543 | 5457543 | 20241102144212_G53Vw | NZ002T | 2024-11-03T14:07:37.435Z | 2024-11-03T14:07:37.435Z |
5457502 | 5457502 | 20241102143900_mjGEZ | NZ002T | 2024-11-03T14:07:34.585Z | 2024-11-03T14:07:34.585Z |
5457242 | 5457242 | 20241102135553_rryZT | NZ002T | 2024-11-03T14:06:58.508Z | 2024-11-03T14:06:58.508Z |
5456640 | 5456640 | 20241102115721_oJLLO | NZ002T | 2024-11-03T14:05:11.211Z | 2024-11-03T14:05:11.211Z |
5456603 | 5456603 | 20241102114944_M2zdE | NZ002T | 2024-11-03T14:05:05.218Z | 2024-11-03T14:05:05.218Z |
5456599 | 5456599 | 20241102114926_qCI1E | NZ002T | 2024-11-03T14:05:04.823Z | 2024-11-03T14:05:04.823Z |
5456487 | 5456487 | 20241102113252_ip2JL | NZ002T | 2024-11-03T14:04:49.248Z | 2024-11-03T14:04:49.248Z |
5456466 | 5456466 | 20241102112910_TSK8T | NZ002T | 2024-11-03T14:04:45.937Z | 2024-11-03T14:04:45.937Z |
5456199 | 5456199 | 20241102104019_zT42e | NZ002T | 2024-11-03T14:03:46.522Z | 2024-11-03T14:03:46.522Z |
5448678 | 5448678 | 20241031140443_3fL2a | NZ002T | 2024-11-02T12:11:18.331Z | 2024-11-03T14:20:41.231Z |
5448524 | 5448524 | 20241031134310_PviZH | NZ002T | 2024-11-02T12:10:59.801Z | 2024-11-03T14:20:39.111Z |
5448508 | 5448508 | 20241031134036_BrXEH | NZ002T | 2024-11-02T12:10:56.719Z | 2024-11-03T14:20:38.851Z |
5448465 | 5448465 | 20241031133359_l2PAw | NZ002T | 2024-11-02T12:10:48.652Z | 2024-11-03T14:20:38.295Z |
5448456 | 5448456 | 20241031133343_DPg1w | NZ002T | 2024-11-02T12:10:47.814Z | 2024-11-03T14:20:37.968Z |
5448445 | 5448445 | 20241031133239_rcr3w | NZ002T | 2024-11-02T12:10:46.923Z | 2024-11-03T14:20:37.915Z |
5448419 | 5448419 | 20241031133054_TbLJy | NZ002T | 2024-11-02T12:10:44.293Z | 2024-11-03T14:20:37.656Z |
5448389 | 5448389 | 20241031132342_DQ5TO | NZ002T | 2024-11-02T12:10:40.421Z | 2024-11-03T14:20:36.647Z |
5448305 | 5448305 | 20241031131101_e2o8N | NZ002T | 2024-11-02T12:10:31.041Z | 2024-11-03T14:20:35.173Z |
5448207 | 5448207 | 20241031125909_9HUxL | NZ002T | 2024-11-02T12:10:16.413Z | 2024-11-03T14:20:34.152Z |
5448160 | 5448160 | 20241031124951_6zNDB | NZ002T | 2024-11-02T12:10:07.945Z | 2024-11-03T14:20:33.617Z |
5447963 | 5447963 | 20241031122654_g915t | NZ002T | 2024-11-02T12:09:31.785Z | 2024-11-03T14:20:30.843Z |
5447797 | 5447797 | 20241031121129_CJ02X | NZ002T | 2024-11-02T12:09:06.844Z | 2024-11-03T14:20:28.255Z |
5447393 | 5447393 | 20241031113822_Hxdr2 | NZ002T | 2024-11-02T12:08:04.404Z | 2024-11-03T14:20:21.762Z |
5447373 | 5447373 | 20241031113618_s1f8t | NZ002T | 2024-11-02T12:08:02.452Z | 2024-11-03T14:20:21.428Z |
5447245 | 5447245 | 20241031112126_EEp2c | NZ002T | 2024-11-02T12:07:36.058Z | 2024-11-03T14:20:19.130Z |
5447193 | 5447193 | 20241031111723_FWfYy | NZ002T | 2024-11-02T12:07:28.208Z | 2024-11-03T14:20:18.082Z |
5447168 | 5447168 | 20241031111548_hNZGM | NZ002T | 2024-11-02T12:07:25.602Z | 2024-11-03T14:20:17.607Z |
5447160 | 5447160 | 20241031111409_W4bjh | NZ002T | 2024-11-02T12:07:24.335Z | 2024-11-03T14:20:16.906Z |
5447081 | 5447081 | 20241031110604_G83FM | NZ002T | 2024-11-02T12:07:11.846Z | 2024-11-03T14:20:15.495Z |
5446854 | 5446854 | 20241031103911_bjnuF | NZ002T | 2024-11-02T12:06:32.011Z | 2024-11-03T14:20:10.182Z |
5428113 | 5428113 | 20241028162301_0t3r1 | NZ002T | 2024-10-31T12:14:34.386Z | 2024-11-03T14:24:49.757Z |
5427958 | 5427958 | 20241028160556_MuvUg | NZ002T | 2024-10-31T12:14:18.397Z | 2024-11-03T14:24:49.381Z |
5427783 | 5427783 | 20241028154458_48U0c | NZ002T | 2024-10-31T12:13:58.264Z | 2024-11-03T14:24:48.697Z |
5427772 | 5427772 | 20241028154316_yJj3Q | NZ002T | 2024-10-31T12:13:56.781Z | 2024-11-03T14:24:48.575Z |
5427703 | 5427703 | 20241028153500_ypTNQ | NZ002T | 2024-10-31T12:13:49.446Z | 2024-11-03T14:24:48.464Z |
5427513 | 5427513 | 20241028151258_2Qy3J | NZ002T | 2024-10-31T12:13:35.363Z | 2024-11-03T14:24:47.978Z |
5427445 | 5427445 | 20241028150745_EBhWA | NZ002T | 2024-10-31T12:13:32.533Z | 2024-11-03T14:24:47.713Z |
5427408 | 5427408 | 20241028150319_3RQAc | NZ002T | 2024-10-31T12:13:30.747Z | 2024-11-03T14:24:47.636Z |
5427361 | 5427361 | 20241028145958_getnI | NZ002T | 2024-10-31T12:13:28.537Z | 2024-11-03T14:24:47.579Z |
5427313 | 5427313 | 20241028145649_ElhEl | NZ002T | 2024-10-31T12:13:25.776Z | 2024-11-03T14:24:46.572Z |
5427301 | 5427301 | 20241028145535_CvRNc | NZ002T | 2024-10-31T12:13:25.100Z | 2024-11-03T14:24:46.549Z |
5427292 | 5427292 | 20241028145429_yqXI8 | NZ002T | 2024-10-31T12:13:24.286Z | 2024-11-03T14:24:46.519Z |
5427248 | 5427248 | 20241028145042_YPH26 | NZ002T | 2024-10-31T12:13:22.314Z | 2024-11-03T14:24:46.396Z |
5425184 | 5425184 | 20241029160530_Ui3fO | NZ002T | 2024-10-31T12:07:06.056Z | 2024-11-03T14:23:41.133Z |
5424224 | 5424224 | 20241029134105_mEljU | NZ002T | 2024-10-31T12:04:19.340Z | 2024-11-03T14:23:35.536Z |
5382352 | 5382352 | 20241024162000_tI7iL | NZ002T | 2024-10-27T12:13:31.400Z | 2024-11-02T12:28:23.614Z |
5382074 | 5382074 | 20241024160151_O36Ea | NZ002T | 2024-10-27T12:13:11.902Z | 2024-11-02T12:28:23.430Z |
5382054 | 5382054 | 20241024155954_gTavT | NZ002T | 2024-10-27T12:13:10.269Z | 2024-11-02T12:28:23.401Z |
5381995 | 5381995 | 20241024155542_4PBkz | NZ002T | 2024-10-27T12:13:06.305Z | 2024-11-02T12:28:23.352Z |
5381974 | 5381974 | 20241024155403_ESQsa | NZ002T | 2024-10-27T12:13:05.250Z | 2024-11-02T12:28:23.339Z |
5381944 | 5381944 | 20241024155034_KJGOR | NZ002T | 2024-10-27T12:13:03.149Z | 2024-11-02T12:28:23.306Z |
5381934 | 5381934 | 20241024154944_XObIS | NZ002T | 2024-10-27T12:13:02.598Z | 2024-11-02T12:28:23.279Z |
5381854 | 5381854 | 20241024154322_1k4Op | NZ002T | 2024-10-27T12:12:52.830Z | 2024-11-02T12:28:23.221Z |
5371762 | 5371762 | 20241024151854_Rx532 | NZ002T | 2024-10-26T12:12:34.986Z | 2024-11-02T12:28:22.765Z |
5371667 | 5371667 | 20241024151233_GImMC | NZ002T | 2024-10-26T12:12:20.417Z | 2024-11-02T12:28:22.565Z |
5371663 | 5371663 | 20241024151210_7Pitq | NZ002T | 2024-10-26T12:12:20.257Z | 2024-11-02T12:28:22.561Z |
5371646 | 5371646 | 20241024151041_FqweZ | NZ002T | 2024-10-26T12:12:18.798Z | 2024-11-02T12:28:22.495Z |
5371636 | 5371636 | 20241024151004_Ze4YG | NZ002T | 2024-10-26T12:12:18.321Z | 2024-11-02T12:28:22.444Z |
5371618 | 5371618 | 20241024150746_3zQlV | NZ002T | 2024-10-26T12:12:15.273Z | 2024-11-02T12:28:22.431Z |
5371564 | 5371564 | 20241024150358_b3C3v | NZ002T | 2024-10-26T12:12:10.902Z | 2024-11-02T12:28:22.386Z |
5371477 | 5371477 | 20241024145545_GwHW9 | NZ002T | 2024-10-26T12:12:02.516Z | 2024-11-02T12:28:22.285Z |
5371448 | 5371448 | 20241024145410_4C7jy | NZ002T | 2024-10-26T12:12:00.284Z | 2024-11-02T12:28:22.248Z |
5371434 | 5371434 | 20241024145324_zqHnt | NZ002T | 2024-10-26T12:11:58.433Z | 2024-11-02T12:28:22.234Z |
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);