participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,395 rows where station_code = "NZ003H" 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 |
---|---|---|---|---|---|
5597434 | 5597434 | 20241124152316_NJIlg | NZ003H | 2024-11-25T14:11:28.925Z | 2024-11-26T14:18:44.597Z |
5597419 | 5597419 | 20241124152241_bZ4sD | NZ003H | 2024-11-25T14:11:27.845Z | 2024-11-26T14:18:44.594Z |
5597271 | 5597271 | 20241124151459_uJ4oW | NZ003H | 2024-11-25T14:11:19.838Z | 2024-11-26T14:18:44.570Z |
5597142 | 5597142 | 20241124150654_3JkZR | NZ003H | 2024-11-25T14:11:11.259Z | 2024-11-26T14:18:44.551Z |
5597102 | 5597102 | 20241124150140_E2zCa | NZ003H | 2024-11-25T14:11:05.331Z | 2024-11-26T14:18:44.545Z |
5596993 | 5596993 | 20241124145239_SnJ69 | NZ003H | 2024-11-25T14:10:55.660Z | 2024-11-26T14:18:44.529Z |
5596581 | 5596581 | 20241124140527_UcqCc | NZ003H | 2024-11-25T14:10:21.142Z | 2024-11-26T14:18:44.449Z |
5596457 | 5596457 | 20241124135341_LL3oc | NZ003H | 2024-11-25T14:10:01.817Z | 2024-11-26T14:18:44.429Z |
5596285 | 5596285 | 20241124133215_tOORw | NZ003H | 2024-11-25T14:09:46.425Z | 2024-11-26T14:18:44.405Z |
5596268 | 5596268 | 20241124133057_5Czmy | NZ003H | 2024-11-25T14:09:44.377Z | 2024-11-26T14:18:44.402Z |
5596205 | 5596205 | 20241124132554_JcOMN | NZ003H | 2024-11-25T14:09:38.577Z | 2024-11-26T14:18:44.393Z |
5596196 | 5596196 | 20241124132521_KgquD | NZ003H | 2024-11-25T14:09:37.837Z | 2024-11-26T14:18:44.392Z |
5596068 | 5596068 | 20241124131215_qRNsJ | NZ003H | 2024-11-25T14:09:27.725Z | 2024-11-26T14:18:44.371Z |
5595942 | 5595942 | 20241124130030_BvR2v | NZ003H | 2024-11-25T14:09:10.526Z | 2024-11-26T14:18:44.349Z |
5595904 | 5595904 | 20241124125810_chzFz | NZ003H | 2024-11-25T14:09:08.146Z | 2024-11-26T14:18:44.345Z |
5595848 | 5595848 | 20241124125435_4N3AV | NZ003H | 2024-11-25T14:09:01.795Z | 2024-11-26T14:18:44.336Z |
5595789 | 5595789 | 20241124124918_FTQNq | NZ003H | 2024-11-25T14:08:53.929Z | 2024-11-26T14:18:44.326Z |
5595654 | 5595654 | 20241124123826_ut58E | NZ003H | 2024-11-25T14:08:40.180Z | 2024-11-26T14:18:44.302Z |
5595466 | 5595466 | 20241124122122_hiyLD | NZ003H | 2024-11-25T14:08:16.658Z | 2024-11-26T14:18:44.273Z |
5595280 | 5595280 | 20241124120128_JPBjT | NZ003H | 2024-11-25T14:07:53.475Z | 2024-11-26T14:18:44.241Z |
5595072 | 5595072 | 20241124114007_XzUjY | NZ003H | 2024-11-25T14:07:19.840Z | 2024-11-26T14:18:44.201Z |
5595015 | 5595015 | 20241124113321_x1vfx | NZ003H | 2024-11-25T14:07:08.082Z | 2024-11-26T14:18:44.191Z |
5594429 | 5594429 | 20241124102715_WTNba | NZ003H | 2024-11-25T14:05:39.869Z | 2024-11-26T14:18:44.081Z |
5594426 | 5594426 | 20241124102636_9SfaQ | NZ003H | 2024-11-25T14:05:39.501Z | 2024-11-26T14:18:44.080Z |
5593817 | 5593817 | 20241124085329_92iP0 | NZ003H | 2024-11-25T14:03:51.195Z | 2024-11-26T14:18:43.952Z |
5584020 | 5584020 | 20241117132616_R2WLs | NZ003H | 2024-11-23T14:25:20.049Z | 2024-11-26T14:28:34.587Z |
5583821 | 5583821 | 20241118153423_Y7XGB | NZ003H | 2024-11-23T14:25:03.501Z | 2024-11-26T14:28:08.963Z |
5583810 | 5583810 | 20241118145842_O04Xg | NZ003H | 2024-11-23T14:25:03.040Z | 2024-11-26T14:28:08.508Z |
5583003 | 5583003 | 20241120115946_KIrrT | NZ003H | 2024-11-23T14:22:29.869Z | 2024-11-26T14:26:03.204Z |
5577027 | 5577027 | 20241122153205_Y0vcG | NZ003H | 2024-11-23T14:11:08.649Z | 2024-11-26T14:22:55.714Z |
5577010 | 5577010 | 20241122151333_KvF7V | NZ003H | 2024-11-23T14:11:06.124Z | 2024-11-26T14:22:55.234Z |
5576996 | 5576996 | 20241122150913_k4aZV | NZ003H | 2024-11-23T14:11:04.703Z | 2024-11-26T14:22:55.078Z |
5576961 | 5576961 | 20241122145343_5RRCQ | NZ003H | 2024-11-23T14:10:59.975Z | 2024-11-23T14:10:59.975Z |
5576918 | 5576918 | 20241122143448_RmdFo | NZ003H | 2024-11-23T14:10:55.618Z | 2024-11-23T14:10:55.618Z |
5576858 | 5576858 | 20241122140512_bN35a | NZ003H | 2024-11-23T14:10:41.600Z | 2024-11-26T14:22:53.360Z |
5576820 | 5576820 | 20241122134707_O24Js | NZ003H | 2024-11-23T14:10:34.637Z | 2024-11-26T14:22:52.848Z |
5569513 | 5569513 | 20241121154653_urD5q | NZ003H | 2024-11-22T14:11:00.377Z | 2024-11-26T14:24:34.862Z |
5569468 | 5569468 | 20241121153546_wVvXr | NZ003H | 2024-11-22T14:10:55.330Z | 2024-11-26T14:24:34.673Z |
5569334 | 5569334 | 20241121151118_7ddiY | NZ003H | 2024-11-22T14:10:46.386Z | 2024-11-26T14:24:33.769Z |
5569310 | 5569310 | 20241121150721_35VJl | NZ003H | 2024-11-22T14:10:44.860Z | 2024-11-26T14:24:33.564Z |
5569282 | 5569282 | 20241121150418_cquL0 | NZ003H | 2024-11-22T14:10:43.543Z | 2024-11-26T14:24:33.518Z |
5569272 | 5569272 | 20241121150353_T3ogZ | NZ003H | 2024-11-22T14:10:43.379Z | 2024-11-26T14:24:33.507Z |
5569255 | 5569255 | 20241121150020_wO6Ri | NZ003H | 2024-11-22T14:10:41.752Z | 2024-11-26T14:24:33.458Z |
5569214 | 5569214 | 20241121145324_OKKIX | NZ003H | 2024-11-22T14:10:38.561Z | 2024-11-26T14:24:33.405Z |
5569166 | 5569166 | 20241121144537_s5TMQ | NZ003H | 2024-11-22T14:10:25.416Z | 2024-11-26T14:24:33.023Z |
5569145 | 5569145 | 20241121144108_3nM2T | NZ003H | 2024-11-22T14:10:23.867Z | 2024-11-26T14:24:32.885Z |
5569114 | 5569114 | 20241121143730_tktJQ | NZ003H | 2024-11-22T14:10:21.876Z | 2024-11-26T14:24:32.827Z |
5569045 | 5569045 | 20241121142434_88Z7u | NZ003H | 2024-11-22T14:10:14.349Z | 2024-11-26T14:24:32.036Z |
5568941 | 5568941 | 20241121140818_5Btk2 | NZ003H | 2024-11-22T14:10:05.965Z | 2024-11-26T14:24:31.803Z |
5568874 | 5568874 | 20241121135529_2R0bV | NZ003H | 2024-11-22T14:10:01.024Z | 2024-11-26T14:24:31.205Z |
5568860 | 5568860 | 20241121135210_1M6b3 | NZ003H | 2024-11-22T14:10:00.298Z | 2024-11-26T14:24:31.153Z |
5568681 | 5568681 | 20241121132041_ZgUGv | NZ003H | 2024-11-22T14:09:33.069Z | 2024-11-26T14:24:30.628Z |
5568675 | 5568675 | 20241121132014_93Z85 | NZ003H | 2024-11-22T14:09:32.779Z | 2024-11-26T14:24:30.627Z |
5568654 | 5568654 | 20241121131829_HZHFn | NZ003H | 2024-11-22T14:09:30.843Z | 2024-11-26T14:24:30.568Z |
5568599 | 5568599 | 20241121131022_X8C00 | NZ003H | 2024-11-22T14:09:24.665Z | 2024-11-26T14:24:29.744Z |
5568584 | 5568584 | 20241121130900_xacAK | NZ003H | 2024-11-22T14:09:23.564Z | 2024-11-26T14:24:29.697Z |
5568523 | 5568523 | 20241121125447_LfxPi | NZ003H | 2024-11-22T14:09:15.470Z | 2024-11-26T14:24:28.783Z |
5568483 | 5568483 | 20241121125202_7PNkT | NZ003H | 2024-11-22T14:09:03.636Z | 2024-11-26T14:24:28.432Z |
5568477 | 5568477 | 20241121125150_7jgkB | NZ003H | 2024-11-22T14:09:02.940Z | 2024-11-26T14:24:28.424Z |
5568465 | 5568465 | 20241121124933_W1JEB | NZ003H | 2024-11-22T14:09:00.271Z | 2024-11-26T14:24:28.379Z |
5568380 | 5568380 | 20241121123522_eeSP2 | NZ003H | 2024-11-22T14:08:50.026Z | 2024-11-26T14:24:27.572Z |
5568334 | 5568334 | 20241121122648_ehXpG | NZ003H | 2024-11-22T14:08:44.656Z | 2024-11-26T14:24:27.197Z |
5568307 | 5568307 | 20241121122042_C2MG4 | NZ003H | 2024-11-22T14:08:40.195Z | 2024-11-26T14:24:26.861Z |
5568285 | 5568285 | 20241121121825_t77EO | NZ003H | 2024-11-22T14:08:38.500Z | 2024-11-26T14:24:26.646Z |
5568242 | 5568242 | 20241121121342_823gB | NZ003H | 2024-11-22T14:08:34.495Z | 2024-11-26T14:24:26.317Z |
5568131 | 5568131 | 20241121115338_b3BOQ | NZ003H | 2024-11-22T14:08:10.273Z | 2024-11-26T14:24:25.046Z |
5568076 | 5568076 | 20241121114611_7u4D7 | NZ003H | 2024-11-22T14:08:03.786Z | 2024-11-26T14:24:24.453Z |
5568022 | 5568022 | 20241121114209_diUVR | NZ003H | 2024-11-22T14:07:57.522Z | 2024-11-26T14:24:24.071Z |
5568008 | 5568008 | 20241121114127_DLA3O | NZ003H | 2024-11-22T14:07:56.663Z | 2024-11-26T14:24:24.000Z |
5567991 | 5567991 | 20241121113840_huv8I | NZ003H | 2024-11-22T14:07:55.014Z | 2024-11-26T14:24:23.907Z |
5567968 | 5567968 | 20241121113652_qMqor | NZ003H | 2024-11-22T14:07:52.367Z | 2024-11-26T14:24:23.789Z |
5567943 | 5567943 | 20241121113346_D0iWc | NZ003H | 2024-11-22T14:07:49.881Z | 2024-11-26T14:24:23.480Z |
5567930 | 5567930 | 20241121113229_H63p4 | NZ003H | 2024-11-22T14:07:46.299Z | 2024-11-26T14:24:23.459Z |
5567841 | 5567841 | 20241121111745_1H22Z | NZ003H | 2024-11-22T14:07:22.533Z | 2024-11-26T14:24:22.313Z |
5567807 | 5567807 | 20241121111152_sN7Tv | NZ003H | 2024-11-22T14:07:18.066Z | 2024-11-26T14:24:21.914Z |
5567665 | 5567665 | 20241121104934_nBLwy | NZ003H | 2024-11-22T14:06:47.789Z | 2024-11-26T14:24:20.243Z |
5567653 | 5567653 | 20241121104916_gUPRw | NZ003H | 2024-11-22T14:06:45.441Z | 2024-11-26T14:24:20.127Z |
5567517 | 5567517 | 20241121103102_o3AXz | NZ003H | 2024-11-22T14:06:26.212Z | 2024-11-26T14:24:17.047Z |
5567337 | 5567337 | 20241121100303_7jpyC | NZ003H | 2024-11-22T14:05:55.139Z | 2024-11-26T14:24:15.059Z |
5567165 | 5567165 | 20241121093632_4PEP7 | NZ003H | 2024-11-22T14:05:29.099Z | 2024-11-26T14:24:13.445Z |
5560878 | 5560878 | 20241120150856_sZy5p | NZ003H | 2024-11-21T14:09:55.013Z | 2024-11-26T14:26:08.399Z |
5560871 | 5560871 | 20241120150455_S2LkO | NZ003H | 2024-11-21T14:09:54.236Z | 2024-11-26T14:26:08.316Z |
5560555 | 5560555 | 20241120130824_eLBy7 | NZ003H | 2024-11-21T14:09:04.647Z | 2024-11-26T14:26:07.082Z |
5560550 | 5560550 | 20241120130804_226Fy | NZ003H | 2024-11-21T14:09:04.348Z | 2024-11-26T14:26:07.076Z |
5560507 | 5560507 | 20241120130304_2Kelq | NZ003H | 2024-11-21T14:08:59.241Z | 2024-11-26T14:26:06.823Z |
5560439 | 5560439 | 20241120125209_ESeso | NZ003H | 2024-11-21T14:08:51.844Z | 2024-11-26T14:26:06.489Z |
5560283 | 5560283 | 20241120123004_c2Lp2 | NZ003H | 2024-11-21T14:08:30.465Z | 2024-11-26T14:26:04.478Z |
5560256 | 5560256 | 20241120122543_NgcXs | NZ003H | 2024-11-21T14:08:25.316Z | 2024-11-26T14:26:04.228Z |
5560235 | 5560235 | 20241120122321_yGKLq | NZ003H | 2024-11-21T14:08:21.411Z | 2024-11-26T14:26:04.135Z |
5560115 | 5560115 | 20241120120349_2leRE | NZ003H | 2024-11-21T14:08:04.495Z | 2024-11-26T14:26:03.319Z |
5559947 | 5559947 | 20241120113720_N9vjx | NZ003H | 2024-11-21T14:07:38.794Z | 2024-11-26T14:26:02.381Z |
5559928 | 5559928 | 20241120113545_5AkjE | NZ003H | 2024-11-21T14:07:35.250Z | 2024-11-26T14:26:02.349Z |
5559920 | 5559920 | 20241120113428_qd30b | NZ003H | 2024-11-21T14:07:34.434Z | 2024-11-26T14:26:02.275Z |
5559860 | 5559860 | 20241120112646_y40t4 | NZ003H | 2024-11-21T14:07:20.832Z | 2024-11-26T14:26:01.708Z |
5559820 | 5559820 | 20241120112142_Ef1Yd | NZ003H | 2024-11-21T14:07:15.539Z | 2024-11-26T14:26:01.283Z |
5559818 | 5559818 | 20241120112139_cJUxq | NZ003H | 2024-11-21T14:07:14.790Z | 2024-11-26T14:26:01.278Z |
5559109 | 5559109 | 20241120092503_EvZm4 | NZ003H | 2024-11-21T14:05:22.985Z | 2024-11-26T14:25:52.332Z |
5559091 | 5559091 | 20241120092123_A1N2X | NZ003H | 2024-11-21T14:05:18.757Z | 2024-11-26T14:25:52.301Z |
5559038 | 5559038 | 20241120090734_2wEq3 | NZ003H | 2024-11-21T14:05:07.469Z | 2024-11-26T14:25:52.064Z |
5558994 | 5558994 | 20241120090331_PmQnH | NZ003H | 2024-11-21T14:05:00.172Z | 2024-11-26T14:25:51.908Z |
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);