participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,200 rows where station_code = "NZ000Z" 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 |
---|---|---|---|---|---|
5501508 | 5501508 | 20241107134622_KSvtl | NZ000Z | 2024-11-09T14:09:56.440Z | 2024-11-09T14:16:27.734Z |
5501486 | 5501486 | 20241107132659_DIMdH | NZ000Z | 2024-11-09T14:09:54.212Z | 2024-11-09T14:16:27.724Z |
5501475 | 5501475 | 20241107132351_5AAAE | NZ000Z | 2024-11-09T14:09:52.965Z | 2024-11-09T14:16:27.718Z |
5501427 | 5501427 | 20241107130039_2g6aO | NZ000Z | 2024-11-09T14:09:34.242Z | 2024-11-09T14:16:27.694Z |
5500440 | 5500440 | 20241108154324_22e4g | NZ000Z | 2024-11-09T14:06:17.610Z | 2024-11-09T14:06:17.610Z |
5500398 | 5500398 | 20241108153451_Gs4YJ | NZ000Z | 2024-11-09T14:06:13.224Z | 2024-11-09T14:06:13.224Z |
5500276 | 5500276 | 20241108151025_EdYtV | NZ000Z | 2024-11-09T14:06:03.070Z | 2024-11-09T14:06:03.070Z |
5500260 | 5500260 | 20241108150911_WzkNj | NZ000Z | 2024-11-09T14:06:01.975Z | 2024-11-09T14:06:01.975Z |
5500239 | 5500239 | 20241108150700_b6BMP | NZ000Z | 2024-11-09T14:06:00.530Z | 2024-11-09T14:06:00.530Z |
5500225 | 5500225 | 20241108150600_ROyn7 | NZ000Z | 2024-11-09T14:05:59.655Z | 2024-11-09T14:05:59.655Z |
5500208 | 5500208 | 20241108150437_33TlA | NZ000Z | 2024-11-09T14:05:58.983Z | 2024-11-09T14:05:58.983Z |
5500173 | 5500173 | 20241108150125_Aqhm8 | NZ000Z | 2024-11-09T14:05:56.945Z | 2024-11-09T14:05:56.945Z |
5500059 | 5500059 | 20241108143552_aUqOr | NZ000Z | 2024-11-09T14:05:38.093Z | 2024-11-09T14:05:38.093Z |
5499885 | 5499885 | 20241108135406_jZuok | NZ000Z | 2024-11-09T14:05:08.427Z | 2024-11-09T14:05:08.427Z |
5499849 | 5499849 | 20241108134712_19Apg | NZ000Z | 2024-11-09T14:05:03.647Z | 2024-11-09T14:05:03.647Z |
5499829 | 5499829 | 20241108134318_tmlUP | NZ000Z | 2024-11-09T14:05:02.537Z | 2024-11-09T14:05:02.537Z |
5499789 | 5499789 | 20241108132853_IKPCb | NZ000Z | 2024-11-09T14:04:58.200Z | 2024-11-09T14:04:58.200Z |
5499703 | 5499703 | 20241108130456_XhvTR | NZ000Z | 2024-11-09T14:04:47.347Z | 2024-11-09T14:04:47.347Z |
5499408 | 5499408 | 20241108121429_2lyOf | NZ000Z | 2024-11-09T14:04:03.141Z | 2024-11-09T14:04:03.141Z |
5498928 | 5498928 | 20241108102848_h1Se3 | NZ000Z | 2024-11-09T14:02:48.090Z | 2024-11-09T14:02:48.090Z |
5498921 | 5498921 | 20241108102619_4PAVF | NZ000Z | 2024-11-09T14:02:47.150Z | 2024-11-09T14:02:47.150Z |
5498871 | 5498871 | 20241108101737_RI1Va | NZ000Z | 2024-11-09T14:02:40.472Z | 2024-11-09T14:02:40.472Z |
5498728 | 5498728 | 20241108094348_9jjW5 | NZ000Z | 2024-11-09T14:02:16.987Z | 2024-11-09T14:02:16.987Z |
5498462 | 5498462 | 20241108083719_Ss983 | NZ000Z | 2024-11-09T14:01:33.015Z | 2024-11-09T14:01:33.015Z |
5498418 | 5498418 | 20241108082916_Yg6he | NZ000Z | 2024-11-09T14:01:27.595Z | 2024-11-09T14:01:27.595Z |
5498396 | 5498396 | 20241108082537_9v8rF | NZ000Z | 2024-11-09T14:01:23.852Z | 2024-11-09T14:01:23.852Z |
5494049 | 5494049 | 20241107152259_WWIg8 | NZ000Z | 2024-11-08T14:05:17.941Z | 2024-11-09T14:16:27.824Z |
5493742 | 5493742 | 20241107131409_aLBXP | NZ000Z | 2024-11-08T14:04:33.817Z | 2024-11-09T14:16:27.710Z |
5493410 | 5493410 | 20241107120632_1cMz1 | NZ000Z | 2024-11-08T14:03:42.997Z | 2024-11-09T14:16:27.615Z |
5493402 | 5493402 | 20241107120514_BRvm3 | NZ000Z | 2024-11-08T14:03:42.061Z | 2024-11-09T14:16:27.613Z |
5493339 | 5493339 | 20241107115026_rg6ep | NZ000Z | 2024-11-08T14:03:34.808Z | 2024-11-09T14:16:27.592Z |
5493305 | 5493305 | 20241107114517_4cQPS | NZ000Z | 2024-11-08T14:03:30.971Z | 2024-11-09T14:16:27.583Z |
5493204 | 5493204 | 20241107111759_4Z2gg | NZ000Z | 2024-11-08T14:03:09.659Z | 2024-11-09T14:16:27.560Z |
5493087 | 5493087 | 20241107105247_Axddp | NZ000Z | 2024-11-08T14:02:50.110Z | 2024-11-09T14:16:27.529Z |
5492972 | 5492972 | 20241107102822_c3VIY | NZ000Z | 2024-11-08T14:02:39.270Z | 2024-11-09T14:16:27.499Z |
5492918 | 5492918 | 20241107102021_13y6s | NZ000Z | 2024-11-08T14:02:33.899Z | 2024-11-09T14:16:27.487Z |
5492798 | 5492798 | 20241107095653_3KCkj | NZ000Z | 2024-11-08T14:02:06.911Z | 2024-11-09T14:16:27.456Z |
5492646 | 5492646 | 20241107092353_4iMMk | NZ000Z | 2024-11-08T14:01:44.571Z | 2024-11-09T14:16:27.419Z |
5492410 | 5492410 | 20241107083004_hKKJx | NZ000Z | 2024-11-08T14:01:01.253Z | 2024-11-09T14:16:27.366Z |
5492336 | 5492336 | 20241107081012_5Hj03 | NZ000Z | 2024-11-08T14:00:48.963Z | 2024-11-09T14:16:27.347Z |
5488272 | 5488272 | 20241105124622_Zk3OZ | NZ000Z | 2024-11-07T14:09:22.789Z | 2024-11-09T14:19:23.707Z |
5487383 | 5487383 | 20241106155048_SIbvB | NZ000Z | 2024-11-07T14:05:39.982Z | 2024-11-09T14:17:20.583Z |
5480722 | 5480722 | 20241105151057_YASO3 | NZ000Z | 2024-11-06T14:06:25.011Z | 2024-11-09T14:19:29.342Z |
5480701 | 5480701 | 20241105145444_MgCPc | NZ000Z | 2024-11-06T14:06:22.316Z | 2024-11-09T14:19:28.977Z |
5480678 | 5480678 | 20241105144628_ZoRX1 | NZ000Z | 2024-11-06T14:06:19.648Z | 2024-11-09T14:19:28.551Z |
5480650 | 5480650 | 20241105142959_E0rj7 | NZ000Z | 2024-11-06T14:06:11.546Z | 2024-11-09T14:19:27.664Z |
5480610 | 5480610 | 20241105141741_1ptq3 | NZ000Z | 2024-11-06T14:06:03.254Z | 2024-11-09T14:19:27.012Z |
5480574 | 5480574 | 20241105140050_T4uB6 | NZ000Z | 2024-11-06T14:05:57.838Z | 2024-11-09T14:19:26.002Z |
5480434 | 5480434 | 20241105125922_G9fp2 | NZ000Z | 2024-11-06T14:05:38.580Z | 2024-11-09T14:19:24.151Z |
5480414 | 5480414 | 20241105124754_q5yXu | NZ000Z | 2024-11-06T14:05:29.440Z | 2024-11-09T14:19:23.881Z |
5480394 | 5480394 | 20241105124624_t8XhF | NZ000Z | 2024-11-06T14:05:26.204Z | 2024-11-09T14:19:23.738Z |
5480269 | 5480269 | 20241105121211_i8W0u | NZ000Z | 2024-11-06T14:05:06.049Z | 2024-11-09T14:19:21.593Z |
5480245 | 5480245 | 20241105120939_MEFsB | NZ000Z | 2024-11-06T14:05:03.102Z | 2024-11-09T14:19:21.215Z |
5480135 | 5480135 | 20241105114605_YIaCr | NZ000Z | 2024-11-06T14:04:36.314Z | 2024-11-09T14:19:18.768Z |
5479997 | 5479997 | 20241105111437_nMwok | NZ000Z | 2024-11-06T14:04:17.248Z | 2024-11-09T14:19:14.874Z |
5473800 | 5473800 | 20241103150600_1Y2Ti | NZ000Z | 2024-11-05T14:09:45.415Z | 2024-11-09T14:21:41.055Z |
5473778 | 5473778 | 20241103150229_07qUZ | NZ000Z | 2024-11-05T14:09:43.755Z | 2024-11-09T14:21:40.978Z |
5473708 | 5473708 | 20241103145250_EP0gV | NZ000Z | 2024-11-05T14:09:29.590Z | 2024-11-09T14:21:40.517Z |
5473601 | 5473601 | 20241103143839_1QLLe | NZ000Z | 2024-11-05T14:09:11.848Z | 2024-11-09T14:21:39.898Z |
5473462 | 5473462 | 20241103142005_kH4pP | NZ000Z | 2024-11-05T14:08:57.941Z | 2024-11-09T14:21:38.998Z |
5473425 | 5473425 | 20241103141501_dTWXR | NZ000Z | 2024-11-05T14:08:55.362Z | 2024-11-09T14:21:38.825Z |
5473393 | 5473393 | 20241103141042_ex2au | NZ000Z | 2024-11-05T14:08:53.080Z | 2024-11-09T14:21:38.707Z |
5473341 | 5473341 | 20241103140412_33LuM | NZ000Z | 2024-11-05T14:08:49.108Z | 2024-11-09T14:21:37.928Z |
5473280 | 5473280 | 20241103135324_EIyrf | NZ000Z | 2024-11-05T14:08:44.880Z | 2024-11-09T14:21:37.568Z |
5473214 | 5473214 | 20241103134337_rMnc0 | NZ000Z | 2024-11-05T14:08:36.489Z | 2024-11-09T14:21:37.272Z |
5473148 | 5473148 | 20241103133518_wp8bl | NZ000Z | 2024-11-05T14:08:24.787Z | 2024-11-09T14:21:37.111Z |
5472899 | 5472899 | 20241103125746_PN1cC | NZ000Z | 2024-11-05T14:07:50.853Z | 2024-11-09T14:21:35.619Z |
5472853 | 5472853 | 20241103125316_baRAy | NZ000Z | 2024-11-05T14:07:48.085Z | 2024-11-09T14:21:35.370Z |
5472806 | 5472806 | 20241103124546_qKF3I | NZ000Z | 2024-11-05T14:07:44.045Z | 2024-11-09T14:21:34.997Z |
5472715 | 5472715 | 20241103122757_byq22 | NZ000Z | 2024-11-05T14:07:36.174Z | 2024-11-09T14:21:34.220Z |
5472562 | 5472562 | 20241104154548_kIght | NZ000Z | 2024-11-05T14:06:15.636Z | 2024-11-09T14:20:42.158Z |
5472473 | 5472473 | 20241104151444_0zQRe | NZ000Z | 2024-11-05T14:05:52.895Z | 2024-11-09T14:20:40.731Z |
5472341 | 5472341 | 20241104144328_GKE3U | NZ000Z | 2024-11-05T14:05:40.031Z | 2024-11-09T14:20:39.315Z |
5472221 | 5472221 | 20241104140731_GqgcQ | NZ000Z | 2024-11-05T14:05:28.264Z | 2024-11-09T14:20:37.531Z |
5472030 | 5472030 | 20241104132911_DPzY0 | NZ000Z | 2024-11-05T14:05:00.601Z | 2024-11-09T14:20:35.946Z |
5471985 | 5471985 | 20241104131229_NzkqP | NZ000Z | 2024-11-05T14:04:54.800Z | 2024-11-09T14:20:35.343Z |
5471965 | 5471965 | 20241104131035_9wW8Z | NZ000Z | 2024-11-05T14:04:53.797Z | 2024-11-09T14:20:35.271Z |
5471894 | 5471894 | 20241104125739_K9pSt | NZ000Z | 2024-11-05T14:04:46.825Z | 2024-11-09T14:20:34.602Z |
5471844 | 5471844 | 20241104124958_ZlGub | NZ000Z | 2024-11-05T14:04:41.907Z | 2024-11-09T14:20:34.177Z |
5471827 | 5471827 | 20241104124920_Sd9zK | NZ000Z | 2024-11-05T14:04:40.967Z | 2024-11-09T14:20:34.095Z |
5471796 | 5471796 | 20241104124057_h1wGM | NZ000Z | 2024-11-05T14:04:37.531Z | 2024-11-09T14:20:33.764Z |
5471543 | 5471543 | 20241104120233_Ejb5f | NZ000Z | 2024-11-05T14:03:55.248Z | 2024-11-09T14:20:31.764Z |
5471335 | 5471335 | 20241104112756_Rzfvh | NZ000Z | 2024-11-05T14:03:29.157Z | 2024-11-09T14:20:30.344Z |
5471222 | 5471222 | 20241104110547_CVJVj | NZ000Z | 2024-11-05T14:03:09.722Z | 2024-11-09T14:20:29.341Z |
5470947 | 5470947 | 20241104101217_DvDfw | NZ000Z | 2024-11-05T14:02:21.282Z | 2024-11-09T14:20:26.557Z |
5470831 | 5470831 | 20241104095433_t4ORR | NZ000Z | 2024-11-05T14:01:59.090Z | 2024-11-09T14:20:25.341Z |
5470811 | 5470811 | 20241104095223_Oouam | NZ000Z | 2024-11-05T14:01:55.799Z | 2024-11-09T14:20:25.289Z |
5470769 | 5470769 | 20241104094647_bbE6f | NZ000Z | 2024-11-05T14:01:48.293Z | 2024-11-09T14:20:24.857Z |
5470596 | 5470596 | 20241104085723_1dhT4 | NZ000Z | 2024-11-05T14:01:11.916Z | 2024-11-09T14:20:21.742Z |
5470562 | 5470562 | 20241104084833_xnhmz | NZ000Z | 2024-11-05T14:01:05.976Z | 2024-11-09T14:20:21.396Z |
5464898 | 5464898 | 20241103094918_54d1P | NZ000Z | 2024-11-04T14:02:07.818Z | 2024-11-09T14:21:29.524Z |
5464664 | 5464664 | 20241103084424_uJeQK | NZ000Z | 2024-11-04T14:01:17.322Z | 2024-11-09T14:21:27.548Z |
5464572 | 5464572 | 20241103082047_t0MCt | NZ000Z | 2024-11-04T14:00:59.328Z | 2024-11-09T14:21:26.658Z |
5461000 | 5461000 | 20241101153200_ldeOU | NZ000Z | 2024-11-03T14:14:38.420Z | 2024-11-09T14:23:26.293Z |
5460898 | 5460898 | 20241101151822_B4RC4 | NZ000Z | 2024-11-03T14:14:33.454Z | 2024-11-09T14:23:25.820Z |
5460821 | 5460821 | 20241101150908_TECO7 | NZ000Z | 2024-11-03T14:14:29.900Z | 2024-11-09T14:23:25.625Z |
5460813 | 5460813 | 20241101150905_g8CCv | NZ000Z | 2024-11-03T14:14:29.419Z | 2024-11-09T14:23:25.624Z |
5460784 | 5460784 | 20241101150300_xA2W6 | NZ000Z | 2024-11-03T14:14:25.421Z | 2024-11-09T14:23:25.510Z |
5460673 | 5460673 | 20241101144726_dPXDx | NZ000Z | 2024-11-03T14:14:12.824Z | 2024-11-09T14:23:24.733Z |
5460609 | 5460609 | 20241101143823_fAcqh | NZ000Z | 2024-11-03T14:14:03.411Z | 2024-11-09T14:23:24.655Z |
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);