participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,058 rows where station_code = "NZ003Z" 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 |
---|---|---|---|---|---|
5597410 | 5597410 | 20241124152219_0zy3z | NZ003Z | 2024-11-25T14:11:27.267Z | 2024-11-25T14:11:27.267Z |
5597368 | 5597368 | 20241124151915_Bz7RZ | NZ003Z | 2024-11-25T14:11:24.853Z | 2024-11-25T14:11:24.853Z |
5597288 | 5597288 | 20241124151533_k2mTB | NZ003Z | 2024-11-25T14:11:20.890Z | 2024-11-25T14:11:20.890Z |
5597148 | 5597148 | 20241124150705_223ze | NZ003Z | 2024-11-25T14:11:11.593Z | 2024-11-25T14:11:11.593Z |
5597075 | 5597075 | 20241124145934_NnTO5 | NZ003Z | 2024-11-25T14:11:03.256Z | 2024-11-25T14:11:03.256Z |
5597012 | 5597012 | 20241124145419_eIdlz | NZ003Z | 2024-11-25T14:10:57.663Z | 2024-11-25T14:10:57.663Z |
5597004 | 5597004 | 20241124145313_N4E3T | NZ003Z | 2024-11-25T14:10:56.770Z | 2024-11-25T14:10:56.770Z |
5596907 | 5596907 | 20241124144427_krI8L | NZ003Z | 2024-11-25T14:10:46.559Z | 2024-11-25T14:10:46.559Z |
5596847 | 5596847 | 20241124143426_uX2cF | NZ003Z | 2024-11-25T14:10:39.778Z | 2024-11-25T14:10:39.778Z |
5596740 | 5596740 | 20241124141920_uZCnn | NZ003Z | 2024-11-25T14:10:31.201Z | 2024-11-25T14:10:31.201Z |
5596685 | 5596685 | 20241124141441_gkaYQ | NZ003Z | 2024-11-25T14:10:27.125Z | 2024-11-25T14:10:27.125Z |
5596408 | 5596408 | 20241124134758_w55ad | NZ003Z | 2024-11-25T14:09:56.187Z | 2024-11-25T14:09:56.187Z |
5596384 | 5596384 | 20241124134416_ZhKms | NZ003Z | 2024-11-25T14:09:54.976Z | 2024-11-25T14:09:54.976Z |
5596360 | 5596360 | 20241124134201_iOru9 | NZ003Z | 2024-11-25T14:09:51.671Z | 2024-11-25T14:09:51.671Z |
5596326 | 5596326 | 20241124133654_7YsNL | NZ003Z | 2024-11-25T14:09:49.132Z | 2024-11-25T14:09:49.132Z |
5596235 | 5596235 | 20241124132901_WlATP | NZ003Z | 2024-11-25T14:09:41.442Z | 2024-11-25T14:09:41.442Z |
5596160 | 5596160 | 20241124132205_DO0Ra | NZ003Z | 2024-11-25T14:09:35.285Z | 2024-11-25T14:09:35.285Z |
5596148 | 5596148 | 20241124132020_lvV2V | NZ003Z | 2024-11-25T14:09:34.452Z | 2024-11-25T14:09:34.452Z |
5595979 | 5595979 | 20241124130437_gS43o | NZ003Z | 2024-11-25T14:09:14.914Z | 2024-11-25T14:09:14.914Z |
5595925 | 5595925 | 20241124125848_tjeM2 | NZ003Z | 2024-11-25T14:09:09.766Z | 2024-11-25T14:09:09.766Z |
5595646 | 5595646 | 20241124123645_VAS1z | NZ003Z | 2024-11-25T14:08:39.310Z | 2024-11-25T14:08:39.310Z |
5595640 | 5595640 | 20241124123626_n140L | NZ003Z | 2024-11-25T14:08:39.047Z | 2024-11-25T14:08:39.047Z |
5595452 | 5595452 | 20241124122036_ITEoR | NZ003Z | 2024-11-25T14:08:15.478Z | 2024-11-25T14:08:15.478Z |
5595415 | 5595415 | 20241124121627_vx53w | NZ003Z | 2024-11-25T14:08:11.147Z | 2024-11-25T14:08:11.147Z |
5595368 | 5595368 | 20241124121111_LNslX | NZ003Z | 2024-11-25T14:08:03.807Z | 2024-11-25T14:08:03.807Z |
5595337 | 5595337 | 20241124120803_8Z4cx | NZ003Z | 2024-11-25T14:07:59.497Z | 2024-11-25T14:07:59.497Z |
5595332 | 5595332 | 20241124120800_kYhfn | NZ003Z | 2024-11-25T14:07:59.078Z | 2024-11-25T14:07:59.078Z |
5595151 | 5595151 | 20241124114805_UUF4w | NZ003Z | 2024-11-25T14:07:39.216Z | 2024-11-25T14:07:39.216Z |
5595084 | 5595084 | 20241124114052_b1rDB | NZ003Z | 2024-11-25T14:07:21.636Z | 2024-11-25T14:07:21.636Z |
5595026 | 5595026 | 20241124113351_HP2kp | NZ003Z | 2024-11-25T14:07:08.720Z | 2024-11-25T14:07:08.720Z |
5594781 | 5594781 | 20241124110525_8xZjo | NZ003Z | 2024-11-25T14:06:31.324Z | 2024-11-25T14:06:31.324Z |
5594763 | 5594763 | 20241124110445_ZnyC4 | NZ003Z | 2024-11-25T14:06:29.692Z | 2024-11-25T14:06:29.692Z |
5594737 | 5594737 | 20241124110054_N2L5U | NZ003Z | 2024-11-25T14:06:25.487Z | 2024-11-25T14:06:25.487Z |
5594694 | 5594694 | 20241124105847_xZ14V | NZ003Z | 2024-11-25T14:06:21.388Z | 2024-11-25T14:06:21.388Z |
5594652 | 5594652 | 20241124105607_6eMw9 | NZ003Z | 2024-11-25T14:06:18.059Z | 2024-11-25T14:06:18.059Z |
5594308 | 5594308 | 20241124101342_7ExEa | NZ003Z | 2024-11-25T14:05:25.171Z | 2024-11-25T14:05:25.171Z |
5594275 | 5594275 | 20241124100920_firzI | NZ003Z | 2024-11-25T14:05:22.094Z | 2024-11-25T14:05:22.094Z |
5594271 | 5594271 | 20241124100916_wm6nm | NZ003Z | 2024-11-25T14:05:21.731Z | 2024-11-25T14:05:21.731Z |
5594204 | 5594204 | 20241124095454_Vjo8L | NZ003Z | 2024-11-25T14:05:06.424Z | 2024-11-25T14:05:06.424Z |
5584001 | 5584001 | 20241117123909_bLvwy | NZ003Z | 2024-11-23T14:25:19.245Z | 2024-11-25T14:22:24.196Z |
5583965 | 5583965 | 20241117090645_oH5VD | NZ003Z | 2024-11-23T14:25:15.662Z | 2024-11-25T14:22:22.285Z |
5583412 | 5583412 | 20241119145145_SbWRG | NZ003Z | 2024-11-23T14:24:15.859Z | 2024-11-25T14:21:44.110Z |
5583036 | 5583036 | 20241120132234_eJjUJ | NZ003Z | 2024-11-23T14:22:40.276Z | 2024-11-25T14:21:07.367Z |
5573271 | 5573271 | 20241119095604_hNubf | NZ003Z | 2024-11-22T14:19:47.689Z | 2024-11-25T14:21:40.984Z |
5560805 | 5560805 | 20241120142816_gN1Oy | NZ003Z | 2024-11-21T14:09:46.873Z | 2024-11-25T14:21:07.807Z |
5560766 | 5560766 | 20241120141711_Xv6mP | NZ003Z | 2024-11-21T14:09:43.413Z | 2024-11-25T14:21:07.732Z |
5560738 | 5560738 | 20241120141106_iKvm0 | NZ003Z | 2024-11-21T14:09:40.997Z | 2024-11-25T14:21:07.679Z |
5560721 | 5560721 | 20241120140324_0SWBl | NZ003Z | 2024-11-21T14:09:35.906Z | 2024-11-25T14:21:07.640Z |
5560717 | 5560717 | 20241120140233_jHreh | NZ003Z | 2024-11-21T14:09:34.938Z | 2024-11-25T14:21:07.638Z |
5560528 | 5560528 | 20241120130730_kASgI | NZ003Z | 2024-11-21T14:09:02.314Z | 2024-11-25T14:21:07.122Z |
5560481 | 5560481 | 20241120125525_FsPec | NZ003Z | 2024-11-21T14:08:56.298Z | 2024-11-25T14:21:06.857Z |
5560431 | 5560431 | 20241120125119_FOVg1 | NZ003Z | 2024-11-21T14:08:50.538Z | 2024-11-25T14:21:06.564Z |
5560404 | 5560404 | 20241120124741_yzZ3D | NZ003Z | 2024-11-21T14:08:47.799Z | 2024-11-25T14:21:06.464Z |
5560050 | 5560050 | 20241120115143_whclI | NZ003Z | 2024-11-21T14:07:56.175Z | 2024-11-25T14:21:05.040Z |
5560035 | 5560035 | 20241120114853_LzrF4 | NZ003Z | 2024-11-21T14:07:54.172Z | 2024-11-25T14:21:04.999Z |
5559890 | 5559890 | 20241120113029_MKXDy | NZ003Z | 2024-11-21T14:07:28.899Z | 2024-11-25T14:21:04.616Z |
5559845 | 5559845 | 20241120112341_3eVE9 | NZ003Z | 2024-11-21T14:07:19.148Z | 2024-11-25T14:21:04.484Z |
5559772 | 5559772 | 20241120111628_AUkLc | NZ003Z | 2024-11-21T14:07:09.796Z | 2024-11-25T14:21:04.295Z |
5559572 | 5559572 | 20241120104423_Iy2rA | NZ003Z | 2024-11-21T14:06:38.022Z | 2024-11-25T14:21:03.480Z |
5559530 | 5559530 | 20241120103910_5LVu4 | NZ003Z | 2024-11-21T14:06:32.334Z | 2024-11-25T14:21:03.347Z |
5559320 | 5559320 | 20241120100306_90CW1 | NZ003Z | 2024-11-21T14:05:57.868Z | 2024-11-25T14:21:02.779Z |
5559166 | 5559166 | 20241120093306_fZEQN | NZ003Z | 2024-11-21T14:05:31.395Z | 2024-11-25T14:21:02.218Z |
5555762 | 5555762 | 20241119154402_t7kjI | NZ003Z | 2024-11-20T14:06:33.459Z | 2024-11-25T14:21:44.181Z |
5555716 | 5555716 | 20241119145708_KiK3P | NZ003Z | 2024-11-20T14:06:27.968Z | 2024-11-25T14:21:44.135Z |
5555705 | 5555705 | 20241119145145_quLU4 | NZ003Z | 2024-11-20T14:06:27.037Z | 2024-11-22T14:20:12.591Z |
5555688 | 5555688 | 20241119144459_9vJxf | NZ003Z | 2024-11-20T14:06:24.881Z | 2024-11-25T14:21:43.998Z |
5555668 | 5555668 | 20241119143229_Tk2T5 | NZ003Z | 2024-11-20T14:06:22.563Z | 2024-11-25T14:21:43.984Z |
5555612 | 5555612 | 20241119140711_3k8TV | NZ003Z | 2024-11-20T14:06:07.320Z | 2024-11-25T14:21:43.819Z |
5555589 | 5555589 | 20241119135930_joalQ | NZ003Z | 2024-11-20T14:06:03.586Z | 2024-11-25T14:21:43.787Z |
5555583 | 5555583 | 20241119135705_f4TGT | NZ003Z | 2024-11-20T14:06:02.834Z | 2024-11-25T14:21:43.780Z |
5555578 | 5555578 | 20241119135540_avNKI | NZ003Z | 2024-11-20T14:06:02.109Z | 2024-11-25T14:21:43.767Z |
5555549 | 5555549 | 20241119134921_ncX9M | NZ003Z | 2024-11-20T14:05:57.462Z | 2024-11-25T14:21:43.727Z |
5555527 | 5555527 | 20241119134144_C5Uvk | NZ003Z | 2024-11-20T14:05:55.361Z | 2024-11-25T14:21:43.687Z |
5555522 | 5555522 | 20241119134130_qRVOg | NZ003Z | 2024-11-20T14:05:55.089Z | 2024-11-25T14:21:43.682Z |
5555493 | 5555493 | 20241119133302_B6t3m | NZ003Z | 2024-11-20T14:05:51.573Z | 2024-11-25T14:21:43.603Z |
5555476 | 5555476 | 20241119132536_vXEXX | NZ003Z | 2024-11-20T14:05:43.797Z | 2024-11-25T14:21:43.594Z |
5555459 | 5555459 | 20241119132151_guhPz | NZ003Z | 2024-11-20T14:05:41.375Z | 2024-11-25T14:21:43.572Z |
5555428 | 5555428 | 20241119131057_Zr2Gp | NZ003Z | 2024-11-20T14:05:36.361Z | 2024-11-25T14:21:43.532Z |
5555405 | 5555405 | 20241119130414_7ck6j | NZ003Z | 2024-11-20T14:05:30.820Z | 2024-11-25T14:21:43.471Z |
5555400 | 5555400 | 20241119130339_3J2nY | NZ003Z | 2024-11-20T14:05:29.928Z | 2024-11-25T14:21:43.470Z |
5555383 | 5555383 | 20241119130124_NBcrF | NZ003Z | 2024-11-20T14:05:24.127Z | 2024-11-25T14:21:43.442Z |
5555361 | 5555361 | 20241119125427_UZnZM | NZ003Z | 2024-11-20T14:05:16.740Z | 2024-11-25T14:21:43.396Z |
5555238 | 5555238 | 20241119122113_u0O83 | NZ003Z | 2024-11-20T14:04:59.414Z | 2024-11-25T14:21:43.095Z |
5555139 | 5555139 | 20241119115523_hayH3 | NZ003Z | 2024-11-20T14:04:32.520Z | 2024-11-25T14:21:42.857Z |
5551187 | 5551187 | 20241118124212_iK1k2 | NZ003Z | 2024-11-19T14:04:04.936Z | 2024-11-25T14:22:13.887Z |
5551097 | 5551097 | 20241118122431_6QopH | NZ003Z | 2024-11-19T14:03:54.281Z | 2024-11-25T14:22:13.532Z |
5551072 | 5551072 | 20241118121954_rDhtF | NZ003Z | 2024-11-19T14:03:52.395Z | 2024-11-25T14:22:13.437Z |
5550960 | 5550960 | 20241118120245_qZaEv | NZ003Z | 2024-11-19T14:03:38.106Z | 2024-11-25T14:22:13.139Z |
5550885 | 5550885 | 20241118114207_CaqVZ | NZ003Z | 2024-11-19T14:03:19.040Z | 2024-11-25T14:22:12.916Z |
5550801 | 5550801 | 20241118112929_U1lLI | NZ003Z | 2024-11-19T14:03:07.742Z | 2024-11-25T14:22:12.527Z |
5550700 | 5550700 | 20241118111102_bKOnK | NZ003Z | 2024-11-19T14:02:56.316Z | 2024-11-25T14:22:12.053Z |
5550584 | 5550584 | 20241118105157_sdOQe | NZ003Z | 2024-11-19T14:02:41.548Z | 2024-11-25T14:22:11.786Z |
5550440 | 5550440 | 20241118102040_349W2 | NZ003Z | 2024-11-19T14:02:20.223Z | 2024-11-25T14:22:11.551Z |
5549965 | 5549965 | 20241118085709_Nh3X8 | NZ003Z | 2024-11-19T14:01:22.192Z | 2024-11-25T14:22:10.149Z |
5547208 | 5547208 | 20241117150518_uwB0v | NZ003Z | 2024-11-18T14:05:16.418Z | 2024-11-25T14:22:25.311Z |
5547199 | 5547199 | 20241117150458_HjEyT | NZ003Z | 2024-11-18T14:05:16.044Z | 2024-11-25T14:22:25.310Z |
5547105 | 5547105 | 20241117144527_LGhTj | NZ003Z | 2024-11-18T14:05:02.302Z | 2024-11-25T14:22:25.092Z |
5547062 | 5547062 | 20241117143101_DfQhn | NZ003Z | 2024-11-18T14:04:52.463Z | 2024-11-25T14:22:24.995Z |
5547048 | 5547048 | 20241117142841_GlKxJ | NZ003Z | 2024-11-18T14:04:49.185Z | 2024-11-25T14:22:24.990Z |
5547027 | 5547027 | 20241117141901_bgok2 | NZ003Z | 2024-11-18T14:04:43.304Z | 2024-11-25T14:22:24.974Z |
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);