participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
828 rows where station_code = "NZ001S" 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 |
---|---|---|---|---|---|
5520396 | 5520396 | 20241111153507_qrpT9 | NZ001S | 2024-11-12T14:06:15.585Z | 2024-11-12T14:06:15.585Z |
5520379 | 5520379 | 20241111153227_ASotO | NZ001S | 2024-11-12T14:06:14.489Z | 2024-11-12T14:06:14.489Z |
5520021 | 5520021 | 20241111142124_KaSDz | NZ001S | 2024-11-12T14:05:29.022Z | 2024-11-12T14:05:29.022Z |
5519986 | 5519986 | 20241111141115_R2WrB | NZ001S | 2024-11-12T14:05:25.452Z | 2024-11-12T14:05:25.452Z |
5519942 | 5519942 | 20241111140153_Q89JE | NZ001S | 2024-11-12T14:05:21.554Z | 2024-11-12T14:05:21.554Z |
5519920 | 5519920 | 20241111135445_aq81s | NZ001S | 2024-11-12T14:05:19.526Z | 2024-11-12T14:05:19.526Z |
5519856 | 5519856 | 20241111133525_l6MuI | NZ001S | 2024-11-12T14:05:11.749Z | 2024-11-12T14:05:11.749Z |
5519807 | 5519807 | 20241111130914_aILnI | NZ001S | 2024-11-12T14:05:03.966Z | 2024-11-12T14:05:03.966Z |
5519702 | 5519702 | 20241111123515_5hTgQ | NZ001S | 2024-11-12T14:04:47.960Z | 2024-11-12T14:04:47.960Z |
5519510 | 5519510 | 20241111114233_10yft | NZ001S | 2024-11-12T14:04:19.566Z | 2024-11-12T14:04:19.566Z |
5519428 | 5519428 | 20241111112139_9mXEi | NZ001S | 2024-11-12T14:03:59.402Z | 2024-11-12T14:03:59.402Z |
5519184 | 5519184 | 20241111103545_XJquG | NZ001S | 2024-11-12T14:03:16.963Z | 2024-11-12T14:03:16.963Z |
5514276 | 5514276 | 20241110152247_hN5y2 | NZ001S | 2024-11-11T14:06:25.411Z | 2024-11-12T14:18:07.006Z |
5514112 | 5514112 | 20241110143117_W3DZk | NZ001S | 2024-11-11T14:06:13.286Z | 2024-11-12T14:18:06.873Z |
5500430 | 5500430 | 20241108154211_Qsq2K | NZ001S | 2024-11-09T14:06:16.385Z | 2024-11-12T14:22:49.500Z |
5500356 | 5500356 | 20241108152716_Cev36 | NZ001S | 2024-11-09T14:06:10.294Z | 2024-11-12T14:22:48.593Z |
5500181 | 5500181 | 20241108150158_fpfuz | NZ001S | 2024-11-09T14:05:57.571Z | 2024-11-12T14:22:46.052Z |
5500117 | 5500117 | 20241108144918_0y91A | NZ001S | 2024-11-09T14:05:44.106Z | 2024-11-12T14:22:45.361Z |
5499809 | 5499809 | 20241108133821_BAy7C | NZ001S | 2024-11-09T14:04:59.764Z | 2024-11-12T14:22:40.034Z |
5499794 | 5499794 | 20241108133225_cO0ki | NZ001S | 2024-11-09T14:04:58.537Z | 2024-11-12T14:22:39.851Z |
5499749 | 5499749 | 20241108131642_UiJIk | NZ001S | 2024-11-09T14:04:53.683Z | 2024-11-12T14:22:38.810Z |
5499731 | 5499731 | 20241108131500_3lHF2 | NZ001S | 2024-11-09T14:04:51.414Z | 2024-11-12T14:22:38.437Z |
5499708 | 5499708 | 20241108130525_F3eXJ | NZ001S | 2024-11-09T14:04:47.667Z | 2024-11-12T14:22:38.051Z |
5499584 | 5499584 | 20241108123926_2akGy | NZ001S | 2024-11-09T14:04:22.833Z | 2024-11-12T14:22:35.614Z |
5499557 | 5499557 | 20241108123652_JVpA8 | NZ001S | 2024-11-09T14:04:18.888Z | 2024-11-12T14:22:34.804Z |
5499382 | 5499382 | 20241108120921_bKimb | NZ001S | 2024-11-09T14:03:55.715Z | 2024-11-12T14:22:31.769Z |
5499356 | 5499356 | 20241108120420_WvJDr | NZ001S | 2024-11-09T14:03:50.103Z | 2024-11-12T14:22:31.510Z |
5499292 | 5499292 | 20241108115152_kkYj6 | NZ001S | 2024-11-09T14:03:42.211Z | 2024-11-12T14:22:30.426Z |
5499237 | 5499237 | 20241108114214_noYsZ | NZ001S | 2024-11-09T14:03:36.094Z | 2024-11-12T14:22:29.572Z |
5499168 | 5499168 | 20241108112218_GTogO | NZ001S | 2024-11-09T14:03:28.359Z | 2024-11-12T14:22:28.297Z |
5499142 | 5499142 | 20241108111749_ZTI7Q | NZ001S | 2024-11-09T14:03:25.158Z | 2024-11-12T14:22:28.087Z |
5498911 | 5498911 | 20241108102456_elzl2 | NZ001S | 2024-11-09T14:02:46.137Z | 2024-11-12T14:22:23.635Z |
5498681 | 5498681 | 20241108093624_mWOyR | NZ001S | 2024-11-09T14:02:11.010Z | 2024-11-12T14:22:18.534Z |
5494068 | 5494068 | 20241107152718_633ZG | NZ001S | 2024-11-08T14:05:19.808Z | 2024-11-12T14:24:23.847Z |
5494061 | 5494061 | 20241107152605_absGg | NZ001S | 2024-11-08T14:05:19.299Z | 2024-11-12T14:24:23.797Z |
5494050 | 5494050 | 20241107152259_WWIg8 | NZ001S | 2024-11-08T14:05:17.941Z | 2024-11-12T14:24:23.422Z |
5494035 | 5494035 | 20241107151729_NxERD | NZ001S | 2024-11-08T14:05:17.071Z | 2024-11-12T14:24:23.183Z |
5494025 | 5494025 | 20241107151435_LoSWl | NZ001S | 2024-11-08T14:05:16.403Z | 2024-11-12T14:24:23.152Z |
5493976 | 5493976 | 20241107145944_J7iDS | NZ001S | 2024-11-08T14:05:10.193Z | 2024-11-12T14:24:22.107Z |
5486883 | 5486883 | 20241106135131_DcwlZ | NZ001S | 2024-11-07T14:04:19.232Z | 2024-11-12T14:25:34.338Z |
5486308 | 5486308 | 20241106103731_u3T6Z | NZ001S | 2024-11-07T14:02:30.381Z | 2024-11-12T14:25:28.663Z |
5481229 | 5481229 | 20241104155215_gX7Kj | NZ001S | 2024-11-06T14:09:46.458Z | 2024-11-12T14:27:09.970Z |
5480618 | 5480618 | 20241105141823_w1lh1 | NZ001S | 2024-11-06T14:06:03.848Z | 2024-11-12T14:26:33.457Z |
5480539 | 5480539 | 20241105134020_i1G3X | NZ001S | 2024-11-06T14:05:53.410Z | 2024-11-12T14:26:32.551Z |
5480505 | 5480505 | 20241105132434_p4bf2 | NZ001S | 2024-11-06T14:05:49.832Z | 2024-11-12T14:26:32.292Z |
5480375 | 5480375 | 20241105123738_EA9vH | NZ001S | 2024-11-06T14:05:22.580Z | 2024-11-12T14:26:31.190Z |
5480026 | 5480026 | 20241105111850_G8kQP | NZ001S | 2024-11-06T14:04:20.812Z | 2024-11-12T14:26:27.363Z |
5479897 | 5479897 | 20241105105713_lgrXI | NZ001S | 2024-11-06T14:03:51.145Z | 2024-11-12T14:26:26.778Z |
5479341 | 5479341 | 20241105090711_rnJlA | NZ001S | 2024-11-06T14:02:04.193Z | 2024-11-12T14:26:23.191Z |
5473796 | 5473796 | 20241103150442_V3Cvl | NZ001S | 2024-11-05T14:09:44.932Z | 2024-11-12T14:27:50.027Z |
5473780 | 5473780 | 20241103150229_07qUZ | NZ001S | 2024-11-05T14:09:43.755Z | 2024-11-12T14:27:50.017Z |
5473771 | 5473771 | 20241103150134_M1Msm | NZ001S | 2024-11-05T14:09:43.305Z | 2024-11-12T14:27:49.996Z |
5473534 | 5473534 | 20241103143006_sm2FL | NZ001S | 2024-11-05T14:09:04.724Z | 2024-11-12T14:27:49.688Z |
5473426 | 5473426 | 20241103141501_dTWXR | NZ001S | 2024-11-05T14:08:55.362Z | 2024-11-12T14:27:49.517Z |
5473332 | 5473332 | 20241103140404_51JcP | NZ001S | 2024-11-05T14:08:48.635Z | 2024-11-12T14:27:48.711Z |
5473313 | 5473313 | 20241103135956_08IkS | NZ001S | 2024-11-05T14:08:47.127Z | 2024-11-12T14:27:48.449Z |
5473237 | 5473237 | 20241103134818_9e9Mg | NZ001S | 2024-11-05T14:08:41.170Z | 2024-11-12T14:27:48.289Z |
5473231 | 5473231 | 20241103134810_Oddaq | NZ001S | 2024-11-05T14:08:40.510Z | 2024-11-12T14:27:48.284Z |
5473129 | 5473129 | 20241103133231_IIZGK | NZ001S | 2024-11-05T14:08:21.226Z | 2024-11-12T14:27:47.990Z |
5473103 | 5473103 | 20241103132849_gK4ih | NZ001S | 2024-11-05T14:08:17.429Z | 2024-11-12T14:27:47.938Z |
5472905 | 5472905 | 20241103125850_EE8da | NZ001S | 2024-11-05T14:07:51.138Z | 2024-11-12T14:27:46.867Z |
5472801 | 5472801 | 20241103124459_dlH50 | NZ001S | 2024-11-05T14:07:43.804Z | 2024-11-12T14:27:46.743Z |
5472742 | 5472742 | 20241103123219_2oAGO | NZ001S | 2024-11-05T14:07:39.220Z | 2024-11-12T14:27:46.517Z |
5472688 | 5472688 | 20241103122358_ty4Eu | NZ001S | 2024-11-05T14:07:29.879Z | 2024-11-12T14:27:46.328Z |
5472614 | 5472614 | 20241104155838_pqxHy | NZ001S | 2024-11-05T14:06:20.232Z | 2024-11-12T14:27:10.216Z |
5472606 | 5472606 | 20241104155529_e2DP8 | NZ001S | 2024-11-05T14:06:19.727Z | 2024-11-12T14:27:10.199Z |
5472559 | 5472559 | 20241104154511_I5YrT | NZ001S | 2024-11-05T14:06:14.294Z | 2024-11-12T14:27:09.749Z |
5472543 | 5472543 | 20241104154010_7N8cR | NZ001S | 2024-11-05T14:06:11.478Z | 2024-11-12T14:27:09.741Z |
5472531 | 5472531 | 20241104153555_GSGY1 | NZ001S | 2024-11-05T14:06:06.914Z | 2024-11-12T14:27:09.705Z |
5472493 | 5472493 | 20241104152139_zZ7Vx | NZ001S | 2024-11-05T14:05:59.188Z | 2024-11-12T14:27:08.820Z |
5472465 | 5472465 | 20241104151323_XhyOi | NZ001S | 2024-11-05T14:05:52.350Z | 2024-11-12T14:27:08.731Z |
5472453 | 5472453 | 20241104150904_Y5TTw | NZ001S | 2024-11-05T14:05:51.021Z | 2024-11-12T14:27:08.528Z |
5472440 | 5472440 | 20241104150659_hR3A1 | NZ001S | 2024-11-05T14:05:50.236Z | 2024-11-12T14:27:08.510Z |
5472405 | 5472405 | 20241104150002_pg4kE | NZ001S | 2024-11-05T14:05:47.159Z | 2024-11-12T14:27:08.461Z |
5472389 | 5472389 | 20241104145704_5n6oX | NZ001S | 2024-11-05T14:05:44.556Z | 2024-11-12T14:27:08.448Z |
5472348 | 5472348 | 20241104144552_Ga5AQ | NZ001S | 2024-11-05T14:05:40.643Z | 2024-11-12T14:27:08.359Z |
5472322 | 5472322 | 20241104143911_4Kk1r | NZ001S | 2024-11-05T14:05:38.082Z | 2024-11-12T14:27:08.337Z |
5472306 | 5472306 | 20241104143605_oaRt5 | NZ001S | 2024-11-05T14:05:36.587Z | 2024-11-12T14:27:08.310Z |
5472178 | 5472178 | 20241104135956_rbeHG | NZ001S | 2024-11-05T14:05:25.043Z | 2024-11-12T14:27:07.353Z |
5472137 | 5472137 | 20241104135205_BfU5N | NZ001S | 2024-11-05T14:05:14.410Z | 2024-11-12T14:27:07.176Z |
5472123 | 5472123 | 20241104134945_PgOwB | NZ001S | 2024-11-05T14:05:12.805Z | 2024-11-12T14:27:07.165Z |
5472081 | 5472081 | 20241104133518_YzWdy | NZ001S | 2024-11-05T14:05:05.036Z | 2024-11-12T14:27:07.143Z |
5472008 | 5472008 | 20241104132109_2FLOI | NZ001S | 2024-11-05T14:04:58.131Z | 2024-11-12T14:27:06.930Z |
5471947 | 5471947 | 20241104130803_ObzJu | NZ001S | 2024-11-05T14:04:52.141Z | 2024-11-12T14:27:06.697Z |
5471841 | 5471841 | 20241104124950_10fJo | NZ001S | 2024-11-05T14:04:41.588Z | 2024-11-12T14:27:06.062Z |
5471766 | 5471766 | 20241104123507_DScwV | NZ001S | 2024-11-05T14:04:34.443Z | 2024-11-12T14:27:05.460Z |
5471727 | 5471727 | 20241104123051_XFeO0 | NZ001S | 2024-11-05T14:04:31.232Z | 2024-11-12T14:27:05.384Z |
5471378 | 5471378 | 20241104113452_u2YM0 | NZ001S | 2024-11-05T14:03:34.287Z | 2024-11-12T14:27:03.886Z |
5471294 | 5471294 | 20241104112540_CPzzi | NZ001S | 2024-11-05T14:03:21.296Z | 2024-11-12T14:27:03.743Z |
5471284 | 5471284 | 20241104112533_2EIYw | NZ001S | 2024-11-05T14:03:19.111Z | 2024-11-12T14:27:03.740Z |
5471067 | 5471067 | 20241104104211_sjnqb | NZ001S | 2024-11-05T14:02:42.890Z | 2024-11-12T14:27:02.548Z |
5470822 | 5470822 | 20241104095405_4qbMC | NZ001S | 2024-11-05T14:01:57.315Z | 2024-11-12T14:27:01.455Z |
5470651 | 5470651 | 20241104091350_WRJks | NZ001S | 2024-11-05T14:01:28.272Z | 2024-11-12T14:27:00.347Z |
5470632 | 5470632 | 20241104091225_7DUuY | NZ001S | 2024-11-05T14:01:21.503Z | 2024-11-12T14:27:00.309Z |
5465393 | 5465393 | 20241103114430_q4YEI | NZ001S | 2024-11-04T14:03:38.284Z | 2024-11-12T14:27:46.191Z |
5465169 | 5465169 | 20241103105549_jhvKH | NZ001S | 2024-11-04T14:03:00.109Z | 2024-11-12T14:27:45.341Z |
5465131 | 5465131 | 20241103104441_4UQ2d | NZ001S | 2024-11-04T14:02:54.446Z | 2024-11-12T14:27:44.766Z |
5465045 | 5465045 | 20241103102941_fLGY4 | NZ001S | 2024-11-04T14:02:35.746Z | 2024-11-12T14:27:44.339Z |
5464914 | 5464914 | 20241103095106_kzyfv | NZ001S | 2024-11-04T14:02:10.647Z | 2024-11-12T14:27:43.859Z |
5464794 | 5464794 | 20241103091602_IruUQ | NZ001S | 2024-11-04T14:01:41.143Z | 2024-11-12T14:27:43.241Z |
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);