participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,608 rows where station_code = "NZ003V" 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 |
---|---|---|---|---|---|
5460153 | 5460153 | 20241101125837_l3XNi | NZ003V | 2024-11-03T14:13:24.949Z | 2024-11-03T14:19:33.488Z |
5460102 | 5460102 | 20241101124324_WctV5 | NZ003V | 2024-11-03T14:13:21.109Z | 2024-11-03T14:19:33.476Z |
5460092 | 5460092 | 20241101124238_9R1uA | NZ003V | 2024-11-03T14:13:20.743Z | 2024-11-03T14:19:33.475Z |
5459833 | 5459833 | 20241101115913_d1EWh | NZ003V | 2024-11-03T14:12:38.842Z | 2024-11-03T14:19:33.426Z |
5459708 | 5459708 | 20241101114020_X1Xqt | NZ003V | 2024-11-03T14:12:29.787Z | 2024-11-03T14:19:33.402Z |
5459599 | 5459599 | 20241101112203_NVoF9 | NZ003V | 2024-11-03T14:12:21.196Z | 2024-11-03T14:19:33.378Z |
5459522 | 5459522 | 20241101111234_3iDqz | NZ003V | 2024-11-03T14:12:11.661Z | 2024-11-03T14:19:33.361Z |
5458681 | 5458681 | 20241101090316_Sw4Ba | NZ003V | 2024-11-03T14:10:27.978Z | 2024-11-03T14:19:33.176Z |
5458648 | 5458648 | 20241101085549_gdw8L | NZ003V | 2024-11-03T14:10:14.777Z | 2024-11-03T14:19:33.167Z |
5458075 | 5458075 | 20241102160939_hMW93 | NZ003V | 2024-11-03T14:08:43.524Z | 2024-11-03T14:08:43.524Z |
5458067 | 5458067 | 20241102160843_bD9F1 | NZ003V | 2024-11-03T14:08:41.280Z | 2024-11-03T14:08:41.280Z |
5458055 | 5458055 | 20241102160428_lXasS | NZ003V | 2024-11-03T14:08:37.717Z | 2024-11-03T14:08:37.717Z |
5458037 | 5458037 | 20241102160151_d8sB2 | NZ003V | 2024-11-03T14:08:35.724Z | 2024-11-03T14:08:35.724Z |
5457981 | 5457981 | 20241102155300_QBtvy | NZ003V | 2024-11-03T14:08:29.458Z | 2024-11-03T14:08:29.458Z |
5457936 | 5457936 | 20241102154132_dcGLQ | NZ003V | 2024-11-03T14:08:22.032Z | 2024-11-03T14:08:22.032Z |
5457912 | 5457912 | 20241102153904_m811I | NZ003V | 2024-11-03T14:08:20.364Z | 2024-11-03T14:08:20.364Z |
5457872 | 5457872 | 20241102153155_2JvuR | NZ003V | 2024-11-03T14:08:17.251Z | 2024-11-03T14:08:17.251Z |
5457856 | 5457856 | 20241102153007_SrxYn | NZ003V | 2024-11-03T14:08:16.366Z | 2024-11-03T14:08:16.366Z |
5457843 | 5457843 | 20241102152926_XHf3m | NZ003V | 2024-11-03T14:08:15.801Z | 2024-11-03T14:08:15.801Z |
5457829 | 5457829 | 20241102152739_WOnBh | NZ003V | 2024-11-03T14:08:14.810Z | 2024-11-03T14:08:14.810Z |
5457738 | 5457738 | 20241102151710_MMdus | NZ003V | 2024-11-03T14:07:55.670Z | 2024-11-03T14:07:55.670Z |
5457645 | 5457645 | 20241102150028_QLm13 | NZ003V | 2024-11-03T14:07:46.161Z | 2024-11-03T14:07:46.161Z |
5457629 | 5457629 | 20241102145519_FRWRN | NZ003V | 2024-11-03T14:07:44.969Z | 2024-11-03T14:07:44.969Z |
5457618 | 5457618 | 20241102145342_lSb3V | NZ003V | 2024-11-03T14:07:44.207Z | 2024-11-03T14:07:44.207Z |
5457607 | 5457607 | 20241102145316_WlNoO | NZ003V | 2024-11-03T14:07:43.220Z | 2024-11-03T14:07:43.220Z |
5457578 | 5457578 | 20241102144851_ZrS5o | NZ003V | 2024-11-03T14:07:41.430Z | 2024-11-03T14:07:41.430Z |
5457524 | 5457524 | 20241102144002_1MQYq | NZ003V | 2024-11-03T14:07:35.791Z | 2024-11-03T14:07:35.791Z |
5457409 | 5457409 | 20241102142500_a8LzN | NZ003V | 2024-11-03T14:07:16.125Z | 2024-11-03T14:07:16.125Z |
5457390 | 5457390 | 20241102142258_jjoS1 | NZ003V | 2024-11-03T14:07:12.854Z | 2024-11-03T14:07:12.854Z |
5457306 | 5457306 | 20241102140749_upzBF | NZ003V | 2024-11-03T14:07:05.629Z | 2024-11-03T14:07:05.629Z |
5457298 | 5457298 | 20241102140702_7qVaC | NZ003V | 2024-11-03T14:07:04.443Z | 2024-11-03T14:07:04.443Z |
5457132 | 5457132 | 20241102133554_qO7Ox | NZ003V | 2024-11-03T14:06:37.164Z | 2024-11-03T14:06:37.164Z |
5457114 | 5457114 | 20241102133310_aK4fz | NZ003V | 2024-11-03T14:06:35.516Z | 2024-11-03T14:06:35.516Z |
5457075 | 5457075 | 20241102132833_kPUhu | NZ003V | 2024-11-03T14:06:30.580Z | 2024-11-03T14:06:30.580Z |
5457045 | 5457045 | 20241102132129_hW9gA | NZ003V | 2024-11-03T14:06:26.669Z | 2024-11-03T14:06:26.669Z |
5457040 | 5457040 | 20241102132126_Vdzu2 | NZ003V | 2024-11-03T14:06:26.183Z | 2024-11-03T14:06:26.183Z |
5456964 | 5456964 | 20241102130246_U7qz2 | NZ003V | 2024-11-03T14:06:12.459Z | 2024-11-03T14:06:12.459Z |
5456942 | 5456942 | 20241102125650_vjDjV | NZ003V | 2024-11-03T14:06:06.944Z | 2024-11-03T14:06:06.944Z |
5456869 | 5456869 | 20241102124251_uKvOJ | NZ003V | 2024-11-03T14:05:51.699Z | 2024-11-03T14:05:51.699Z |
5456853 | 5456853 | 20241102124012_Jim5W | NZ003V | 2024-11-03T14:05:49.785Z | 2024-11-03T14:05:49.785Z |
5456817 | 5456817 | 20241102123142_E3OAP | NZ003V | 2024-11-03T14:05:44.945Z | 2024-11-03T14:05:44.945Z |
5456754 | 5456754 | 20241102121636_NHLly | NZ003V | 2024-11-03T14:05:37.523Z | 2024-11-03T14:05:37.523Z |
5456716 | 5456716 | 20241102120827_Rr9OP | NZ003V | 2024-11-03T14:05:32.847Z | 2024-11-03T14:05:32.847Z |
5456687 | 5456687 | 20241102120433_6bsW9 | NZ003V | 2024-11-03T14:05:25.033Z | 2024-11-03T14:05:25.033Z |
5456604 | 5456604 | 20241102114944_M2zdE | NZ003V | 2024-11-03T14:05:05.218Z | 2024-11-03T14:05:05.218Z |
5456562 | 5456562 | 20241102114533_zu0gI | NZ003V | 2024-11-03T14:04:59.599Z | 2024-11-03T14:04:59.599Z |
5456533 | 5456533 | 20241102113951_2CLCV | NZ003V | 2024-11-03T14:04:56.384Z | 2024-11-03T14:04:56.384Z |
5449648 | 5449648 | 20241031160409_WZBT3 | NZ003V | 2024-11-02T12:13:16.027Z | 2024-11-03T14:20:55.935Z |
5449612 | 5449612 | 20241031160013_2KghV | NZ003V | 2024-11-02T12:13:11.985Z | 2024-11-03T14:20:55.701Z |
5449495 | 5449495 | 20241031154445_RSpqf | NZ003V | 2024-11-02T12:13:01.244Z | 2024-11-03T14:20:53.891Z |
5449477 | 5449477 | 20241031154128_oBXtX | NZ003V | 2024-11-02T12:12:59.231Z | 2024-11-03T14:20:53.450Z |
5449363 | 5449363 | 20241031152519_HAB33 | NZ003V | 2024-11-02T12:12:45.460Z | 2024-11-03T14:20:51.975Z |
5449295 | 5449295 | 20241031151738_Kp2mG | NZ003V | 2024-11-02T12:12:27.283Z | 2024-11-03T14:20:50.923Z |
5449230 | 5449230 | 20241031150804_sLhph | NZ003V | 2024-11-02T12:12:19.354Z | 2024-11-03T14:20:49.713Z |
5449091 | 5449091 | 20241031145205_Mfi38 | NZ003V | 2024-11-02T12:12:04.501Z | 2024-11-03T14:20:48.632Z |
5449060 | 5449060 | 20241031144749_DFAqI | NZ003V | 2024-11-02T12:12:01.162Z | 2024-11-03T14:20:48.060Z |
5448869 | 5448869 | 20241031142630_I1Jes | NZ003V | 2024-11-02T12:11:37.385Z | 2024-11-03T14:20:43.785Z |
5448857 | 5448857 | 20241031142436_z52PU | NZ003V | 2024-11-02T12:11:34.954Z | 2024-11-03T14:20:43.607Z |
5448839 | 5448839 | 20241031142243_b2ZBH | NZ003V | 2024-11-02T12:11:32.761Z | 2024-11-03T14:20:43.276Z |
5448801 | 5448801 | 20241031141720_e22sa | NZ003V | 2024-11-02T12:11:28.852Z | 2024-11-03T14:20:42.423Z |
5448694 | 5448694 | 20241031140720_4FV03 | NZ003V | 2024-11-02T12:11:19.953Z | 2024-11-03T14:20:41.449Z |
5448612 | 5448612 | 20241031135412_NP9vY | NZ003V | 2024-11-02T12:11:11.184Z | 2024-11-03T14:20:40.204Z |
5438072 | 5438072 | 20241030161832_psvXU | NZ003V | 2024-11-01T12:10:55.952Z | 2024-11-03T14:22:41.453Z |
5437942 | 5437942 | 20241030160434_EFj9t | NZ003V | 2024-11-01T12:10:44.821Z | 2024-11-03T14:22:41.018Z |
5437756 | 5437756 | 20241030153935_3f3Sx | NZ003V | 2024-11-01T12:10:17.273Z | 2024-11-03T14:22:40.478Z |
5437707 | 5437707 | 20241030153718_NsIZJ | NZ003V | 2024-11-01T12:10:13.908Z | 2024-11-03T14:22:40.370Z |
5437703 | 5437703 | 20241030153717_QRTrv | NZ003V | 2024-11-01T12:10:13.094Z | 2024-11-03T14:22:40.331Z |
5437690 | 5437690 | 20241030153540_LwsOr | NZ003V | 2024-11-01T12:10:12.141Z | 2024-11-03T14:22:40.306Z |
5437510 | 5437510 | 20241030151624_uR1Nl | NZ003V | 2024-11-01T12:09:56.015Z | 2024-11-03T14:22:39.804Z |
5437428 | 5437428 | 20241030150641_m5JBq | NZ003V | 2024-11-01T12:09:34.964Z | 2024-11-03T14:22:39.580Z |
5437425 | 5437425 | 20241030150632_hHx71 | NZ003V | 2024-11-01T12:09:34.682Z | 2024-11-03T14:22:39.568Z |
5437261 | 5437261 | 20241030144859_RgHt4 | NZ003V | 2024-11-01T12:09:18.525Z | 2024-11-03T14:22:38.950Z |
5437207 | 5437207 | 20241030144231_yst8D | NZ003V | 2024-11-01T12:09:14.396Z | 2024-11-03T14:22:38.879Z |
5437139 | 5437139 | 20241030143200_5It3R | NZ003V | 2024-11-01T12:09:08.443Z | 2024-11-03T14:22:38.703Z |
5437121 | 5437121 | 20241030143018_6hVRb | NZ003V | 2024-11-01T12:08:58.997Z | 2024-11-03T14:22:38.632Z |
5437063 | 5437063 | 20241030142429_D8gEw | NZ003V | 2024-11-01T12:08:49.207Z | 2024-11-03T14:22:38.479Z |
5437020 | 5437020 | 20241030142100_EFkSy | NZ003V | 2024-11-01T12:08:44.784Z | 2024-11-03T14:22:38.353Z |
5436954 | 5436954 | 20241030141101_4gKui | NZ003V | 2024-11-01T12:08:38.007Z | 2024-11-03T14:22:38.156Z |
5436728 | 5436728 | 20241030134155_2oITy | NZ003V | 2024-11-01T12:08:08.412Z | 2024-11-03T14:22:37.592Z |
5436715 | 5436715 | 20241030134114_1Ts75 | NZ003V | 2024-11-01T12:08:07.252Z | 2024-11-03T14:22:37.548Z |
5436688 | 5436688 | 20241030133735_9NUq3 | NZ003V | 2024-11-01T12:08:05.747Z | 2024-11-03T14:22:37.489Z |
5436490 | 5436490 | 20241030131248_pDQPs | NZ003V | 2024-11-01T12:07:45.701Z | 2024-11-03T14:22:36.830Z |
5436485 | 5436485 | 20241030131244_ii5GL | NZ003V | 2024-11-01T12:07:45.341Z | 2024-11-03T14:22:36.824Z |
5436372 | 5436372 | 20241030125818_eFAc0 | NZ003V | 2024-11-01T12:07:24.288Z | 2024-11-03T14:22:36.383Z |
5436345 | 5436345 | 20241030125638_3LoLq | NZ003V | 2024-11-01T12:07:22.073Z | 2024-11-03T14:22:36.337Z |
5436120 | 5436120 | 20241030123031_j2jkT | NZ003V | 2024-11-01T12:06:49.457Z | 2024-11-03T14:22:35.366Z |
5435606 | 5435606 | 20241030114421_Bdulh | NZ003V | 2024-11-01T12:05:39.146Z | 2024-11-03T14:22:33.314Z |
5435483 | 5435483 | 20241030113344_hHiN2 | NZ003V | 2024-11-01T12:05:14.857Z | 2024-11-03T14:22:32.859Z |
5435386 | 5435386 | 20241030112330_2dKCU | NZ003V | 2024-11-01T12:05:04.295Z | 2024-11-03T14:22:32.435Z |
5434755 | 5434755 | 20241030101045_pty2r | NZ003V | 2024-11-01T12:03:17.954Z | 2024-11-03T14:22:25.987Z |
5427730 | 5427730 | 20241028153807_rpsfv | NZ003V | 2024-10-31T12:13:53.143Z | 2024-11-03T14:24:48.488Z |
5427614 | 5427614 | 20241028152220_lrijr | NZ003V | 2024-10-31T12:13:41.044Z | 2024-11-03T14:24:48.119Z |
5427608 | 5427608 | 20241028152212_pTRSV | NZ003V | 2024-10-31T12:13:40.796Z | 2024-11-03T14:24:48.109Z |
5427514 | 5427514 | 20241028151258_2Qy3J | NZ003V | 2024-10-31T12:13:35.363Z | 2024-11-03T14:24:47.978Z |
5427213 | 5427213 | 20241028144459_s8IA1 | NZ003V | 2024-10-31T12:13:20.462Z | 2024-11-03T14:24:46.353Z |
5427122 | 5427122 | 20241028143203_JRYu6 | NZ003V | 2024-10-31T12:13:10.448Z | 2024-11-03T14:24:45.830Z |
5427060 | 5427060 | 20241028142717_HQ134 | NZ003V | 2024-10-31T12:13:02.469Z | 2024-11-03T14:24:45.728Z |
5427020 | 5427020 | 20241028142318_ee3fX | NZ003V | 2024-10-31T12:12:53.366Z | 2024-11-03T14:24:45.662Z |
5426948 | 5426948 | 20241028141438_shewT | NZ003V | 2024-10-31T12:12:42.310Z | 2024-11-03T14:24:45.471Z |
5426890 | 5426890 | 20241028140735_xX8SK | NZ003V | 2024-10-31T12:12:35.919Z | 2024-11-03T14:24:45.362Z |
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);