participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,398 rows where station_code = "NZ002N" 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 |
---|---|---|---|---|---|
5568864 | 5568864 | 20241121135355_PAUMB | NZ002N | 2024-11-22T14:10:00.572Z | 2024-11-22T14:10:00.572Z |
5568493 | 5568493 | 20241121125305_IS18W | NZ002N | 2024-11-22T14:09:06.290Z | 2024-11-22T14:09:06.290Z |
5568467 | 5568467 | 20241121125023_6J7fs | NZ002N | 2024-11-22T14:09:01.075Z | 2024-11-22T14:09:01.075Z |
5567725 | 5567725 | 20241121105746_HJRRk | NZ002N | 2024-11-22T14:07:08.728Z | 2024-11-22T14:07:08.728Z |
5567705 | 5567705 | 20241121105424_Blyfq | NZ002N | 2024-11-22T14:07:05.226Z | 2024-11-22T14:07:05.226Z |
5567680 | 5567680 | 20241121105208_LQtph | NZ002N | 2024-11-22T14:06:53.123Z | 2024-11-22T14:06:53.123Z |
5567648 | 5567648 | 20241121104818_4mxgn | NZ002N | 2024-11-22T14:06:44.535Z | 2024-11-22T14:06:44.535Z |
5567545 | 5567545 | 20241121103316_kgLJe | NZ002N | 2024-11-22T14:06:29.351Z | 2024-11-22T14:06:29.351Z |
5567439 | 5567439 | 20241121101855_KRb6V | NZ002N | 2024-11-22T14:06:16.836Z | 2024-11-22T14:06:16.836Z |
5567394 | 5567394 | 20241121101033_6aOQV | NZ002N | 2024-11-22T14:06:05.640Z | 2024-11-22T14:06:05.640Z |
5567352 | 5567352 | 20241121100600_Px2NJ | NZ002N | 2024-11-22T14:05:58.511Z | 2024-11-22T14:05:58.511Z |
5567245 | 5567245 | 20241121094859_Yf4I0 | NZ002N | 2024-11-22T14:05:40.549Z | 2024-11-22T14:05:40.549Z |
5566943 | 5566943 | 20241121084624_DxDfW | NZ002N | 2024-11-22T14:04:40.099Z | 2024-11-22T14:04:40.099Z |
5559247 | 5559247 | 20241120094642_IhCmL | NZ002N | 2024-11-21T14:05:43.186Z | 2024-11-22T14:19:21.396Z |
5559147 | 5559147 | 20241120092855_rSL2O | NZ002N | 2024-11-21T14:05:28.636Z | 2024-11-22T14:19:21.374Z |
5558810 | 5558810 | 20241120081152_ZRJuw | NZ002N | 2024-11-21T14:04:27.893Z | 2024-11-22T14:19:21.305Z |
5551909 | 5551909 | 20241118153812_uJNhw | NZ002N | 2024-11-19T14:05:47.490Z | 2024-11-22T14:22:12.963Z |
5551886 | 5551886 | 20241118153455_TUWdn | NZ002N | 2024-11-19T14:05:46.224Z | 2024-11-22T14:22:12.885Z |
5551830 | 5551830 | 20241118152132_TGBsU | NZ002N | 2024-11-19T14:05:40.536Z | 2024-11-22T14:22:12.642Z |
5551805 | 5551805 | 20241118151849_FEad7 | NZ002N | 2024-11-19T14:05:33.460Z | 2024-11-22T14:22:12.555Z |
5551801 | 5551801 | 20241118151736_ns2I7 | NZ002N | 2024-11-19T14:05:32.934Z | 2024-11-22T14:22:12.550Z |
5551687 | 5551687 | 20241118144430_lunmy | NZ002N | 2024-11-19T14:05:13.040Z | 2024-11-22T14:22:12.122Z |
5551627 | 5551627 | 20241118143012_9Eb7E | NZ002N | 2024-11-19T14:05:06.039Z | 2024-11-22T14:22:11.805Z |
5551460 | 5551460 | 20241118134343_PFU27 | NZ002N | 2024-11-19T14:04:49.464Z | 2024-11-22T14:22:10.818Z |
5551343 | 5551343 | 20241118131009_2604j | NZ002N | 2024-11-19T14:04:32.033Z | 2024-11-22T14:22:10.277Z |
5550771 | 5550771 | 20241118112327_hsgPS | NZ002N | 2024-11-19T14:03:04.111Z | 2024-11-22T14:22:05.509Z |
5550241 | 5550241 | 20241118095126_pzzSQ | NZ002N | 2024-11-19T14:01:54.675Z | 2024-11-22T14:22:00.290Z |
5550217 | 5550217 | 20241118094833_HHffA | NZ002N | 2024-11-19T14:01:47.132Z | 2024-11-22T14:21:59.899Z |
5546630 | 5546630 | 20241117120011_gRy3Q | NZ002N | 2024-11-18T14:03:41.675Z | 2024-11-22T14:22:33.490Z |
5546621 | 5546621 | 20241117115840_vn6Kj | NZ002N | 2024-11-18T14:03:40.334Z | 2024-11-22T14:22:33.447Z |
5546555 | 5546555 | 20241117113550_h2mFM | NZ002N | 2024-11-18T14:03:29.441Z | 2024-11-22T14:22:32.622Z |
5546551 | 5546551 | 20241117113433_tRWVP | NZ002N | 2024-11-18T14:03:28.748Z | 2024-11-22T14:22:32.597Z |
5546222 | 5546222 | 20241117095552_azoLo | NZ002N | 2024-11-18T14:02:29.927Z | 2024-11-22T14:22:30.353Z |
5546029 | 5546029 | 20241117085436_szIza | NZ002N | 2024-11-18T14:01:46.163Z | 2024-11-22T14:22:28.208Z |
5544798 | 5544798 | 20241116152656_5XTda | NZ002N | 2024-11-17T14:02:08.413Z | 2024-11-22T14:23:06.304Z |
5542883 | 5542883 | 20241115153422_iE8rY | NZ002N | 2024-11-16T14:02:54.346Z | 2024-11-22T14:23:32.289Z |
5542875 | 5542875 | 20241115152055_e3WNl | NZ002N | 2024-11-16T14:02:53.118Z | 2024-11-22T14:23:32.249Z |
5542848 | 5542848 | 20241115143244_jMBUy | NZ002N | 2024-11-16T14:02:45.805Z | 2024-11-22T14:23:31.792Z |
5542836 | 5542836 | 20241115134125_wbDf9 | NZ002N | 2024-11-16T14:02:43.648Z | 2024-11-22T14:23:31.617Z |
5542707 | 5542707 | 20241115115742_a71b9 | NZ002N | 2024-11-16T14:02:14.249Z | 2024-11-22T14:23:30.507Z |
5532739 | 5532739 | 20241110120138_bwfkX | NZ002N | 2024-11-13T14:18:55.872Z | 2024-11-19T14:21:36.716Z |
5532737 | 5532737 | 20241110115902_cWUk5 | NZ002N | 2024-11-13T14:18:54.744Z | 2024-11-19T14:21:36.475Z |
5532734 | 5532734 | 20241110090441_BGJo6 | NZ002N | 2024-11-13T14:18:03.815Z | 2024-11-19T14:21:26.050Z |
5512538 | 5512538 | 20241110090441_x2z7j | NZ002N | 2024-11-11T14:02:34.903Z | 2024-11-12T14:18:06.114Z |
5508615 | 5508615 | 20241108122803_mFPtL | NZ002N | 2024-11-10T14:09:50.856Z | 2024-11-17T14:23:12.260Z |
5501393 | 5501393 | 20241107124932_XvqPz | NZ002N | 2024-11-09T14:09:25.964Z | 2024-11-16T14:27:37.606Z |
5501388 | 5501388 | 20241107124452_fa4zp | NZ002N | 2024-11-09T14:09:22.356Z | 2024-11-16T14:27:36.850Z |
5500436 | 5500436 | 20241108154242_F38TE | NZ002N | 2024-11-09T14:06:16.994Z | 2024-11-17T14:23:22.695Z |
5500390 | 5500390 | 20241108153334_tT34n | NZ002N | 2024-11-09T14:06:12.548Z | 2024-11-17T14:23:22.409Z |
5500348 | 5500348 | 20241108152627_6xhSo | NZ002N | 2024-11-09T14:06:09.744Z | 2024-11-17T14:23:21.911Z |
5500309 | 5500309 | 20241108151729_2Qf1p | NZ002N | 2024-11-09T14:06:05.761Z | 2024-11-17T14:23:21.362Z |
5500306 | 5500306 | 20241108151702_VrRlL | NZ002N | 2024-11-09T14:06:05.457Z | 2024-11-17T14:23:21.279Z |
5500293 | 5500293 | 20241108151442_PDX73 | NZ002N | 2024-11-09T14:06:04.563Z | 2024-11-17T14:23:21.176Z |
5500205 | 5500205 | 20241108150434_halM0 | NZ002N | 2024-11-09T14:05:58.621Z | 2024-11-17T14:23:20.127Z |
5500107 | 5500107 | 20241108144626_fV1ut | NZ002N | 2024-11-09T14:05:42.178Z | 2024-11-17T14:23:19.073Z |
5500073 | 5500073 | 20241108143735_iPDWe | NZ002N | 2024-11-09T14:05:39.066Z | 2024-11-17T14:23:18.476Z |
5499996 | 5499996 | 20241108142115_b3FiQ | NZ002N | 2024-11-09T14:05:28.362Z | 2024-11-17T14:23:17.917Z |
5499969 | 5499969 | 20241108141635_yI5IJ | NZ002N | 2024-11-09T14:05:24.939Z | 2024-11-17T14:23:17.725Z |
5499928 | 5499928 | 20241108140422_sBVzp | NZ002N | 2024-11-09T14:05:20.586Z | 2024-11-17T14:23:17.257Z |
5499869 | 5499869 | 20241108135142_W4mcB | NZ002N | 2024-11-09T14:05:05.239Z | 2024-11-17T14:23:16.555Z |
5499858 | 5499858 | 20241108134902_cPoXj | NZ002N | 2024-11-09T14:05:04.162Z | 2024-11-17T14:23:16.474Z |
5499713 | 5499713 | 20241108130725_nJ7i2 | NZ002N | 2024-11-09T14:04:47.999Z | 2024-11-17T14:23:14.695Z |
5499626 | 5499626 | 20241108124618_s0R1C | NZ002N | 2024-11-09T14:04:28.010Z | 2024-11-17T14:23:13.953Z |
5499615 | 5499615 | 20241108124510_XyoI5 | NZ002N | 2024-11-09T14:04:26.991Z | 2024-11-17T14:23:13.760Z |
5499572 | 5499572 | 20241108123901_4KHH3 | NZ002N | 2024-11-09T14:04:21.504Z | 2024-11-17T14:23:13.290Z |
5499532 | 5499532 | 20241108123317_d7cDm | NZ002N | 2024-11-09T14:04:16.534Z | 2024-11-17T14:23:12.715Z |
5499496 | 5499496 | 20241108122751_a4VOz | NZ002N | 2024-11-09T14:04:12.693Z | 2024-11-17T14:23:12.142Z |
5499373 | 5499373 | 20241108120619_02aKc | NZ002N | 2024-11-09T14:03:53.209Z | 2024-11-17T14:23:10.567Z |
5499312 | 5499312 | 20241108115437_JJdq5 | NZ002N | 2024-11-09T14:03:44.356Z | 2024-11-17T14:23:09.236Z |
5499165 | 5499165 | 20241108112116_2tXMS | NZ002N | 2024-11-09T14:03:28.087Z | 2024-11-17T14:23:07.394Z |
5499064 | 5499064 | 20241108105722_AT1ql | NZ002N | 2024-11-09T14:03:05.040Z | 2024-11-17T14:23:04.749Z |
5498878 | 5498878 | 20241108101816_p6mxZ | NZ002N | 2024-11-09T14:02:41.169Z | 2024-11-17T14:23:00.928Z |
5498747 | 5498747 | 20241108094849_NkYli | NZ002N | 2024-11-09T14:02:19.163Z | 2024-11-17T14:22:59.533Z |
5498740 | 5498740 | 20241108094743_MLUCd | NZ002N | 2024-11-09T14:02:18.432Z | 2024-11-17T14:22:59.467Z |
5498623 | 5498623 | 20241108092255_Ebftq | NZ002N | 2024-11-09T14:01:58.681Z | 2024-11-17T14:22:58.428Z |
5498410 | 5498410 | 20241108082824_Y2eWr | NZ002N | 2024-11-09T14:01:26.508Z | 2024-11-17T14:22:54.210Z |
5494107 | 5494107 | 20241107153815_vmJ5U | NZ002N | 2024-11-08T14:05:23.235Z | 2024-11-16T14:27:47.719Z |
5494103 | 5494103 | 20241107153547_vzA1h | NZ002N | 2024-11-08T14:05:23.003Z | 2024-11-16T14:27:47.691Z |
5494052 | 5494052 | 20241107152304_8ggb4 | NZ002N | 2024-11-08T14:05:18.162Z | 2024-11-16T14:27:45.685Z |
5494012 | 5494012 | 20241107151037_VuN0d | NZ002N | 2024-11-08T14:05:15.649Z | 2024-11-16T14:27:45.074Z |
5493992 | 5493992 | 20241107150604_Ak0cd | NZ002N | 2024-11-08T14:05:13.110Z | 2024-11-16T14:27:44.505Z |
5493939 | 5493939 | 20241107144258_ojw2c | NZ002N | 2024-11-08T14:05:00.600Z | 2024-11-16T14:27:43.508Z |
5493894 | 5493894 | 20241107142817_eZtma | NZ002N | 2024-11-08T14:04:49.787Z | 2024-11-16T14:27:42.869Z |
5493844 | 5493844 | 20241107140924_KFe5d | NZ002N | 2024-11-08T14:04:43.792Z | 2024-11-16T14:27:42.212Z |
5493808 | 5493808 | 20241107135550_3z9JY | NZ002N | 2024-11-08T14:04:40.887Z | 2024-11-16T14:27:41.661Z |
5493743 | 5493743 | 20241107131409_aLBXP | NZ002N | 2024-11-08T14:04:33.817Z | 2024-11-16T14:27:39.741Z |
5493593 | 5493593 | 20241107124345_AD4ns | NZ002N | 2024-11-08T14:04:13.667Z | 2024-11-16T14:27:36.591Z |
5493306 | 5493306 | 20241107114517_4cQPS | NZ002N | 2024-11-08T14:03:30.971Z | 2024-11-16T14:27:33.431Z |
5493098 | 5493098 | 20241107105357_G1oI6 | NZ002N | 2024-11-08T14:02:51.263Z | 2024-11-16T14:27:32.024Z |
5492513 | 5492513 | 20241107084652_g2v0w | NZ002N | 2024-11-08T14:01:19.490Z | 2024-11-16T14:27:26.201Z |
5492417 | 5492417 | 20241107083113_jd9Dk | NZ002N | 2024-11-08T14:01:02.271Z | 2024-11-16T14:27:25.000Z |
5474085 | 5474085 | 20241103155045_tJC32 | NZ002N | 2024-11-05T14:10:07.710Z | 2024-11-12T14:27:50.532Z |
5474081 | 5474081 | 20241103155001_2TuHj | NZ002N | 2024-11-05T14:10:07.428Z | 2024-11-12T14:27:50.507Z |
5473987 | 5473987 | 20241103153434_AqdMr | NZ002N | 2024-11-05T14:09:58.317Z | 2024-11-12T14:27:50.435Z |
5473945 | 5473945 | 20241103152648_iNKXl | NZ002N | 2024-11-05T14:09:55.544Z | 2024-11-12T14:27:50.251Z |
5473696 | 5473696 | 20241103145039_LOPd9 | NZ002N | 2024-11-05T14:09:27.589Z | 2024-11-12T14:27:49.927Z |
5473612 | 5473612 | 20241103143947_Cgv8I | NZ002N | 2024-11-05T14:09:13.075Z | 2024-11-12T14:27:49.807Z |
5473603 | 5473603 | 20241103143839_1QLLe | NZ002N | 2024-11-05T14:09:11.848Z | 2024-11-12T14:27:49.781Z |
5473541 | 5473541 | 20241103143040_Yf1NK | NZ002N | 2024-11-05T14:09:05.036Z | 2024-11-12T14:27:49.688Z |
5473532 | 5473532 | 20241103142959_XKwWH | NZ002N | 2024-11-05T14:09:04.601Z | 2024-11-12T14:27:49.686Z |
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);