participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,449 rows where station_code = "NZ002V" 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 |
---|---|---|---|---|---|
5494149 | 5494149 | 20241107160442_dPsDj | NZ002V | 2024-11-08T14:05:26.474Z | 2024-11-08T14:05:26.474Z |
5494144 | 5494144 | 20241107160222_Gzird | NZ002V | 2024-11-08T14:05:26.276Z | 2024-11-08T14:05:26.276Z |
5494140 | 5494140 | 20241107154723_HjuG7 | NZ002V | 2024-11-08T14:05:25.691Z | 2024-11-08T14:05:25.691Z |
5494095 | 5494095 | 20241107153437_MNWud | NZ002V | 2024-11-08T14:05:22.259Z | 2024-11-08T14:05:22.259Z |
5494083 | 5494083 | 20241107153205_2AS3k | NZ002V | 2024-11-08T14:05:21.297Z | 2024-11-08T14:05:21.297Z |
5487281 | 5487281 | 20241106153034_72HiM | NZ002V | 2024-11-07T14:05:27.577Z | 2024-11-08T14:14:34.481Z |
5487066 | 5487066 | 20241106143936_s8lN7 | NZ002V | 2024-11-07T14:04:54.486Z | 2024-11-08T14:14:34.410Z |
5480719 | 5480719 | 20241105150800_Ki1JQ | NZ002V | 2024-11-06T14:06:24.632Z | 2024-11-08T14:15:36.845Z |
5480562 | 5480562 | 20241105135558_Xsue2 | NZ002V | 2024-11-06T14:05:55.878Z | 2024-11-08T14:15:29.969Z |
5480480 | 5480480 | 20241105131254_A66oz | NZ002V | 2024-11-06T14:05:46.500Z | 2024-11-08T14:15:27.642Z |
5480364 | 5480364 | 20241105123643_NQhjh | NZ002V | 2024-11-06T14:05:21.398Z | 2024-11-08T14:15:23.647Z |
5480216 | 5480216 | 20241105120335_C8dWY | NZ002V | 2024-11-06T14:04:59.025Z | 2024-11-08T14:15:19.612Z |
5480024 | 5480024 | 20241105111824_TGQ59 | NZ002V | 2024-11-06T14:04:20.395Z | 2024-11-08T14:15:12.780Z |
5479888 | 5479888 | 20241105105649_uO2vR | NZ002V | 2024-11-06T14:03:49.890Z | 2024-11-08T14:15:08.766Z |
5479878 | 5479878 | 20241105105544_i82nk | NZ002V | 2024-11-06T14:03:48.524Z | 2024-11-08T14:15:08.646Z |
5479810 | 5479810 | 20241105104352_InmPh | NZ002V | 2024-11-06T14:03:38.326Z | 2024-11-08T14:15:06.490Z |
5479674 | 5479674 | 20241105101733_tzPXJ | NZ002V | 2024-11-06T14:03:03.769Z | 2024-11-08T14:15:00.637Z |
5479572 | 5479572 | 20241105095903_qRnYW | NZ002V | 2024-11-06T14:02:47.910Z | 2024-11-08T14:14:57.680Z |
5479324 | 5479324 | 20241105090510_TafIJ | NZ002V | 2024-11-06T14:02:00.177Z | 2024-11-08T14:14:50.029Z |
5473626 | 5473626 | 20241103144152_f7wAz | NZ002V | 2024-11-05T14:09:14.079Z | 2024-11-08T14:19:18.007Z |
5473510 | 5473510 | 20241103142750_srWhU | NZ002V | 2024-11-05T14:09:03.146Z | 2024-11-08T14:19:17.179Z |
5473501 | 5473501 | 20241103142607_ffnIr | NZ002V | 2024-11-05T14:09:01.044Z | 2024-11-08T14:19:17.165Z |
5473321 | 5473321 | 20241103140102_ShFyZ | NZ002V | 2024-11-05T14:08:47.907Z | 2024-11-08T14:19:15.608Z |
5473223 | 5473223 | 20241103134634_oWfHo | NZ002V | 2024-11-05T14:08:38.473Z | 2024-11-08T14:19:14.605Z |
5473122 | 5473122 | 20241103133004_19Kl9 | NZ002V | 2024-11-05T14:08:19.921Z | 2024-11-08T14:19:13.685Z |
5473007 | 5473007 | 20241103131430_3e1M2 | NZ002V | 2024-11-05T14:08:03.124Z | 2024-11-08T14:19:12.761Z |
5472964 | 5472964 | 20241103130540_5P0p4 | NZ002V | 2024-11-05T14:07:55.441Z | 2024-11-08T14:19:12.235Z |
5472864 | 5472864 | 20241103125435_JcItz | NZ002V | 2024-11-05T14:07:48.602Z | 2024-11-08T14:19:10.970Z |
5472837 | 5472837 | 20241103125045_BsD5w | NZ002V | 2024-11-05T14:07:46.848Z | 2024-11-08T14:19:10.910Z |
5472822 | 5472822 | 20241103124914_vhxWY | NZ002V | 2024-11-05T14:07:45.691Z | 2024-11-08T14:19:10.871Z |
5472818 | 5472818 | 20241103124846_cadF3 | NZ002V | 2024-11-05T14:07:45.540Z | 2024-11-08T14:19:10.870Z |
5472709 | 5472709 | 20241103122646_4lVh8 | NZ002V | 2024-11-05T14:07:34.577Z | 2024-11-08T14:19:09.938Z |
5472621 | 5472621 | 20241104155946_0gXgR | NZ002V | 2024-11-05T14:06:20.542Z | 2024-11-08T14:17:57.346Z |
5472570 | 5472570 | 20241104154610_cIB3k | NZ002V | 2024-11-05T14:06:16.347Z | 2024-11-08T14:17:56.393Z |
5472555 | 5472555 | 20241104154437_ENPqF | NZ002V | 2024-11-05T14:06:13.530Z | 2024-11-08T14:17:56.176Z |
5472519 | 5472519 | 20241104153257_c20vN | NZ002V | 2024-11-05T14:06:03.180Z | 2024-11-08T14:17:54.763Z |
5472487 | 5472487 | 20241104152100_ozwZL | NZ002V | 2024-11-05T14:05:57.099Z | 2024-11-08T14:17:53.795Z |
5472387 | 5472387 | 20241104145626_vZ0FY | NZ002V | 2024-11-05T14:05:44.231Z | 2024-11-08T14:17:51.097Z |
5472381 | 5472381 | 20241104145342_iivJJ | NZ002V | 2024-11-05T14:05:43.682Z | 2024-11-08T14:17:50.920Z |
5472335 | 5472335 | 20241104144025_oN2Ia | NZ002V | 2024-11-05T14:05:39.450Z | 2024-11-08T14:17:50.272Z |
5472302 | 5472302 | 20241104143453_AfCXH | NZ002V | 2024-11-05T14:05:36.306Z | 2024-11-08T14:17:49.608Z |
5472267 | 5472267 | 20241104142129_WUO1c | NZ002V | 2024-11-05T14:05:33.048Z | 2024-11-08T14:17:48.747Z |
5472163 | 5472163 | 20241104135805_Jmi7y | NZ002V | 2024-11-05T14:05:20.785Z | 2024-11-08T14:17:47.652Z |
5472157 | 5472157 | 20241104135746_G5pqm | NZ002V | 2024-11-05T14:05:18.304Z | 2024-11-08T14:17:47.629Z |
5472111 | 5472111 | 20241104134235_E29Ba | NZ002V | 2024-11-05T14:05:10.836Z | 2024-11-08T14:17:46.936Z |
5471915 | 5471915 | 20241104130100_2vRg3 | NZ002V | 2024-11-05T14:04:48.464Z | 2024-11-08T14:17:43.965Z |
5471892 | 5471892 | 20241104125727_DLnOo | NZ002V | 2024-11-05T14:04:46.370Z | 2024-11-08T14:17:43.311Z |
5471849 | 5471849 | 20241104125007_prlEm | NZ002V | 2024-11-05T14:04:42.342Z | 2024-11-08T14:17:42.773Z |
5471804 | 5471804 | 20241104124208_WEH8z | NZ002V | 2024-11-05T14:04:37.876Z | 2024-11-08T14:17:41.743Z |
5471773 | 5471773 | 20241104123530_0tGdk | NZ002V | 2024-11-05T14:04:34.732Z | 2024-11-08T14:17:40.896Z |
5471762 | 5471762 | 20241104123420_u3IjM | NZ002V | 2024-11-05T14:04:34.041Z | 2024-11-08T14:17:40.744Z |
5471660 | 5471660 | 20241104121948_4cQFH | NZ002V | 2024-11-05T14:04:14.757Z | 2024-11-08T14:17:38.693Z |
5471576 | 5471576 | 20241104120521_GcB60 | NZ002V | 2024-11-05T14:03:58.243Z | 2024-11-08T14:17:36.253Z |
5471517 | 5471517 | 20241104115822_ilcyz | NZ002V | 2024-11-05T14:03:51.960Z | 2024-11-08T14:17:34.844Z |
5471512 | 5471512 | 20241104115741_U30vn | NZ002V | 2024-11-05T14:03:51.253Z | 2024-11-08T14:17:34.782Z |
5471424 | 5471424 | 20241104114353_Loplv | NZ002V | 2024-11-05T14:03:43.087Z | 2024-11-08T14:17:33.515Z |
5471210 | 5471210 | 20241104110329_Z3E8d | NZ002V | 2024-11-05T14:03:08.335Z | 2024-11-08T14:17:30.761Z |
5471196 | 5471196 | 20241104110029_7pAjU | NZ002V | 2024-11-05T14:03:05.677Z | 2024-11-08T14:17:30.001Z |
5471081 | 5471081 | 20241104104509_IaLSS | NZ002V | 2024-11-05T14:02:48.172Z | 2024-11-08T14:17:27.042Z |
5471007 | 5471007 | 20241104102637_CC3K8 | NZ002V | 2024-11-05T14:02:29.470Z | 2024-11-08T14:17:24.805Z |
5470931 | 5470931 | 20241104100816_GTBte | NZ002V | 2024-11-05T14:02:18.857Z | 2024-11-08T14:17:22.447Z |
5470779 | 5470779 | 20241104094657_pN9HZ | NZ002V | 2024-11-05T14:01:50.933Z | 2024-11-08T14:17:19.650Z |
5465426 | 5465426 | 20241103115338_eZsfB | NZ002V | 2024-11-04T14:03:41.734Z | 2024-11-08T14:19:08.499Z |
5465355 | 5465355 | 20241103113558_LLBMu | NZ002V | 2024-11-04T14:03:33.849Z | 2024-11-08T14:19:07.788Z |
5465221 | 5465221 | 20241103110353_e9Lq5 | NZ002V | 2024-11-04T14:03:06.070Z | 2024-11-08T14:19:06.089Z |
5465211 | 5465211 | 20241103110250_Vd3ZU | NZ002V | 2024-11-04T14:03:04.986Z | 2024-11-08T14:19:05.983Z |
5465201 | 5465201 | 20241103110225_Pf4dB | NZ002V | 2024-11-04T14:03:03.632Z | 2024-11-08T14:19:05.910Z |
5465182 | 5465182 | 20241103105635_yBYKz | NZ002V | 2024-11-04T14:03:00.974Z | 2024-11-08T14:19:05.753Z |
5464699 | 5464699 | 20241103085551_qjRBa | NZ002V | 2024-11-04T14:01:24.323Z | 2024-11-08T14:19:00.555Z |
5461142 | 5461142 | 20241101161251_1KBL0 | NZ002V | 2024-11-03T14:14:45.556Z | 2024-11-08T14:21:41.153Z |
5460932 | 5460932 | 20241101152254_CIyCS | NZ002V | 2024-11-03T14:14:34.969Z | 2024-11-08T14:21:40.607Z |
5460882 | 5460882 | 20241101151737_XS3Hk | NZ002V | 2024-11-03T14:14:32.797Z | 2024-11-08T14:21:40.339Z |
5460875 | 5460875 | 20241101151549_ncsyK | NZ002V | 2024-11-03T14:14:32.442Z | 2024-11-08T14:21:40.319Z |
5460749 | 5460749 | 20241101145922_22K1B | NZ002V | 2024-11-03T14:14:20.912Z | 2024-11-08T14:21:39.759Z |
5460730 | 5460730 | 20241101145709_SZik7 | NZ002V | 2024-11-03T14:14:18.174Z | 2024-11-08T14:21:39.681Z |
5460703 | 5460703 | 20241101145456_jCkxg | NZ002V | 2024-11-03T14:14:15.864Z | 2024-11-08T14:21:39.434Z |
5460657 | 5460657 | 20241101144408_lGL7t | NZ002V | 2024-11-03T14:14:08.474Z | 2024-11-08T14:21:39.285Z |
5460502 | 5460502 | 20241101142350_jsHE0 | NZ002V | 2024-11-03T14:13:53.027Z | 2024-11-08T14:21:38.977Z |
5460446 | 5460446 | 20241101141123_pAc71 | NZ002V | 2024-11-03T14:13:45.051Z | 2024-11-08T14:21:38.860Z |
5460319 | 5460319 | 20241101134659_2fucz | NZ002V | 2024-11-03T14:13:35.688Z | 2024-11-08T14:21:38.445Z |
5460240 | 5460240 | 20241101132101_2YdAP | NZ002V | 2024-11-03T14:13:30.571Z | 2024-11-08T14:21:37.873Z |
5459975 | 5459975 | 20241101122658_yOtoX | NZ002V | 2024-11-03T14:13:00.969Z | 2024-11-08T14:21:35.785Z |
5459945 | 5459945 | 20241101122025_RLBf4 | NZ002V | 2024-11-03T14:12:55.921Z | 2024-11-08T14:21:35.456Z |
5459932 | 5459932 | 20241101121809_Il7QG | NZ002V | 2024-11-03T14:12:54.086Z | 2024-11-08T14:21:34.777Z |
5459314 | 5459314 | 20241101104316_STHyZ | NZ002V | 2024-11-03T14:11:41.908Z | 2024-11-08T14:21:30.202Z |
5459228 | 5459228 | 20241101102636_msqS4 | NZ002V | 2024-11-03T14:11:31.897Z | 2024-11-08T14:21:29.727Z |
5458931 | 5458931 | 20241101094527_XFNv5 | NZ002V | 2024-11-03T14:10:50.490Z | 2024-11-08T14:21:27.769Z |
5458927 | 5458927 | 20241101094435_yDJ11 | NZ002V | 2024-11-03T14:10:49.891Z | 2024-11-08T14:21:27.744Z |
5449742 | 5449742 | 20241031162625_fx0aB | NZ002V | 2024-11-02T12:13:40.906Z | 2024-11-08T14:22:20.040Z |
5449549 | 5449549 | 20241031155127_jyPQQ | NZ002V | 2024-11-02T12:13:05.384Z | 2024-11-08T14:22:19.634Z |
5449486 | 5449486 | 20241031154242_SotpI | NZ002V | 2024-11-02T12:13:00.209Z | 2024-11-08T14:22:19.404Z |
5449127 | 5449127 | 20241031145834_F258Q | NZ002V | 2024-11-02T12:12:08.106Z | 2024-11-08T14:22:18.424Z |
5449000 | 5449000 | 20241031143953_3Isxb | NZ002V | 2024-11-02T12:11:56.973Z | 2024-11-08T14:22:18.146Z |
5448970 | 5448970 | 20241031143635_lFhw4 | NZ002V | 2024-11-02T12:11:54.449Z | 2024-11-08T14:22:18.118Z |
5448883 | 5448883 | 20241031142755_Cc0U6 | NZ002V | 2024-11-02T12:11:38.662Z | 2024-11-08T14:22:17.879Z |
5448865 | 5448865 | 20241031142616_8WNK3 | NZ002V | 2024-11-02T12:11:36.985Z | 2024-11-08T14:22:17.859Z |
5448829 | 5448829 | 20241031142133_pJNOs | NZ002V | 2024-11-02T12:11:31.856Z | 2024-11-08T14:22:17.397Z |
5448824 | 5448824 | 20241031142012_6OCOB | NZ002V | 2024-11-02T12:11:31.229Z | 2024-11-08T14:22:17.385Z |
5448562 | 5448562 | 20241031134612_fX4I5 | NZ002V | 2024-11-02T12:11:06.413Z | 2024-11-08T14:22:16.767Z |
5448477 | 5448477 | 20241031133632_Y4uqJ | NZ002V | 2024-11-02T12:10:49.555Z | 2024-11-08T14:22:16.621Z |
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);