participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,030 rows where station_code = "NZ000K" 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 |
---|---|---|---|---|---|
5123536 | 5123536 | 20240914102551_xcOsX | NZ000K | 2024-09-18T12:11:51.116Z | 2024-09-19T12:20:12.480Z |
5083691 | 5083691 | 20240911141235_SrTHt | NZ000K | 2024-09-15T12:18:45.592Z | 2024-09-19T12:21:49.809Z |
5071663 | 5071663 | 20240911174142_oxqk0 | NZ000K | 2024-09-15T12:03:12.414Z | 2024-09-19T12:21:02.294Z |
5071415 | 5071415 | 20240911164817_ig2eU | NZ000K | 2024-09-15T12:02:29.541Z | 2024-09-19T12:21:01.854Z |
5070665 | 5070665 | 20240911145029_k3Z0r | NZ000K | 2024-09-15T12:00:29.631Z | 2024-09-19T12:20:59.771Z |
5070621 | 5070621 | 20240911144202_BTrEm | NZ000K | 2024-09-15T12:00:25.235Z | 2024-09-19T12:20:59.429Z |
5069056 | 5069056 | 20240910133227_OSfTd | NZ000K | 2024-09-14T12:19:25.020Z | 2024-09-18T12:15:27.080Z |
5068880 | 5068880 | 20240910125515_63LZ7 | NZ000K | 2024-09-14T12:19:22.593Z | 2024-09-18T12:15:26.784Z |
5067701 | 5067701 | 20240910100246_AmcXG | NZ000K | 2024-09-14T12:18:54.468Z | 2024-09-18T12:15:24.740Z |
5066679 | 5066679 | 20240910080326_h1nnp | NZ000K | 2024-09-14T12:18:07.338Z | 2024-09-18T12:15:22.433Z |
5062345 | 5062345 | 20240909171237_Ln7gY | NZ000K | 2024-09-14T12:12:11.917Z | 2024-09-18T12:15:10.950Z |
5062253 | 5062253 | 20240909170428_JRkH6 | NZ000K | 2024-09-14T12:12:01.797Z | 2024-09-18T12:15:10.823Z |
5062014 | 5062014 | 20240909163324_pKEnH | NZ000K | 2024-09-14T12:11:44.765Z | 2024-09-18T12:15:10.307Z |
5061549 | 5061549 | 20240909152231_jzabH | NZ000K | 2024-09-14T12:10:57.287Z | 2024-09-18T12:15:09.608Z |
5061529 | 5061529 | 20240909152053_xO0se | NZ000K | 2024-09-14T12:10:55.957Z | 2024-09-18T12:15:09.497Z |
5061083 | 5061083 | 20240909141230_9d02L | NZ000K | 2024-09-14T12:10:14.681Z | 2024-09-18T12:15:08.066Z |
5059483 | 5059483 | 20240910174832_EhdnD | NZ000K | 2024-09-14T12:06:12.337Z | 2024-09-19T12:21:30.821Z |
5059470 | 5059470 | 20240910174750_zOlX4 | NZ000K | 2024-09-14T12:06:10.968Z | 2024-09-19T12:21:30.812Z |
5059286 | 5059286 | 20240910172808_sYr2k | NZ000K | 2024-09-14T12:05:36.010Z | 2024-09-19T12:21:30.485Z |
5058632 | 5058632 | 20240910163225_U92vP | NZ000K | 2024-09-14T12:04:13.149Z | 2024-09-19T12:21:29.797Z |
5045558 | 5045558 | 20240908172354_7OPON | NZ000K | 2024-09-13T12:04:20.409Z | 2024-09-17T12:18:56.793Z |
5045373 | 5045373 | 20240908165840_hmsTp | NZ000K | 2024-09-13T12:04:04.096Z | 2024-09-17T12:18:56.447Z |
5045305 | 5045305 | 20240908165132_aSkrX | NZ000K | 2024-09-13T12:03:55.986Z | 2024-09-17T12:18:56.369Z |
5045293 | 5045293 | 20240908164923_nTldm | NZ000K | 2024-09-13T12:03:53.437Z | 2024-09-17T12:18:56.337Z |
5045171 | 5045171 | 20240908162850_QFj5J | NZ000K | 2024-09-13T12:03:37.735Z | 2024-09-17T12:18:56.018Z |
5044994 | 5044994 | 20240908160203_IEtN3 | NZ000K | 2024-09-13T12:03:22.647Z | 2024-09-17T12:18:55.590Z |
5044868 | 5044868 | 20240908155056_47lWS | NZ000K | 2024-09-13T12:03:04.319Z | 2024-09-17T12:18:55.298Z |
5044837 | 5044837 | 20240908154914_m3OYk | NZ000K | 2024-09-13T12:03:01.682Z | 2024-09-17T12:18:55.264Z |
5044789 | 5044789 | 20240908154408_HxNOn | NZ000K | 2024-09-13T12:02:57.106Z | 2024-09-17T12:18:55.192Z |
5044467 | 5044467 | 20240908150436_B5OhB | NZ000K | 2024-09-13T12:02:14.450Z | 2024-09-17T12:18:54.452Z |
5044228 | 5044228 | 20240908143157_p9UgD | NZ000K | 2024-09-13T12:01:43.543Z | 2024-09-17T12:18:53.862Z |
5043942 | 5043942 | 20240908133951_hfWQj | NZ000K | 2024-09-13T12:01:01.476Z | 2024-09-17T12:18:53.089Z |
5043456 | 5043456 | 20240907111039_2xh8Y | NZ000K | 2024-09-12T12:17:34.112Z | 2024-09-15T12:21:41.718Z |
5042983 | 5042983 | 20240907132622_41OGE | NZ000K | 2024-09-12T12:17:21.397Z | 2024-09-16T12:20:55.073Z |
5042956 | 5042956 | 20240907132035_4TgT3 | NZ000K | 2024-09-12T12:17:21.147Z | 2024-09-16T12:20:54.953Z |
5042936 | 5042936 | 20240907131517_mqktp | NZ000K | 2024-09-12T12:17:20.883Z | 2024-09-16T12:20:54.934Z |
5042781 | 5042781 | 20240907124552_kV6aj | NZ000K | 2024-09-12T12:17:18.267Z | 2024-09-16T12:20:54.228Z |
5041238 | 5041238 | 20240906074422_MM22D | NZ000K | 2024-09-12T12:16:36.852Z | 2024-09-14T12:23:12.307Z |
5036078 | 5036078 | 20240905123722_Hrcw2 | NZ000K | 2024-09-12T12:13:22.688Z | 2024-09-14T12:22:51.844Z |
5035724 | 5035724 | 20240907101238_gBA9Q | NZ000K | 2024-09-12T12:12:24.345Z | 2024-09-15T12:21:41.012Z |
5035600 | 5035600 | 20240907095347_5VqFy | NZ000K | 2024-09-12T12:12:15.467Z | 2024-09-15T12:21:40.241Z |
5035522 | 5035522 | 20240907094508_jdQGc | NZ000K | 2024-09-12T12:12:11.521Z | 2024-09-15T12:21:39.833Z |
5035248 | 5035248 | 20240907090811_KUo0U | NZ000K | 2024-09-12T12:11:58.281Z | 2024-09-15T12:21:39.014Z |
5017087 | 5017087 | 20240904153003_XgEh4 | NZ000K | 2024-09-10T12:08:46.427Z | 2024-09-13T12:19:46.570Z |
5015479 | 5015479 | 20240904114410_DeyTb | NZ000K | 2024-09-10T12:06:14.547Z | 2024-09-13T12:19:44.146Z |
5014398 | 5014398 | 20240905123722_9FPQI | NZ000K | 2024-09-10T12:03:03.396Z | 2024-09-11T12:16:31.146Z |
5006609 | 5006609 | 20240903180517_zl5To | NZ000K | 2024-09-09T12:04:49.015Z | 2024-09-12T12:19:09.047Z |
5006589 | 5006589 | 20240903175710_kGqGO | NZ000K | 2024-09-09T12:04:47.833Z | 2024-09-12T12:19:08.985Z |
5006552 | 5006552 | 20240903175130_jlUE2 | NZ000K | 2024-09-09T12:04:45.782Z | 2024-09-12T12:19:08.736Z |
5006520 | 5006520 | 20240903174601_wnX2X | NZ000K | 2024-09-09T12:04:43.966Z | 2024-09-12T12:19:08.529Z |
5006424 | 5006424 | 20240903173439_MnQeN | NZ000K | 2024-09-09T12:04:38.964Z | 2024-09-12T12:19:08.268Z |
5005978 | 5005978 | 20240903163925_8jxmn | NZ000K | 2024-09-09T12:04:15.146Z | 2024-09-12T12:19:07.162Z |
5005418 | 5005418 | 20240903150925_Pa6sn | NZ000K | 2024-09-09T12:03:42.005Z | 2024-09-12T12:19:05.913Z |
5005366 | 5005366 | 20240903145906_Y9EA0 | NZ000K | 2024-09-09T12:03:39.005Z | 2024-09-12T12:19:05.819Z |
5005206 | 5005206 | 20240903143124_CQOE8 | NZ000K | 2024-09-09T12:03:26.815Z | 2024-09-12T12:19:05.463Z |
5003662 | 5003662 | 20240903093006_gaTh3 | NZ000K | 2024-09-09T12:01:56.797Z | 2024-09-12T12:18:58.366Z |
5003250 | 5003250 | 20240904112812_Uf6Jf | NZ000K | 2024-09-09T12:01:29.738Z | 2024-09-13T12:19:43.768Z |
5002857 | 5002857 | 20240904105006_O8EQL | NZ000K | 2024-09-09T12:01:06.324Z | 2024-09-13T12:19:42.273Z |
4995248 | 4995248 | 20240902163147_bXG7b | NZ000K | 2024-09-08T12:03:26.283Z | 2024-09-11T12:20:43.134Z |
4995152 | 4995152 | 20240902162247_SHOl2 | NZ000K | 2024-09-08T12:03:18.282Z | 2024-09-11T12:20:42.499Z |
4994921 | 4994921 | 20240902153551_DMVna | NZ000K | 2024-09-08T12:03:06.315Z | 2024-09-11T12:20:40.396Z |
4994781 | 4994781 | 20240902151130_U33sE | NZ000K | 2024-09-08T12:02:58.270Z | 2024-09-11T12:20:38.973Z |
4994567 | 4994567 | 20240902143049_q2CfA | NZ000K | 2024-09-08T12:02:42.675Z | 2024-09-11T12:20:35.090Z |
4994549 | 4994549 | 20240902142530_WJKXa | NZ000K | 2024-09-08T12:02:41.665Z | 2024-09-11T12:20:34.974Z |
4960294 | 4960294 | 20240811161447_O5OWT | NZ000K | 2024-09-04T12:02:24.188Z | 2024-09-06T12:02:01.877Z |
4960287 | 4960287 | 20240811161444_FcInV | NZ000K | 2024-09-04T12:02:23.893Z | 2024-09-06T12:02:01.633Z |
4932048 | 4932048 | 20240810114241_TaKkJ | NZ000K | 2024-08-31T12:25:18.139Z | 2024-09-02T12:31:21.334Z |
4931713 | 4931713 | 20240810110042_Bqx9s | NZ000K | 2024-08-31T12:24:51.656Z | 2024-09-02T12:31:08.316Z |
4931509 | 4931509 | 20240810103848_gD661 | NZ000K | 2024-08-31T12:24:39.668Z | 2024-09-02T12:30:57.810Z |
4931115 | 4931115 | 20240810094437_Y6wIV | NZ000K | 2024-08-31T12:24:16.412Z | 2024-09-02T12:30:39.713Z |
4930824 | 4930824 | 20240810090416_yiXHO | NZ000K | 2024-08-31T12:23:58.822Z | 2024-09-02T12:30:27.989Z |
4930805 | 4930805 | 20240810090242_i2KPu | NZ000K | 2024-08-31T12:23:57.974Z | 2024-09-02T12:30:27.074Z |
4923613 | 4923613 | 20240810121905_R1Hi6 | NZ000K | 2024-08-31T12:00:49.436Z | 2024-09-06T12:16:08.286Z |
4923558 | 4923558 | 20240810121104_P4ufs | NZ000K | 2024-08-31T12:00:41.906Z | 2024-09-06T12:16:04.297Z |
4910569 | 4910569 | 20240809181651_s8ij2 | NZ000K | 2024-08-29T12:06:21.176Z | 2024-09-02T12:20:58.867Z |
4910102 | 4910102 | 20240809174112_jqaDG | NZ000K | 2024-08-29T12:05:49.251Z | 2024-09-02T12:20:30.979Z |
4909926 | 4909926 | 20240809173237_AoE73 | NZ000K | 2024-08-29T12:05:40.467Z | 2024-09-02T12:20:27.190Z |
4909439 | 4909439 | 20240809165748_mIECv | NZ000K | 2024-08-29T12:05:09.779Z | 2024-09-02T12:19:58.582Z |
4909039 | 4909039 | 20240809162614_vwO7V | NZ000K | 2024-08-29T12:04:42.223Z | 2024-09-02T12:19:40.502Z |
4908985 | 4908985 | 20240809162310_rJhrp | NZ000K | 2024-08-29T12:04:39.876Z | 2024-09-02T12:19:36.033Z |
4908745 | 4908745 | 20240809160022_6GP0b | NZ000K | 2024-08-29T12:04:24.190Z | 2024-09-02T12:19:25.374Z |
4908567 | 4908567 | 20240809154558_cDG9u | NZ000K | 2024-08-29T12:04:13.966Z | 2024-09-02T12:19:17.334Z |
4908363 | 4908363 | 20240809153548_VkLll | NZ000K | 2024-08-29T12:04:01.692Z | 2024-09-02T12:19:11.499Z |
4908179 | 4908179 | 20240809152035_l3TG6 | NZ000K | 2024-08-29T12:03:49.507Z | 2024-09-02T12:19:05.599Z |
4908104 | 4908104 | 20240809151640_0YFjA | NZ000K | 2024-08-29T12:03:41.928Z | 2024-09-02T12:18:53.811Z |
4907013 | 4907013 | 20240809133855_v2H2p | NZ000K | 2024-08-29T12:02:34.132Z | 2024-09-02T12:18:05.692Z |
4906750 | 4906750 | 20240809131205_ONbix | NZ000K | 2024-08-29T12:02:14.272Z | 2024-09-02T12:17:57.286Z |
4906606 | 4906606 | 20240809125716_mtFAJ | NZ000K | 2024-08-29T12:02:03.604Z | 2024-09-02T12:17:43.732Z |
4906418 | 4906418 | 20240809123807_FoH3S | NZ000K | 2024-08-29T12:01:51.199Z | 2024-09-02T12:17:36.867Z |
4906327 | 4906327 | 20240809122917_aIe2m | NZ000K | 2024-08-29T12:01:44.471Z | 2024-09-02T12:17:33.546Z |
4906272 | 4906272 | 20240809122437_TxDBx | NZ000K | 2024-08-29T12:01:40.516Z | 2024-09-02T12:17:31.940Z |
4906033 | 4906033 | 20240809114957_W1Nid | NZ000K | 2024-08-29T12:01:21.272Z | 2024-09-02T12:17:24.133Z |
4905616 | 4905616 | 20240809110711_272zz | NZ000K | 2024-08-29T12:00:42.049Z | 2024-09-02T12:16:53.320Z |
4893665 | 4893665 | 20240809102847_BaeE8 | NZ000K | 2024-08-28T12:11:37.751Z | 2024-08-30T12:23:06.483Z |
4893470 | 4893470 | 20240809094153_PwQGZ | NZ000K | 2024-08-28T12:11:29.074Z | 2024-08-30T12:22:58.676Z |
4893055 | 4893055 | 20240809081701_g1iPX | NZ000K | 2024-08-28T12:10:58.401Z | 2024-08-30T12:22:44.244Z |
4885339 | 4885339 | 20240808100229_TGeoB | NZ000K | 2024-08-28T12:00:26.883Z | 2024-08-30T12:15:29.132Z |
4885300 | 4885300 | 20240808095638_F24nt | NZ000K | 2024-08-28T12:00:22.438Z | 2024-08-30T12:15:27.299Z |
4870659 | 4870659 | 20240806181137_3U2o3 | NZ000K | 2024-08-19T12:08:00.905Z | 2024-08-27T12:08:54.336Z |
4870366 | 4870366 | 20240806175803_cpPVG | NZ000K | 2024-08-19T12:07:50.293Z | 2024-08-27T12:08:44.303Z |
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);