participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,038 rows where station_code = "NZ0029" 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 |
---|---|---|---|---|---|
5461087 | 5461087 | 20241101155023_EnZPE | NZ0029 | 2024-11-03T14:14:42.559Z | 2024-11-03T14:19:33.668Z |
5461040 | 5461040 | 20241101153854_MgZdY | NZ0029 | 2024-11-03T14:14:40.419Z | 2024-11-03T14:19:33.660Z |
5460956 | 5460956 | 20241101152504_mHeAX | NZ0029 | 2024-11-03T14:14:36.121Z | 2024-11-03T14:19:33.644Z |
5460802 | 5460802 | 20241101150622_JgEkK | NZ0029 | 2024-11-03T14:14:28.091Z | 2024-11-03T14:19:33.617Z |
5460769 | 5460769 | 20241101150141_CGWyG | NZ0029 | 2024-11-03T14:14:23.501Z | 2024-11-03T14:19:33.610Z |
5460760 | 5460760 | 20241101145957_6fIOR | NZ0029 | 2024-11-03T14:14:21.793Z | 2024-11-03T14:19:33.608Z |
5460694 | 5460694 | 20241101145249_cw2b2 | NZ0029 | 2024-11-03T14:14:14.755Z | 2024-11-03T14:19:33.598Z |
5460671 | 5460671 | 20241101144619_Os6Kq | NZ0029 | 2024-11-03T14:14:11.762Z | 2024-11-03T14:19:33.594Z |
5460627 | 5460627 | 20241101143950_lvSOX | NZ0029 | 2024-11-03T14:14:05.303Z | 2024-11-03T14:19:33.586Z |
5460326 | 5460326 | 20241101134828_DYXWV | NZ0029 | 2024-11-03T14:13:36.131Z | 2024-11-03T14:19:33.524Z |
5460299 | 5460299 | 20241101133854_ZUzw2 | NZ0029 | 2024-11-03T14:13:34.208Z | 2024-11-03T14:19:33.517Z |
5460207 | 5460207 | 20241101131037_TNOrb | NZ0029 | 2024-11-03T14:13:28.062Z | 2024-11-03T14:19:33.498Z |
5460181 | 5460181 | 20241101130250_NjXB3 | NZ0029 | 2024-11-03T14:13:26.899Z | 2024-11-03T14:19:33.493Z |
5460131 | 5460131 | 20241101125210_oPNAh | NZ0029 | 2024-11-03T14:13:23.351Z | 2024-11-03T14:19:33.483Z |
5460089 | 5460089 | 20241101124057_t9xd5 | NZ0029 | 2024-11-03T14:13:20.438Z | 2024-11-03T14:19:33.474Z |
5460054 | 5460054 | 20241101123625_MUmj2 | NZ0029 | 2024-11-03T14:13:15.379Z | 2024-11-03T14:19:33.468Z |
5459984 | 5459984 | 20241101122743_NFtKg | NZ0029 | 2024-11-03T14:13:03.068Z | 2024-11-03T14:19:33.458Z |
5459875 | 5459875 | 20241101121004_I0no3 | NZ0029 | 2024-11-03T14:12:43.645Z | 2024-11-03T14:19:33.434Z |
5459588 | 5459588 | 20241101112046_4Ekuc | NZ0029 | 2024-11-03T14:12:20.470Z | 2024-11-03T14:19:33.376Z |
5459287 | 5459287 | 20241101103838_CoL0q | NZ0029 | 2024-11-03T14:11:37.903Z | 2024-11-03T14:19:33.313Z |
5458731 | 5458731 | 20241101090646_Zkrwf | NZ0029 | 2024-11-03T14:10:31.804Z | 2024-11-03T14:19:33.184Z |
5458054 | 5458054 | 20241102160428_lXasS | NZ0029 | 2024-11-03T14:08:37.717Z | 2024-11-03T14:08:37.717Z |
5457972 | 5457972 | 20241102155110_KaCKW | NZ0029 | 2024-11-03T14:08:26.124Z | 2024-11-03T14:08:26.124Z |
5457628 | 5457628 | 20241102145519_FRWRN | NZ0029 | 2024-11-03T14:07:44.969Z | 2024-11-03T14:07:44.969Z |
5457588 | 5457588 | 20241102145037_sm6Rm | NZ0029 | 2024-11-03T14:07:42.068Z | 2024-11-03T14:07:42.068Z |
5457467 | 5457467 | 20241102143351_TrhXp | NZ0029 | 2024-11-03T14:07:23.224Z | 2024-11-03T14:07:23.224Z |
5457369 | 5457369 | 20241102142005_i1Taw | NZ0029 | 2024-11-03T14:07:11.013Z | 2024-11-03T14:07:11.013Z |
5457359 | 5457359 | 20241102141922_31t3d | NZ0029 | 2024-11-03T14:07:10.376Z | 2024-11-03T14:07:10.376Z |
5457264 | 5457264 | 20241102140014_2bBwC | NZ0029 | 2024-11-03T14:07:00.549Z | 2024-11-03T14:07:00.549Z |
5457018 | 5457018 | 20241102131343_3UFp8 | NZ0029 | 2024-11-03T14:06:22.879Z | 2024-11-03T14:06:22.879Z |
5456985 | 5456985 | 20241102130557_tz55D | NZ0029 | 2024-11-03T14:06:18.894Z | 2024-11-03T14:06:18.894Z |
5456923 | 5456923 | 20241102125315_hw8DT | NZ0029 | 2024-11-03T14:06:02.053Z | 2024-11-03T14:06:02.053Z |
5448523 | 5448523 | 20241031134310_PviZH | NZ0029 | 2024-11-02T12:10:59.801Z | 2024-11-03T14:20:39.110Z |
5448507 | 5448507 | 20241031134036_BrXEH | NZ0029 | 2024-11-02T12:10:56.719Z | 2024-11-03T14:20:38.851Z |
5448449 | 5448449 | 20241031133248_rj4HE | NZ0029 | 2024-11-02T12:10:47.270Z | 2024-11-03T14:20:37.921Z |
5448444 | 5448444 | 20241031133239_rcr3w | NZ0029 | 2024-11-02T12:10:46.922Z | 2024-11-03T14:20:37.915Z |
5448418 | 5448418 | 20241031133054_TbLJy | NZ0029 | 2024-11-02T12:10:44.293Z | 2024-11-03T14:20:37.656Z |
5448408 | 5448408 | 20241031132812_av4zn | NZ0029 | 2024-11-02T12:10:42.668Z | 2024-11-03T14:20:36.816Z |
5448380 | 5448380 | 20241031132238_JXnqx | NZ0029 | 2024-11-02T12:10:39.798Z | 2024-11-03T14:20:36.608Z |
5448334 | 5448334 | 20241031131637_sHvN3 | NZ0029 | 2024-11-02T12:10:34.025Z | 2024-11-03T14:20:35.715Z |
5447796 | 5447796 | 20241031121129_CJ02X | NZ0029 | 2024-11-02T12:09:06.844Z | 2024-11-03T14:20:28.255Z |
5447311 | 5447311 | 20241031112946_iO15q | NZ0029 | 2024-11-02T12:07:44.882Z | 2024-11-03T14:20:20.666Z |
5446638 | 5446638 | 20241031101659_xgyQM | NZ0029 | 2024-11-02T12:05:56.594Z | 2024-11-03T14:20:05.298Z |
5445948 | 5445948 | 20241031090638_bNCgl | NZ0029 | 2024-11-02T12:03:41.128Z | 2024-11-03T14:19:52.739Z |
5445877 | 5445877 | 20241031085702_z8bm1 | NZ0029 | 2024-11-02T12:03:26.521Z | 2024-11-03T14:19:51.338Z |
5445784 | 5445784 | 20241031084921_pKK4E | NZ0029 | 2024-11-02T12:03:13.036Z | 2024-11-03T14:19:49.955Z |
5441081 | 5441081 | 20241029153302_5jqGK | NZ0029 | 2024-11-01T12:16:59.062Z | 2024-11-03T14:23:39.791Z |
5425183 | 5425183 | 20241029160530_Ui3fO | NZ0029 | 2024-10-31T12:07:06.056Z | 2024-11-03T14:23:41.133Z |
5425142 | 5425142 | 20241029155937_4OeBf | NZ0029 | 2024-10-31T12:06:56.169Z | 2024-11-03T14:23:40.956Z |
5424955 | 5424955 | 20241029153530_OnsXN | NZ0029 | 2024-10-31T12:06:33.659Z | 2024-11-03T14:23:39.971Z |
5424872 | 5424872 | 20241029152456_DJyLU | NZ0029 | 2024-10-31T12:06:13.057Z | 2024-11-03T14:23:39.551Z |
5424828 | 5424828 | 20241029151833_ZDLRz | NZ0029 | 2024-10-31T12:06:05.900Z | 2024-11-03T14:23:39.315Z |
5424697 | 5424697 | 20241029150053_vuBz4 | NZ0029 | 2024-10-31T12:05:51.460Z | 2024-11-03T14:23:38.554Z |
5424684 | 5424684 | 20241029150026_kJwwh | NZ0029 | 2024-10-31T12:05:50.877Z | 2024-11-03T14:23:38.551Z |
5424407 | 5424407 | 20241029141608_r130L | NZ0029 | 2024-10-31T12:04:58.526Z | 2024-11-03T14:23:36.537Z |
5424332 | 5424332 | 20241029140344_tnbrF | NZ0029 | 2024-10-31T12:04:37.425Z | 2024-11-03T14:23:35.939Z |
5424321 | 5424321 | 20241029140232_5JE2h | NZ0029 | 2024-10-31T12:04:36.663Z | 2024-11-03T14:23:35.934Z |
5424302 | 5424302 | 20241029135751_MW0WM | NZ0029 | 2024-10-31T12:04:32.637Z | 2024-11-03T14:23:35.805Z |
5424248 | 5424248 | 20241029134632_a6bEP | NZ0029 | 2024-10-31T12:04:23.793Z | 2024-11-03T14:23:35.672Z |
5424234 | 5424234 | 20241029134218_Q3Yer | NZ0029 | 2024-10-31T12:04:20.936Z | 2024-11-03T14:23:35.548Z |
5424207 | 5424207 | 20241029133829_jW3Zz | NZ0029 | 2024-10-31T12:04:17.254Z | 2024-11-03T14:23:35.428Z |
5424109 | 5424109 | 20241029130839_rbDio | NZ0029 | 2024-10-31T12:03:48.320Z | 2024-11-03T14:23:34.382Z |
5424079 | 5424079 | 20241029125932_eY1mQ | NZ0029 | 2024-10-31T12:03:44.284Z | 2024-11-03T14:23:34.198Z |
5424001 | 5424001 | 20241029123513_3CIGp | NZ0029 | 2024-10-31T12:03:30.311Z | 2024-11-03T14:23:33.856Z |
5423964 | 5423964 | 20241029123008_daCRy | NZ0029 | 2024-10-31T12:03:19.832Z | 2024-11-03T14:23:33.415Z |
5423800 | 5423800 | 20241029120238_pxoDe | NZ0029 | 2024-10-31T12:02:50.291Z | 2024-11-03T14:23:31.710Z |
5423784 | 5423784 | 20241029115919_TWJcZ | NZ0029 | 2024-10-31T12:02:47.209Z | 2024-11-03T14:23:31.549Z |
5423432 | 5423432 | 20241029102238_2AFpA | NZ0029 | 2024-10-31T12:01:28.232Z | 2024-11-03T14:23:27.599Z |
5423408 | 5423408 | 20241029101648_qK08k | NZ0029 | 2024-10-31T12:01:23.694Z | 2024-11-03T14:23:26.827Z |
5423306 | 5423306 | 20241029092617_Kerp1 | NZ0029 | 2024-10-31T12:00:56.634Z | 2024-11-03T14:23:26.246Z |
5421539 | 5421539 | 20241028105735_xgsMn | NZ0029 | 2024-10-30T12:20:05.278Z | 2024-11-03T14:24:38.198Z |
5413587 | 5413587 | 20241028102542_2Yagx | NZ0029 | 2024-10-30T12:03:33.641Z | 2024-11-03T14:24:36.700Z |
5382381 | 5382381 | 20241024162329_ILQvc | NZ0029 | 2024-10-27T12:13:37.930Z | 2024-11-02T12:28:23.628Z |
5382053 | 5382053 | 20241024155954_gTavT | NZ0029 | 2024-10-27T12:13:10.269Z | 2024-11-02T12:28:23.401Z |
5382048 | 5382048 | 20241024155945_yD7dg | NZ0029 | 2024-10-27T12:13:09.916Z | 2024-11-02T12:28:23.397Z |
5381933 | 5381933 | 20241024154944_XObIS | NZ0029 | 2024-10-27T12:13:02.598Z | 2024-11-02T12:28:23.279Z |
5381929 | 5381929 | 20241024154925_G3ueN | NZ0029 | 2024-10-27T12:13:02.292Z | 2024-11-02T12:28:23.278Z |
5371727 | 5371727 | 20241024151534_2U3lR | NZ0029 | 2024-10-26T12:12:29.123Z | 2024-11-02T12:28:22.722Z |
5371562 | 5371562 | 20241024150358_b3C3v | NZ0029 | 2024-10-26T12:12:10.902Z | 2024-11-02T12:28:22.386Z |
5371508 | 5371508 | 20241024145729_69dNN | NZ0029 | 2024-10-26T12:12:04.434Z | 2024-11-02T12:28:22.329Z |
5371475 | 5371475 | 20241024145545_GwHW9 | NZ0029 | 2024-10-26T12:12:02.515Z | 2024-11-02T12:28:22.285Z |
5371432 | 5371432 | 20241024145324_zqHnt | NZ0029 | 2024-10-26T12:11:58.433Z | 2024-11-02T12:28:22.234Z |
5371403 | 5371403 | 20241024145050_FHwBM | NZ0029 | 2024-10-26T12:11:55.645Z | 2024-11-02T12:28:22.164Z |
5371254 | 5371254 | 20241024143623_kmxSx | NZ0029 | 2024-10-26T12:11:29.354Z | 2024-11-02T12:28:21.901Z |
5371202 | 5371202 | 20241024143047_3JJE6 | NZ0029 | 2024-10-26T12:11:20.921Z | 2024-11-02T12:28:21.861Z |
5371160 | 5371160 | 20241024142753_kWvk8 | NZ0029 | 2024-10-26T12:11:17.139Z | 2024-11-02T12:28:21.838Z |
5371129 | 5371129 | 20241024142526_km6zp | NZ0029 | 2024-10-26T12:11:14.232Z | 2024-11-02T12:28:21.829Z |
5370794 | 5370794 | 20241024135442_wBWRF | NZ0029 | 2024-10-26T12:10:28.518Z | 2024-11-02T12:28:21.384Z |
5370657 | 5370657 | 20241024133447_HfxDc | NZ0029 | 2024-10-26T12:10:07.511Z | 2024-11-02T12:28:21.031Z |
5370548 | 5370548 | 20241024132340_1WztD | NZ0029 | 2024-10-26T12:09:53.218Z | 2024-11-02T12:28:20.911Z |
5370493 | 5370493 | 20241024131355_dRna4 | NZ0029 | 2024-10-26T12:09:47.755Z | 2024-11-02T12:28:20.804Z |
5370440 | 5370440 | 20241024130625_uKz73 | NZ0029 | 2024-10-26T12:09:40.153Z | 2024-11-02T12:28:20.719Z |
5370340 | 5370340 | 20241024125643_EiS72 | NZ0029 | 2024-10-26T12:09:19.755Z | 2024-11-02T12:28:20.630Z |
5332083 | 5332083 | 20241021162148_zvGrs | NZ0029 | 2024-10-22T12:10:06.820Z | 2024-10-30T12:26:40.314Z |
5331050 | 5331050 | 20241021133516_xIX4f | NZ0029 | 2024-10-22T12:08:21.244Z | 2024-10-30T12:26:38.870Z |
5331045 | 5331045 | 20241021133244_prAld | NZ0029 | 2024-10-22T12:08:20.456Z | 2024-10-30T12:26:38.812Z |
5322568 | 5322568 | 20241019140449_RkVkQ | NZ0029 | 2024-10-20T12:02:26.092Z | 2024-10-28T12:26:40.991Z |
5322424 | 5322424 | 20241019121548_2kghh | NZ0029 | 2024-10-20T12:02:00.199Z | 2024-10-28T12:26:40.662Z |
5322352 | 5322352 | 20241019113642_bgsQw | NZ0029 | 2024-10-20T12:01:46.869Z | 2024-10-28T12:26:40.426Z |
5322314 | 5322314 | 20241019110332_EfrSb | NZ0029 | 2024-10-20T12:01:39.919Z | 2024-10-28T12:26:40.346Z |
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);