participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,857 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 |
---|---|---|---|---|---|
5460154 | 5460154 | 20241101125837_l3XNi | NZ003Z | 2024-11-03T14:13:24.949Z | 2024-11-03T14:19:33.488Z |
5460093 | 5460093 | 20241101124238_9R1uA | NZ003Z | 2024-11-03T14:13:20.743Z | 2024-11-03T14:19:33.475Z |
5459834 | 5459834 | 20241101115913_d1EWh | NZ003Z | 2024-11-03T14:12:38.842Z | 2024-11-03T14:19:33.426Z |
5459523 | 5459523 | 20241101111234_3iDqz | NZ003Z | 2024-11-03T14:12:11.661Z | 2024-11-03T14:19:33.361Z |
5458056 | 5458056 | 20241102160428_lXasS | NZ003Z | 2024-11-03T14:08:37.717Z | 2024-11-03T14:08:37.717Z |
5458043 | 5458043 | 20241102160239_GvPV4 | NZ003Z | 2024-11-03T14:08:36.236Z | 2024-11-03T14:08:36.236Z |
5458031 | 5458031 | 20241102160140_8E8Qi | NZ003Z | 2024-11-03T14:08:35.248Z | 2024-11-03T14:08:35.248Z |
5457905 | 5457905 | 20241102153818_aXX27 | NZ003Z | 2024-11-03T14:08:19.861Z | 2024-11-03T14:08:19.861Z |
5457876 | 5457876 | 20241102153407_OZIIB | NZ003Z | 2024-11-03T14:08:17.567Z | 2024-11-03T14:08:17.567Z |
5457873 | 5457873 | 20241102153155_2JvuR | NZ003Z | 2024-11-03T14:08:17.251Z | 2024-11-03T14:08:17.251Z |
5457830 | 5457830 | 20241102152739_WOnBh | NZ003Z | 2024-11-03T14:08:14.810Z | 2024-11-03T14:08:14.810Z |
5457820 | 5457820 | 20241102152610_ODIMJ | NZ003Z | 2024-11-03T14:08:14.055Z | 2024-11-03T14:08:14.055Z |
5457786 | 5457786 | 20241102152337_CzSN1 | NZ003Z | 2024-11-03T14:08:10.871Z | 2024-11-03T14:08:10.871Z |
5457739 | 5457739 | 20241102151710_MMdus | NZ003Z | 2024-11-03T14:07:55.670Z | 2024-11-03T14:07:55.670Z |
5457702 | 5457702 | 20241102151214_Z0Zw2 | NZ003Z | 2024-11-03T14:07:52.524Z | 2024-11-03T14:07:52.524Z |
5457677 | 5457677 | 20241102150806_h2g2K | NZ003Z | 2024-11-03T14:07:50.012Z | 2024-11-03T14:07:50.012Z |
5457667 | 5457667 | 20241102150619_cNpPo | NZ003Z | 2024-11-03T14:07:48.078Z | 2024-11-03T14:07:48.078Z |
5457639 | 5457639 | 20241102145919_X7UUh | NZ003Z | 2024-11-03T14:07:45.884Z | 2024-11-03T14:07:45.884Z |
5457630 | 5457630 | 20241102145519_FRWRN | NZ003Z | 2024-11-03T14:07:44.969Z | 2024-11-03T14:07:44.969Z |
5457589 | 5457589 | 20241102145037_sm6Rm | NZ003Z | 2024-11-03T14:07:42.068Z | 2024-11-03T14:07:42.068Z |
5457503 | 5457503 | 20241102143900_mjGEZ | NZ003Z | 2024-11-03T14:07:34.585Z | 2024-11-03T14:07:34.585Z |
5457468 | 5457468 | 20241102143351_TrhXp | NZ003Z | 2024-11-03T14:07:23.224Z | 2024-11-03T14:07:23.224Z |
5457410 | 5457410 | 20241102142500_a8LzN | NZ003Z | 2024-11-03T14:07:16.125Z | 2024-11-03T14:07:16.125Z |
5457391 | 5457391 | 20241102142258_jjoS1 | NZ003Z | 2024-11-03T14:07:12.854Z | 2024-11-03T14:07:12.854Z |
5457371 | 5457371 | 20241102142005_i1Taw | NZ003Z | 2024-11-03T14:07:11.013Z | 2024-11-03T14:07:11.013Z |
5457307 | 5457307 | 20241102140749_upzBF | NZ003Z | 2024-11-03T14:07:05.629Z | 2024-11-03T14:07:05.629Z |
5457301 | 5457301 | 20241102140725_x9DGt | NZ003Z | 2024-11-03T14:07:04.829Z | 2024-11-03T14:07:04.829Z |
5457210 | 5457210 | 20241102134941_bDynd | NZ003Z | 2024-11-03T14:06:51.687Z | 2024-11-03T14:06:51.687Z |
5457173 | 5457173 | 20241102134214_R1zUy | NZ003Z | 2024-11-03T14:06:41.867Z | 2024-11-03T14:06:41.867Z |
5457115 | 5457115 | 20241102133310_aK4fz | NZ003Z | 2024-11-03T14:06:35.516Z | 2024-11-03T14:06:35.516Z |
5457041 | 5457041 | 20241102132126_Vdzu2 | NZ003Z | 2024-11-03T14:06:26.183Z | 2024-11-03T14:06:26.183Z |
5457035 | 5457035 | 20241102131543_728Wl | NZ003Z | 2024-11-03T14:06:24.810Z | 2024-11-03T14:06:24.810Z |
5457019 | 5457019 | 20241102131343_3UFp8 | NZ003Z | 2024-11-03T14:06:22.879Z | 2024-11-03T14:06:22.879Z |
5456986 | 5456986 | 20241102130557_tz55D | NZ003Z | 2024-11-03T14:06:18.894Z | 2024-11-03T14:06:18.894Z |
5456965 | 5456965 | 20241102130246_U7qz2 | NZ003Z | 2024-11-03T14:06:12.459Z | 2024-11-03T14:06:12.459Z |
5456959 | 5456959 | 20241102130242_iGLhM | NZ003Z | 2024-11-03T14:06:09.436Z | 2024-11-03T14:06:09.436Z |
5456755 | 5456755 | 20241102121636_NHLly | NZ003Z | 2024-11-03T14:05:37.523Z | 2024-11-03T14:05:37.523Z |
5456688 | 5456688 | 20241102120433_6bsW9 | NZ003Z | 2024-11-03T14:05:25.033Z | 2024-11-03T14:05:25.033Z |
5456681 | 5456681 | 20241102120333_tRVpk | NZ003Z | 2024-11-03T14:05:22.461Z | 2024-11-03T14:05:22.461Z |
5456605 | 5456605 | 20241102114944_M2zdE | NZ003Z | 2024-11-03T14:05:05.218Z | 2024-11-03T14:05:05.218Z |
5456585 | 5456585 | 20241102114724_F7FY6 | NZ003Z | 2024-11-03T14:05:02.724Z | 2024-11-03T14:05:02.724Z |
5456571 | 5456571 | 20241102114546_m3mXe | NZ003Z | 2024-11-03T14:05:00.676Z | 2024-11-03T14:05:00.676Z |
5456563 | 5456563 | 20241102114533_zu0gI | NZ003Z | 2024-11-03T14:04:59.599Z | 2024-11-03T14:04:59.599Z |
5456534 | 5456534 | 20241102113951_2CLCV | NZ003Z | 2024-11-03T14:04:56.384Z | 2024-11-03T14:04:56.384Z |
5456467 | 5456467 | 20241102112910_TSK8T | NZ003Z | 2024-11-03T14:04:45.937Z | 2024-11-03T14:04:45.937Z |
5449575 | 5449575 | 20241031155626_a254H | NZ003Z | 2024-11-02T12:13:08.271Z | 2024-11-03T14:20:55.142Z |
5449496 | 5449496 | 20241031154445_RSpqf | NZ003Z | 2024-11-02T12:13:01.244Z | 2024-11-03T14:20:53.891Z |
5449478 | 5449478 | 20241031154128_oBXtX | NZ003Z | 2024-11-02T12:12:59.231Z | 2024-11-03T14:20:53.450Z |
5449420 | 5449420 | 20241031153509_3DYPO | NZ003Z | 2024-11-02T12:12:51.649Z | 2024-11-03T14:20:52.751Z |
5449364 | 5449364 | 20241031152519_HAB33 | NZ003Z | 2024-11-02T12:12:45.460Z | 2024-11-03T14:20:51.975Z |
5449296 | 5449296 | 20241031151738_Kp2mG | NZ003Z | 2024-11-02T12:12:27.283Z | 2024-11-03T14:20:50.923Z |
5449261 | 5449261 | 20241031151257_MmL3u | NZ003Z | 2024-11-02T12:12:21.213Z | 2024-11-03T14:20:50.055Z |
5449061 | 5449061 | 20241031144749_DFAqI | NZ003Z | 2024-11-02T12:12:01.162Z | 2024-11-03T14:20:48.060Z |
5448907 | 5448907 | 20241031142957_vtzk5 | NZ003Z | 2024-11-02T12:11:43.316Z | 2024-11-03T14:20:44.621Z |
5448870 | 5448870 | 20241031142630_I1Jes | NZ003Z | 2024-11-02T12:11:37.385Z | 2024-11-03T14:20:43.785Z |
5448840 | 5448840 | 20241031142243_b2ZBH | NZ003Z | 2024-11-02T12:11:32.761Z | 2024-11-03T14:20:43.276Z |
5448836 | 5448836 | 20241031142231_WAl6E | NZ003Z | 2024-11-02T12:11:32.392Z | 2024-11-03T14:20:43.257Z |
5448821 | 5448821 | 20241031142005_JJsEX | NZ003Z | 2024-11-02T12:11:31.054Z | 2024-11-03T14:20:43.019Z |
5448802 | 5448802 | 20241031141720_e22sa | NZ003Z | 2024-11-02T12:11:28.852Z | 2024-11-03T14:20:42.423Z |
5448475 | 5448475 | 20241031133546_qIn7W | NZ003Z | 2024-11-02T12:10:49.203Z | 2024-11-03T14:20:38.366Z |
5448190 | 5448190 | 20241031125808_SPUu3 | NZ003Z | 2024-11-02T12:10:12.584Z | 2024-11-03T14:20:34.035Z |
5438073 | 5438073 | 20241030161832_psvXU | NZ003Z | 2024-11-01T12:10:55.952Z | 2024-11-03T14:22:41.453Z |
5437943 | 5437943 | 20241030160434_EFj9t | NZ003Z | 2024-11-01T12:10:44.821Z | 2024-11-03T14:22:41.018Z |
5437757 | 5437757 | 20241030153935_3f3Sx | NZ003Z | 2024-11-01T12:10:17.273Z | 2024-11-03T14:22:40.478Z |
5437708 | 5437708 | 20241030153718_NsIZJ | NZ003Z | 2024-11-01T12:10:13.908Z | 2024-11-03T14:22:40.370Z |
5437704 | 5437704 | 20241030153717_QRTrv | NZ003Z | 2024-11-01T12:10:13.094Z | 2024-11-03T14:22:40.331Z |
5437511 | 5437511 | 20241030151624_uR1Nl | NZ003Z | 2024-11-01T12:09:56.015Z | 2024-11-03T14:22:39.804Z |
5437489 | 5437489 | 20241030151321_khwUs | NZ003Z | 2024-11-01T12:09:52.613Z | 2024-11-03T14:22:39.727Z |
5437440 | 5437440 | 20241030150856_iwQpp | NZ003Z | 2024-11-01T12:09:37.398Z | 2024-11-03T14:22:39.607Z |
5437429 | 5437429 | 20241030150641_m5JBq | NZ003Z | 2024-11-01T12:09:34.964Z | 2024-11-03T14:22:39.580Z |
5437421 | 5437421 | 20241030150547_V6k93 | NZ003Z | 2024-11-01T12:09:34.129Z | 2024-11-03T14:22:39.510Z |
5437410 | 5437410 | 20241030150406_P0Y24 | NZ003Z | 2024-11-01T12:09:33.129Z | 2024-11-03T14:22:39.494Z |
5437301 | 5437301 | 20241030145129_QJ6Nr | NZ003Z | 2024-11-01T12:09:21.880Z | 2024-11-03T14:22:39.095Z |
5437277 | 5437277 | 20241030144915_erDoP | NZ003Z | 2024-11-01T12:09:19.675Z | 2024-11-03T14:22:39.020Z |
5437262 | 5437262 | 20241030144859_RgHt4 | NZ003Z | 2024-11-01T12:09:18.525Z | 2024-11-03T14:22:38.950Z |
5437208 | 5437208 | 20241030144231_yst8D | NZ003Z | 2024-11-01T12:09:14.396Z | 2024-11-03T14:22:38.879Z |
5437189 | 5437189 | 20241030143930_ixAX7 | NZ003Z | 2024-11-01T12:09:13.061Z | 2024-11-03T14:22:38.849Z |
5437064 | 5437064 | 20241030142429_D8gEw | NZ003Z | 2024-11-01T12:08:49.207Z | 2024-11-03T14:22:38.479Z |
5436860 | 5436860 | 20241030135731_d7Za3 | NZ003Z | 2024-11-01T12:08:29.171Z | 2024-11-03T14:22:37.895Z |
5436571 | 5436571 | 20241030132216_pzc3A | NZ003Z | 2024-11-01T12:07:53.313Z | 2024-11-03T14:22:37.079Z |
5436373 | 5436373 | 20241030125818_eFAc0 | NZ003Z | 2024-11-01T12:07:24.288Z | 2024-11-03T14:22:36.383Z |
5436346 | 5436346 | 20241030125638_3LoLq | NZ003Z | 2024-11-01T12:07:22.073Z | 2024-11-03T14:22:36.337Z |
5436313 | 5436313 | 20241030125012_sLoX8 | NZ003Z | 2024-11-01T12:07:17.138Z | 2024-11-03T14:22:36.241Z |
5436297 | 5436297 | 20241030124718_5L7tD | NZ003Z | 2024-11-01T12:07:14.848Z | 2024-11-03T14:22:36.161Z |
5436214 | 5436214 | 20241030123836_OBZbn | NZ003Z | 2024-11-01T12:07:06.910Z | 2024-11-03T14:22:35.864Z |
5435890 | 5435890 | 20241030120800_yzX3b | NZ003Z | 2024-11-01T12:06:18.906Z | 2024-11-03T14:22:34.424Z |
5435607 | 5435607 | 20241030114421_Bdulh | NZ003Z | 2024-11-01T12:05:39.146Z | 2024-11-03T14:22:33.314Z |
5435387 | 5435387 | 20241030112330_2dKCU | NZ003Z | 2024-11-01T12:05:04.295Z | 2024-11-03T14:22:32.435Z |
5434756 | 5434756 | 20241030101045_pty2r | NZ003Z | 2024-11-01T12:03:17.968Z | 2024-11-03T14:22:25.987Z |
5427731 | 5427731 | 20241028153807_rpsfv | NZ003Z | 2024-10-31T12:13:53.143Z | 2024-11-03T14:24:48.488Z |
5427631 | 5427631 | 20241028152412_lSdlv | NZ003Z | 2024-10-31T12:13:41.576Z | 2024-11-03T14:24:48.127Z |
5427615 | 5427615 | 20241028152220_lrijr | NZ003Z | 2024-10-31T12:13:41.044Z | 2024-11-03T14:24:48.119Z |
5427590 | 5427590 | 20241028152002_UL3U7 | NZ003Z | 2024-10-31T12:13:39.543Z | 2024-11-03T14:24:48.070Z |
5427568 | 5427568 | 20241028151744_Xh6Gb | NZ003Z | 2024-10-31T12:13:38.534Z | 2024-11-03T14:24:48.044Z |
5427550 | 5427550 | 20241028151549_uMtic | NZ003Z | 2024-10-31T12:13:37.419Z | 2024-11-03T14:24:47.998Z |
5427545 | 5427545 | 20241028151546_ZUYoH | NZ003Z | 2024-10-31T12:13:37.367Z | 2024-11-03T14:24:47.995Z |
5427515 | 5427515 | 20241028151258_2Qy3J | NZ003Z | 2024-10-31T12:13:35.363Z | 2024-11-03T14:24:47.978Z |
5427356 | 5427356 | 20241028145942_m0N5B | NZ003Z | 2024-10-31T12:13:28.397Z | 2024-11-03T14:24:47.577Z |
5427214 | 5427214 | 20241028144459_s8IA1 | NZ003Z | 2024-10-31T12:13:20.462Z | 2024-11-03T14:24:46.353Z |
5427123 | 5427123 | 20241028143203_JRYu6 | NZ003Z | 2024-10-31T12:13:10.448Z | 2024-11-03T14:24:45.830Z |
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);