participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,218 rows where station_code = "NZ003Q" 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 |
---|---|---|---|---|---|
5494150 | 5494150 | 20241107160442_dPsDj | NZ003Q | 2024-11-08T14:05:26.474Z | 2024-11-08T14:05:26.474Z |
5494145 | 5494145 | 20241107160222_Gzird | NZ003Q | 2024-11-08T14:05:26.276Z | 2024-11-08T14:05:26.276Z |
5494096 | 5494096 | 20241107153437_MNWud | NZ003Q | 2024-11-08T14:05:22.259Z | 2024-11-08T14:05:22.259Z |
5487067 | 5487067 | 20241106143936_s8lN7 | NZ003Q | 2024-11-07T14:04:54.506Z | 2024-11-08T14:14:34.410Z |
5480564 | 5480564 | 20241105135558_Xsue2 | NZ003Q | 2024-11-06T14:05:55.878Z | 2024-11-08T14:15:29.969Z |
5480460 | 5480460 | 20241105130609_Gp1DK | NZ003Q | 2024-11-06T14:05:44.137Z | 2024-11-08T14:15:27.148Z |
5480365 | 5480365 | 20241105123643_NQhjh | NZ003Q | 2024-11-06T14:05:21.398Z | 2024-11-08T14:15:23.647Z |
5480354 | 5480354 | 20241105123212_uvKFs | NZ003Q | 2024-11-06T14:05:19.678Z | 2024-11-08T14:15:23.270Z |
5480237 | 5480237 | 20241105120528_tPNYn | NZ003Q | 2024-11-06T14:05:01.407Z | 2024-11-08T14:15:20.052Z |
5480218 | 5480218 | 20241105120335_C8dWY | NZ003Q | 2024-11-06T14:04:59.025Z | 2024-11-08T14:15:19.612Z |
5479891 | 5479891 | 20241105105649_uO2vR | NZ003Q | 2024-11-06T14:03:49.890Z | 2024-11-08T14:15:08.766Z |
5479880 | 5479880 | 20241105105544_i82nk | NZ003Q | 2024-11-06T14:03:48.524Z | 2024-11-08T14:15:08.646Z |
5479827 | 5479827 | 20241105104743_HZuWr | NZ003Q | 2024-11-06T14:03:41.158Z | 2024-11-08T14:15:06.981Z |
5479811 | 5479811 | 20241105104352_InmPh | NZ003Q | 2024-11-06T14:03:38.326Z | 2024-11-08T14:15:06.490Z |
5479675 | 5479675 | 20241105101733_tzPXJ | NZ003Q | 2024-11-06T14:03:03.770Z | 2024-11-08T14:15:00.637Z |
5479573 | 5479573 | 20241105095903_qRnYW | NZ003Q | 2024-11-06T14:02:47.910Z | 2024-11-08T14:14:57.680Z |
5479278 | 5479278 | 20241105085642_yi44b | NZ003Q | 2024-11-06T14:01:43.852Z | 2024-11-08T14:14:48.800Z |
5473674 | 5473674 | 20241103144849_69QHJ | NZ003Q | 2024-11-05T14:09:22.662Z | 2024-11-08T14:19:18.321Z |
5473627 | 5473627 | 20241103144152_f7wAz | NZ003Q | 2024-11-05T14:09:14.079Z | 2024-11-08T14:19:18.007Z |
5473512 | 5473512 | 20241103142750_srWhU | NZ003Q | 2024-11-05T14:09:03.146Z | 2024-11-08T14:19:17.180Z |
5473322 | 5473322 | 20241103140102_ShFyZ | NZ003Q | 2024-11-05T14:08:47.907Z | 2024-11-08T14:19:15.608Z |
5473224 | 5473224 | 20241103134634_oWfHo | NZ003Q | 2024-11-05T14:08:38.473Z | 2024-11-08T14:19:14.605Z |
5473123 | 5473123 | 20241103133004_19Kl9 | NZ003Q | 2024-11-05T14:08:19.921Z | 2024-11-08T14:19:13.685Z |
5473008 | 5473008 | 20241103131430_3e1M2 | NZ003Q | 2024-11-05T14:08:03.124Z | 2024-11-08T14:19:12.761Z |
5472965 | 5472965 | 20241103130540_5P0p4 | NZ003Q | 2024-11-05T14:07:55.442Z | 2024-11-08T14:19:12.235Z |
5472866 | 5472866 | 20241103125435_JcItz | NZ003Q | 2024-11-05T14:07:48.602Z | 2024-11-08T14:19:10.970Z |
5472838 | 5472838 | 20241103125045_BsD5w | NZ003Q | 2024-11-05T14:07:46.849Z | 2024-11-08T14:19:10.910Z |
5472819 | 5472819 | 20241103124846_cadF3 | NZ003Q | 2024-11-05T14:07:45.540Z | 2024-11-08T14:19:10.870Z |
5472710 | 5472710 | 20241103122646_4lVh8 | NZ003Q | 2024-11-05T14:07:34.577Z | 2024-11-08T14:19:09.938Z |
5472622 | 5472622 | 20241104155946_0gXgR | NZ003Q | 2024-11-05T14:06:20.542Z | 2024-11-08T14:17:57.346Z |
5472571 | 5472571 | 20241104154610_cIB3k | NZ003Q | 2024-11-05T14:06:16.347Z | 2024-11-08T14:17:56.393Z |
5472556 | 5472556 | 20241104154437_ENPqF | NZ003Q | 2024-11-05T14:06:13.531Z | 2024-11-08T14:17:56.176Z |
5472520 | 5472520 | 20241104153257_c20vN | NZ003Q | 2024-11-05T14:06:03.180Z | 2024-11-08T14:17:54.763Z |
5472488 | 5472488 | 20241104152100_ozwZL | NZ003Q | 2024-11-05T14:05:57.099Z | 2024-11-08T14:17:53.795Z |
5472388 | 5472388 | 20241104145626_vZ0FY | NZ003Q | 2024-11-05T14:05:44.232Z | 2024-11-08T14:17:51.097Z |
5472382 | 5472382 | 20241104145342_iivJJ | NZ003Q | 2024-11-05T14:05:43.682Z | 2024-11-08T14:17:50.920Z |
5472336 | 5472336 | 20241104144025_oN2Ia | NZ003Q | 2024-11-05T14:05:39.450Z | 2024-11-08T14:17:50.272Z |
5472303 | 5472303 | 20241104143453_AfCXH | NZ003Q | 2024-11-05T14:05:36.306Z | 2024-11-08T14:17:49.608Z |
5472164 | 5472164 | 20241104135805_Jmi7y | NZ003Q | 2024-11-05T14:05:20.785Z | 2024-11-08T14:17:47.652Z |
5472158 | 5472158 | 20241104135746_G5pqm | NZ003Q | 2024-11-05T14:05:18.304Z | 2024-11-08T14:17:47.629Z |
5472112 | 5472112 | 20241104134235_E29Ba | NZ003Q | 2024-11-05T14:05:10.836Z | 2024-11-08T14:17:46.936Z |
5471935 | 5471935 | 20241104130608_jok69 | NZ003Q | 2024-11-05T14:04:50.310Z | 2024-11-08T14:17:44.103Z |
5471917 | 5471917 | 20241104130100_2vRg3 | NZ003Q | 2024-11-05T14:04:48.464Z | 2024-11-08T14:17:43.965Z |
5471893 | 5471893 | 20241104125727_DLnOo | NZ003Q | 2024-11-05T14:04:46.370Z | 2024-11-08T14:17:43.311Z |
5471850 | 5471850 | 20241104125007_prlEm | NZ003Q | 2024-11-05T14:04:42.342Z | 2024-11-08T14:17:42.773Z |
5471805 | 5471805 | 20241104124208_WEH8z | NZ003Q | 2024-11-05T14:04:37.876Z | 2024-11-08T14:17:41.743Z |
5471776 | 5471776 | 20241104123530_0tGdk | NZ003Q | 2024-11-05T14:04:34.732Z | 2024-11-08T14:17:40.896Z |
5471764 | 5471764 | 20241104123420_u3IjM | NZ003Q | 2024-11-05T14:04:34.041Z | 2024-11-08T14:17:40.744Z |
5471661 | 5471661 | 20241104121948_4cQFH | NZ003Q | 2024-11-05T14:04:14.757Z | 2024-11-08T14:17:38.693Z |
5471570 | 5471570 | 20241104120444_LrpW6 | NZ003Q | 2024-11-05T14:03:57.385Z | 2024-11-08T14:17:36.208Z |
5471519 | 5471519 | 20241104115822_ilcyz | NZ003Q | 2024-11-05T14:03:51.960Z | 2024-11-08T14:17:34.844Z |
5471513 | 5471513 | 20241104115741_U30vn | NZ003Q | 2024-11-05T14:03:51.253Z | 2024-11-08T14:17:34.782Z |
5471434 | 5471434 | 20241104114415_2FkTZ | NZ003Q | 2024-11-05T14:03:43.625Z | 2024-11-08T14:17:33.521Z |
5471425 | 5471425 | 20241104114353_Loplv | NZ003Q | 2024-11-05T14:03:43.087Z | 2024-11-08T14:17:33.515Z |
5471211 | 5471211 | 20241104110329_Z3E8d | NZ003Q | 2024-11-05T14:03:08.335Z | 2024-11-08T14:17:30.761Z |
5471009 | 5471009 | 20241104102637_CC3K8 | NZ003Q | 2024-11-05T14:02:29.470Z | 2024-11-08T14:17:24.805Z |
5470933 | 5470933 | 20241104100816_GTBte | NZ003Q | 2024-11-05T14:02:18.857Z | 2024-11-08T14:17:22.447Z |
5470780 | 5470780 | 20241104094657_pN9HZ | NZ003Q | 2024-11-05T14:01:50.933Z | 2024-11-08T14:17:19.650Z |
5465423 | 5465423 | 20241103115251_wev0L | NZ003Q | 2024-11-04T14:03:41.314Z | 2024-11-08T14:19:08.492Z |
5465222 | 5465222 | 20241103110353_e9Lq5 | NZ003Q | 2024-11-04T14:03:06.070Z | 2024-11-08T14:19:06.089Z |
5465212 | 5465212 | 20241103110250_Vd3ZU | NZ003Q | 2024-11-04T14:03:04.986Z | 2024-11-08T14:19:05.983Z |
5465203 | 5465203 | 20241103110225_Pf4dB | NZ003Q | 2024-11-04T14:03:03.632Z | 2024-11-08T14:19:05.910Z |
5465183 | 5465183 | 20241103105635_yBYKz | NZ003Q | 2024-11-04T14:03:00.974Z | 2024-11-08T14:19:05.753Z |
5464700 | 5464700 | 20241103085551_qjRBa | NZ003Q | 2024-11-04T14:01:24.338Z | 2024-11-08T14:19:00.555Z |
5461143 | 5461143 | 20241101161251_1KBL0 | NZ003Q | 2024-11-03T14:14:45.556Z | 2024-11-08T14:21:41.153Z |
5461107 | 5461107 | 20241101155816_ZuQGk | NZ003Q | 2024-11-03T14:14:43.729Z | 2024-11-08T14:21:41.048Z |
5460883 | 5460883 | 20241101151737_XS3Hk | NZ003Q | 2024-11-03T14:14:32.797Z | 2024-11-08T14:21:40.339Z |
5460829 | 5460829 | 20241101150937_VJy83 | NZ003Q | 2024-11-03T14:14:30.540Z | 2024-11-08T14:21:40.285Z |
5460750 | 5460750 | 20241101145922_22K1B | NZ003Q | 2024-11-03T14:14:20.912Z | 2024-11-08T14:21:39.759Z |
5460705 | 5460705 | 20241101145456_jCkxg | NZ003Q | 2024-11-03T14:14:15.864Z | 2024-11-08T14:21:39.434Z |
5460658 | 5460658 | 20241101144408_lGL7t | NZ003Q | 2024-11-03T14:14:08.474Z | 2024-11-08T14:21:39.285Z |
5460503 | 5460503 | 20241101142350_jsHE0 | NZ003Q | 2024-11-03T14:13:53.027Z | 2024-11-08T14:21:38.977Z |
5460447 | 5460447 | 20241101141123_pAc71 | NZ003Q | 2024-11-03T14:13:45.051Z | 2024-11-08T14:21:38.860Z |
5460320 | 5460320 | 20241101134659_2fucz | NZ003Q | 2024-11-03T14:13:35.688Z | 2024-11-08T14:21:38.445Z |
5459977 | 5459977 | 20241101122658_yOtoX | NZ003Q | 2024-11-03T14:13:00.969Z | 2024-11-08T14:21:35.785Z |
5459947 | 5459947 | 20241101122025_RLBf4 | NZ003Q | 2024-11-03T14:12:55.921Z | 2024-11-08T14:21:35.456Z |
5459933 | 5459933 | 20241101121809_Il7QG | NZ003Q | 2024-11-03T14:12:54.086Z | 2024-11-08T14:21:34.777Z |
5459704 | 5459704 | 20241101114020_BqYMq | NZ003Q | 2024-11-03T14:12:29.592Z | 2024-11-08T14:21:33.072Z |
5459420 | 5459420 | 20241101105848_GGZwo | NZ003Q | 2024-11-03T14:11:53.407Z | 2024-11-08T14:21:30.631Z |
5459316 | 5459316 | 20241101104316_STHyZ | NZ003Q | 2024-11-03T14:11:41.908Z | 2024-11-08T14:21:30.202Z |
5459230 | 5459230 | 20241101102636_msqS4 | NZ003Q | 2024-11-03T14:11:31.897Z | 2024-11-08T14:21:29.727Z |
5458280 | 5458280 | 20241101080018_QdVN1 | NZ003Q | 2024-11-03T14:09:27.520Z | 2024-11-08T14:21:22.235Z |
5449743 | 5449743 | 20241031162625_fx0aB | NZ003Q | 2024-11-02T12:13:40.906Z | 2024-11-08T14:22:20.040Z |
5449550 | 5449550 | 20241031155127_jyPQQ | NZ003Q | 2024-11-02T12:13:05.384Z | 2024-11-08T14:22:19.634Z |
5448971 | 5448971 | 20241031143635_lFhw4 | NZ003Q | 2024-11-02T12:11:54.450Z | 2024-11-08T14:22:18.118Z |
5448425 | 5448425 | 20241031133101_yyCNh | NZ003Q | 2024-11-02T12:10:45.085Z | 2024-11-08T14:22:16.297Z |
5447872 | 5447872 | 20241031121920_JuaMG | NZ003Q | 2024-11-02T12:09:22.430Z | 2024-11-08T14:22:13.889Z |
5447515 | 5447515 | 20241031114838_8Z2fG | NZ003Q | 2024-11-02T12:08:20.995Z | 2024-11-08T14:22:12.294Z |
5446646 | 5446646 | 20241031101801_64pUI | NZ003Q | 2024-11-02T12:05:57.975Z | 2024-11-08T14:22:08.188Z |
5446526 | 5446526 | 20241031100727_bpWjj | NZ003Q | 2024-11-02T12:05:31.285Z | 2024-11-08T14:22:07.327Z |
5445618 | 5445618 | 20241031082731_Ee6CL | NZ003Q | 2024-11-02T12:02:39.699Z | 2024-11-08T14:22:02.409Z |
5438005 | 5438005 | 20241030161342_3G0XF | NZ003Q | 2024-11-01T12:10:50.844Z | 2024-11-08T14:22:58.580Z |
5437796 | 5437796 | 20241030154358_3DxLS | NZ003Q | 2024-11-01T12:10:20.904Z | 2024-11-08T14:22:58.139Z |
5437474 | 5437474 | 20241030151101_6PWv5 | NZ003Q | 2024-11-01T12:09:46.181Z | 2024-11-08T14:22:57.233Z |
5437394 | 5437394 | 20241030150306_pta2u | NZ003Q | 2024-11-01T12:09:31.581Z | 2024-11-08T14:22:57.092Z |
5437334 | 5437334 | 20241030145703_zz2t6 | NZ003Q | 2024-11-01T12:09:25.624Z | 2024-11-08T14:22:56.997Z |
5436751 | 5436751 | 20241030134432_X44oB | NZ003Q | 2024-11-01T12:08:11.188Z | 2024-11-08T14:22:54.822Z |
5436538 | 5436538 | 20241030131851_Yj7sn | NZ003Q | 2024-11-01T12:07:50.537Z | 2024-11-08T14:22:54.298Z |
5436425 | 5436425 | 20241030130553_HoQLh | NZ003Q | 2024-11-01T12:07:33.543Z | 2024-11-08T14:22:54.051Z |
5435901 | 5435901 | 20241030120833_AIlVm | NZ003Q | 2024-11-01T12:06:19.583Z | 2024-11-08T14:22:52.095Z |
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);