participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,180 rows where station_code = "NZ0035" 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 |
---|---|---|---|---|---|
5449551 | 5449551 | 20241031155242_8Ywfp | NZ0035 | 2024-11-02T12:13:05.515Z | 2024-11-03T14:20:54.651Z |
5449259 | 5449259 | 20241031151251_rVJRf | NZ0035 | 2024-11-02T12:12:20.797Z | 2024-11-03T14:20:50.047Z |
5449220 | 5449220 | 20241031150652_cOc9f | NZ0035 | 2024-11-02T12:12:18.576Z | 2024-11-03T14:20:49.663Z |
5449132 | 5449132 | 20241031145848_TuSTM | NZ0035 | 2024-11-02T12:12:08.728Z | 2024-11-03T14:20:49.105Z |
5449119 | 5449119 | 20241031145638_3NYZG | NZ0035 | 2024-11-02T12:12:07.284Z | 2024-11-03T14:20:48.961Z |
5448716 | 5448716 | 20241031141004_LQvDB | NZ0035 | 2024-11-02T12:11:21.699Z | 2024-11-03T14:20:41.807Z |
5448708 | 5448708 | 20241031140953_nG73L | NZ0035 | 2024-11-02T12:11:20.970Z | 2024-11-03T14:20:41.699Z |
5448602 | 5448602 | 20241031135138_VoqcQ | NZ0035 | 2024-11-02T12:11:10.255Z | 2024-11-03T14:20:40.096Z |
5448452 | 5448452 | 20241031133320_jp9uX | NZ0035 | 2024-11-02T12:10:47.520Z | 2024-11-03T14:20:37.922Z |
5448280 | 5448280 | 20241031130618_2ombI | NZ0035 | 2024-11-02T12:10:28.225Z | 2024-11-03T14:20:35.028Z |
5437901 | 5437901 | 20241030155853_DZynV | NZ0035 | 2024-11-01T12:10:40.805Z | 2024-11-03T14:22:40.941Z |
5437778 | 5437778 | 20241030154202_ULyY3 | NZ0035 | 2024-11-01T12:10:18.731Z | 2024-11-03T14:22:40.563Z |
5437297 | 5437297 | 20241030145049_d22M2 | NZ0035 | 2024-11-01T12:09:21.580Z | 2024-11-03T14:22:39.074Z |
5437109 | 5437109 | 20241030142853_442Xl | NZ0035 | 2024-11-01T12:08:55.651Z | 2024-11-03T14:22:38.579Z |
5436879 | 5436879 | 20241030140104_qJWpJ | NZ0035 | 2024-11-01T12:08:30.886Z | 2024-11-03T14:22:37.952Z |
5436663 | 5436663 | 20241030133322_cLSC2 | NZ0035 | 2024-11-01T12:08:01.943Z | 2024-11-03T14:22:37.414Z |
5436648 | 5436648 | 20241030133058_yE1v3 | NZ0035 | 2024-11-01T12:08:01.063Z | 2024-11-03T14:22:37.394Z |
5436473 | 5436473 | 20241030131052_zOCOT | NZ0035 | 2024-11-01T12:07:44.146Z | 2024-11-03T14:22:36.781Z |
5436440 | 5436440 | 20241030130750_7wlqR | NZ0035 | 2024-11-01T12:07:37.324Z | 2024-11-03T14:22:36.658Z |
5436404 | 5436404 | 20241030130200_9zRTQ | NZ0035 | 2024-11-01T12:07:29.156Z | 2024-11-03T14:22:36.506Z |
5436255 | 5436255 | 20241030124207_u3eLk | NZ0035 | 2024-11-01T12:07:10.888Z | 2024-11-03T14:22:36.019Z |
5435953 | 5435953 | 20241030121314_zcPFi | NZ0035 | 2024-11-01T12:06:26.083Z | 2024-11-03T14:22:34.655Z |
5435812 | 5435812 | 20241030115901_YoPJJ | NZ0035 | 2024-11-01T12:05:57.794Z | 2024-11-03T14:22:34.119Z |
5435776 | 5435776 | 20241030115553_X1R0q | NZ0035 | 2024-11-01T12:05:52.678Z | 2024-11-03T14:22:34.046Z |
5435639 | 5435639 | 20241030114603_XBvrg | NZ0035 | 2024-11-01T12:05:41.892Z | 2024-11-03T14:22:33.393Z |
5435536 | 5435536 | 20241030114017_sirLS | NZ0035 | 2024-11-01T12:05:23.321Z | 2024-11-03T14:22:33.116Z |
5435059 | 5435059 | 20241030104633_C62Od | NZ0035 | 2024-11-01T12:04:05.069Z | 2024-11-03T14:22:29.171Z |
5434992 | 5434992 | 20241030103313_G5MpB | NZ0035 | 2024-11-01T12:03:54.639Z | 2024-11-03T14:22:28.368Z |
5434981 | 5434981 | 20241030103229_IxMP2 | NZ0035 | 2024-11-01T12:03:53.339Z | 2024-11-03T14:22:28.332Z |
5434787 | 5434787 | 20241030101356_KWFj8 | NZ0035 | 2024-11-01T12:03:23.473Z | 2024-11-03T14:22:26.258Z |
5434784 | 5434784 | 20241030101353_LipKZ | NZ0035 | 2024-11-01T12:03:22.646Z | 2024-11-03T14:22:26.256Z |
5426605 | 5426605 | 20241028133311_UJS3y | NZ0035 | 2024-10-31T12:12:16.360Z | 2024-11-03T14:24:44.090Z |
5425232 | 5425232 | 20241029161201_wfEpK | NZ0035 | 2024-10-31T12:07:18.540Z | 2024-11-03T14:23:41.459Z |
5424810 | 5424810 | 20241029151630_I3KNY | NZ0035 | 2024-10-31T12:06:04.573Z | 2024-11-03T14:23:39.288Z |
5424165 | 5424165 | 20241029132554_Jgm3K | NZ0035 | 2024-10-31T12:03:58.192Z | 2024-11-03T14:23:34.935Z |
5422448 | 5422448 | 20241028130441_DRFJ0 | NZ0035 | 2024-10-30T12:20:26.817Z | 2024-11-03T14:24:42.310Z |
5422438 | 5422438 | 20241028130341_NcIT1 | NZ0035 | 2024-10-30T12:20:26.671Z | 2024-11-03T14:24:42.278Z |
5422107 | 5422107 | 20241028121528_Na7aT | NZ0035 | 2024-10-30T12:20:22.146Z | 2024-11-03T14:24:40.680Z |
5421990 | 5421990 | 20241028120522_71jHM | NZ0035 | 2024-10-30T12:20:19.622Z | 2024-11-03T14:24:40.022Z |
5421976 | 5421976 | 20241028120456_8YZL2 | NZ0035 | 2024-10-30T12:20:19.417Z | 2024-11-03T14:24:39.981Z |
5416635 | 5416635 | 20241027162208_kxwUo | NZ0035 | 2024-10-30T12:11:58.449Z | 2024-11-03T14:25:42.705Z |
5415098 | 5415098 | 20241027130135_1tgDB | NZ0035 | 2024-10-30T12:08:58.402Z | 2024-11-03T14:25:39.012Z |
5414989 | 5414989 | 20241027123925_MsioY | NZ0035 | 2024-10-30T12:08:46.368Z | 2024-11-03T14:25:38.528Z |
5414946 | 5414946 | 20241027123207_4Y0xa | NZ0035 | 2024-10-30T12:08:42.248Z | 2024-11-03T14:25:38.395Z |
5414560 | 5414560 | 20241027115245_iv0PO | NZ0035 | 2024-10-30T12:07:47.237Z | 2024-11-03T14:25:36.538Z |
5414461 | 5414461 | 20241027114344_GEwQp | NZ0035 | 2024-10-30T12:07:27.325Z | 2024-11-03T14:25:36.362Z |
5414349 | 5414349 | 20241027113141_0rRa3 | NZ0035 | 2024-10-30T12:07:14.972Z | 2024-11-03T14:25:36.099Z |
5414202 | 5414202 | 20241027111418_JhFZJ | NZ0035 | 2024-10-30T12:06:48.788Z | 2024-11-03T14:25:35.844Z |
5414120 | 5414120 | 20241027110821_vymAh | NZ0035 | 2024-10-30T12:06:39.434Z | 2024-11-03T14:25:35.594Z |
5392266 | 5392266 | 20241026154211_p7P9B | NZ0035 | 2024-10-28T12:07:33.496Z | 2024-11-03T14:26:17.939Z |
5330091 | 5330091 | 20241021112451_7qyVo | NZ0035 | 2024-10-22T12:05:59.004Z | 2024-10-30T12:26:36.119Z |
5329976 | 5329976 | 20241021111254_iwIbZ | NZ0035 | 2024-10-22T12:05:43.339Z | 2024-10-30T12:26:35.931Z |
5329209 | 5329209 | 20241021095108_VdHAC | NZ0035 | 2024-10-22T12:03:32.590Z | 2024-10-30T12:26:33.987Z |
5329166 | 5329166 | 20241021094610_G67Pg | NZ0035 | 2024-10-22T12:03:24.139Z | 2024-10-30T12:26:33.933Z |
5328974 | 5328974 | 20241021092110_99xGv | NZ0035 | 2024-10-22T12:03:02.435Z | 2024-10-30T12:26:33.636Z |
5325387 | 5325387 | 20241020150101_REnpz | NZ0035 | 2024-10-21T12:05:45.227Z | 2024-10-29T12:26:31.105Z |
5325346 | 5325346 | 20241020144250_8kYOm | NZ0035 | 2024-10-21T12:05:30.934Z | 2024-10-29T12:26:30.983Z |
5325213 | 5325213 | 20241020135005_Qi4n0 | NZ0035 | 2024-10-21T12:05:12.238Z | 2024-10-29T12:26:30.762Z |
5325133 | 5325133 | 20241020132437_ZQQYY | NZ0035 | 2024-10-21T12:05:04.066Z | 2024-10-29T12:26:30.688Z |
5325120 | 5325120 | 20241020131305_Bvvbx | NZ0035 | 2024-10-21T12:05:02.381Z | 2024-10-29T12:26:30.678Z |
5324978 | 5324978 | 20241020120218_lmgmS | NZ0035 | 2024-10-21T12:04:31.270Z | 2024-10-29T12:26:30.409Z |
5324953 | 5324953 | 20241020115609_uN9OD | NZ0035 | 2024-10-21T12:04:28.952Z | 2024-10-29T12:26:30.375Z |
5324926 | 5324926 | 20241020114646_onc6Q | NZ0035 | 2024-10-21T12:04:25.177Z | 2024-10-29T12:26:30.300Z |
5324857 | 5324857 | 20241020113028_R5NzV | NZ0035 | 2024-10-21T12:04:15.198Z | 2024-10-29T12:26:30.208Z |
5324560 | 5324560 | 20241020103101_A1TcO | NZ0035 | 2024-10-21T12:03:09.837Z | 2024-10-29T12:26:29.468Z |
5324403 | 5324403 | 20241020094724_dZaPp | NZ0035 | 2024-10-21T12:02:43.198Z | 2024-10-29T12:26:28.707Z |
5324305 | 5324305 | 20241020091905_R3tV9 | NZ0035 | 2024-10-21T12:02:19.279Z | 2024-10-29T12:26:28.474Z |
5322601 | 5322601 | 20241019142727_cFFaT | NZ0035 | 2024-10-20T12:02:35.074Z | 2024-10-28T12:26:41.007Z |
5322551 | 5322551 | 20241019135015_3aHuE | NZ0035 | 2024-10-20T12:02:23.326Z | 2024-10-28T12:26:40.958Z |
5322439 | 5322439 | 20241019122318_dF3pX | NZ0035 | 2024-10-20T12:02:06.134Z | 2024-10-28T12:26:40.774Z |
5322244 | 5322244 | 20241019101939_RIGi3 | NZ0035 | 2024-10-20T12:01:28.667Z | 2024-10-28T12:26:40.208Z |
5322157 | 5322157 | 20241019093859_3LNAr | NZ0035 | 2024-10-20T12:01:09.900Z | 2024-10-28T12:26:39.939Z |
5322008 | 5322008 | 20241019081714_lzf2q | NZ0035 | 2024-10-20T12:00:40.128Z | 2024-10-28T12:26:39.519Z |
5319480 | 5319480 | 20241018143829_LJwJC | NZ0035 | 2024-10-19T12:02:22.907Z | 2024-10-27T12:28:48.321Z |
5319462 | 5319462 | 20241018135520_nYmD7 | NZ0035 | 2024-10-19T12:02:20.216Z | 2024-10-27T12:28:48.287Z |
5316031 | 5316031 | 20241015161520_HhIZe | NZ0035 | 2024-10-17T12:05:42.233Z | 2024-10-24T12:27:55.199Z |
5314410 | 5314410 | 20241016124822_1JJuC | NZ0035 | 2024-10-17T12:02:18.523Z | 2024-10-25T12:24:30.163Z |
5314142 | 5314142 | 20241016114008_Gesds | NZ0035 | 2024-10-17T12:01:45.543Z | 2024-10-25T12:24:28.875Z |
5297964 | 5297964 | 20241012150335_HiM5L | NZ0035 | 2024-10-14T12:09:32.280Z | 2024-10-21T12:23:24.060Z |
5297782 | 5297782 | 20241012143455_kNKdN | NZ0035 | 2024-10-14T12:09:08.578Z | 2024-10-21T12:23:22.700Z |
5297482 | 5297482 | 20241012133151_eTDpO | NZ0035 | 2024-10-14T12:08:29.288Z | 2024-10-21T12:23:18.630Z |
5296552 | 5296552 | 20241012103508_WMO8g | NZ0035 | 2024-10-14T12:06:22.953Z | 2024-10-21T12:23:05.727Z |
5290196 | 5290196 | 20241011164253_nmevJ | NZ0035 | 2024-10-13T12:12:01.758Z | 2024-10-20T12:24:13.412Z |
5290056 | 5290056 | 20241011162729_8Grxy | NZ0035 | 2024-10-13T12:11:53.159Z | 2024-10-20T12:24:12.594Z |
5289897 | 5289897 | 20241011161538_N4bng | NZ0035 | 2024-10-13T12:11:37.792Z | 2024-10-20T12:24:11.860Z |
5289793 | 5289793 | 20241011160428_Pgwxl | NZ0035 | 2024-10-13T12:11:25.620Z | 2024-10-20T12:24:10.499Z |
5289697 | 5289697 | 20241011155515_Jzxlo | NZ0035 | 2024-10-13T12:11:15.395Z | 2024-10-20T12:24:09.785Z |
5289601 | 5289601 | 20241011154650_Zpvt1 | NZ0035 | 2024-10-13T12:11:04.438Z | 2024-10-20T12:24:08.958Z |
5289560 | 5289560 | 20241011154226_I2XGn | NZ0035 | 2024-10-13T12:11:00.649Z | 2024-10-20T12:24:08.458Z |
5289376 | 5289376 | 20241011152504_kVZsp | NZ0035 | 2024-10-13T12:10:40.355Z | 2024-10-20T12:24:06.271Z |
5289319 | 5289319 | 20241011151924_HtIl1 | NZ0035 | 2024-10-13T12:10:35.660Z | 2024-10-20T12:24:05.949Z |
5289054 | 5289054 | 20241011145334_a1sAD | NZ0035 | 2024-10-13T12:10:21.185Z | 2024-10-20T12:24:04.202Z |
5288939 | 5288939 | 20241011144326_p4QY1 | NZ0035 | 2024-10-13T12:10:14.094Z | 2024-10-20T12:24:03.457Z |
5288902 | 5288902 | 20241011144027_5Ki0D | NZ0035 | 2024-10-13T12:10:09.206Z | 2024-10-20T12:24:03.279Z |
5288870 | 5288870 | 20241011143647_azclX | NZ0035 | 2024-10-13T12:10:06.187Z | 2024-10-20T12:24:03.057Z |
5288517 | 5288517 | 20241011140441_NkSvC | NZ0035 | 2024-10-13T12:09:23.398Z | 2024-10-20T12:23:59.666Z |
5288235 | 5288235 | 20241011132521_K5WrO | NZ0035 | 2024-10-13T12:09:04.220Z | 2024-10-20T12:23:57.933Z |
5288180 | 5288180 | 20241011131509_ecoL6 | NZ0035 | 2024-10-13T12:09:00.762Z | 2024-10-20T12:23:57.722Z |
5288059 | 5288059 | 20241011124852_KslXJ | NZ0035 | 2024-10-13T12:08:34.880Z | 2024-10-20T12:23:57.013Z |
5287984 | 5287984 | 20241011123753_sj3vd | NZ0035 | 2024-10-13T12:08:24.092Z | 2024-10-20T12:23:56.063Z |
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);