participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,818 rows where station_code = "NZ003W" 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 |
---|---|---|---|---|---|
5569390 | 5569390 | 20241121152204_aEgWX | NZ003W | 2024-11-22T14:10:50.250Z | 2024-11-22T14:10:50.250Z |
5569149 | 5569149 | 20241121144130_KdzVi | NZ003W | 2024-11-22T14:10:24.193Z | 2024-11-22T14:10:24.193Z |
5569136 | 5569136 | 20241121144015_IjYio | NZ003W | 2024-11-22T14:10:23.278Z | 2024-11-22T14:10:23.278Z |
5569130 | 5569130 | 20241121144014_WXvPf | NZ003W | 2024-11-22T14:10:22.901Z | 2024-11-22T14:10:22.901Z |
5569120 | 5569120 | 20241121143808_FthPx | NZ003W | 2024-11-22T14:10:22.160Z | 2024-11-22T14:10:22.160Z |
5569084 | 5569084 | 20241121142906_w8GJq | NZ003W | 2024-11-22T14:10:18.577Z | 2024-11-22T14:10:18.577Z |
5569005 | 5569005 | 20241121141731_3unle | NZ003W | 2024-11-22T14:10:10.445Z | 2024-11-22T14:10:10.445Z |
5568914 | 5568914 | 20241121140307_8UHsu | NZ003W | 2024-11-22T14:10:03.954Z | 2024-11-22T14:10:03.954Z |
5568760 | 5568760 | 20241121133044_KvoHH | NZ003W | 2024-11-22T14:09:40.370Z | 2024-11-22T14:09:40.370Z |
5568682 | 5568682 | 20241121132041_ZgUGv | NZ003W | 2024-11-22T14:09:33.069Z | 2024-11-22T14:09:33.069Z |
5568676 | 5568676 | 20241121132014_93Z85 | NZ003W | 2024-11-22T14:09:32.779Z | 2024-11-22T14:09:32.779Z |
5568613 | 5568613 | 20241121131127_a10FS | NZ003W | 2024-11-22T14:09:26.045Z | 2024-11-22T14:09:26.045Z |
5568580 | 5568580 | 20241121130621_BVzTr | NZ003W | 2024-11-22T14:09:22.953Z | 2024-11-22T14:09:22.953Z |
5568023 | 5568023 | 20241121114209_diUVR | NZ003W | 2024-11-22T14:07:57.522Z | 2024-11-22T14:07:57.522Z |
5567858 | 5567858 | 20241121111936_eEq0V | NZ003W | 2024-11-22T14:07:26.007Z | 2024-11-22T14:07:26.007Z |
5560961 | 5560961 | 20241120153104_UbfsX | NZ003W | 2024-11-21T14:10:06.055Z | 2024-11-22T14:19:21.771Z |
5555465 | 5555465 | 20241119132417_6TlvU | NZ003W | 2024-11-20T14:05:42.615Z | 2024-11-22T14:20:06.874Z |
5555145 | 5555145 | 20241119115604_d38SB | NZ003W | 2024-11-20T14:04:33.346Z | 2024-11-22T14:19:59.811Z |
5555101 | 5555101 | 20241119114442_gu3iC | NZ003W | 2024-11-20T14:04:27.643Z | 2024-11-22T14:19:58.424Z |
5551895 | 5551895 | 20241118153559_Glpyi | NZ003W | 2024-11-19T14:05:46.763Z | 2024-11-22T14:22:12.927Z |
5551836 | 5551836 | 20241118152244_2LFFA | NZ003W | 2024-11-19T14:05:41.101Z | 2024-11-22T14:22:12.650Z |
5551163 | 5551163 | 20241118123608_OQ4z1 | NZ003W | 2024-11-19T14:04:00.660Z | 2024-11-22T14:22:08.790Z |
5550877 | 5550877 | 20241118114029_81Yom | NZ003W | 2024-11-19T14:03:16.664Z | 2024-11-22T14:22:06.381Z |
5550756 | 5550756 | 20241118112119_A3FHV | NZ003W | 2024-11-19T14:03:02.228Z | 2024-11-22T14:22:05.395Z |
5550366 | 5550366 | 20241118100942_4eJTW | NZ003W | 2024-11-19T14:02:14.625Z | 2024-11-22T14:22:01.732Z |
5550207 | 5550207 | 20241118094618_UjUAq | NZ003W | 2024-11-19T14:01:45.835Z | 2024-11-22T14:21:59.625Z |
5550102 | 5550102 | 20241118093004_OvQgg | NZ003W | 2024-11-19T14:01:34.467Z | 2024-11-22T14:21:58.122Z |
5550068 | 5550068 | 20241118092543_c0TsZ | NZ003W | 2024-11-19T14:01:32.400Z | 2024-11-22T14:21:57.788Z |
5550020 | 5550020 | 20241118090905_mOJJB | NZ003W | 2024-11-19T14:01:27.221Z | 2024-11-22T14:21:56.872Z |
5520308 | 5520308 | 20241111151739_MNkVC | NZ003W | 2024-11-12T14:06:07.812Z | 2024-11-20T14:25:06.711Z |
5520067 | 5520067 | 20241111142911_svf5K | NZ003W | 2024-11-12T14:05:32.645Z | 2024-11-20T14:25:02.980Z |
5519882 | 5519882 | 20241111134512_6wJkS | NZ003W | 2024-11-12T14:05:16.247Z | 2024-11-20T14:25:00.431Z |
5519859 | 5519859 | 20241111133525_l6MuI | NZ003W | 2024-11-12T14:05:11.750Z | 2024-11-20T14:24:59.973Z |
5519808 | 5519808 | 20241111130914_aILnI | NZ003W | 2024-11-12T14:05:03.966Z | 2024-11-20T14:24:58.173Z |
5519793 | 5519793 | 20241111130450_3LIgQ | NZ003W | 2024-11-12T14:05:01.262Z | 2024-11-20T14:24:57.929Z |
5519715 | 5519715 | 20241111123723_AZ6kw | NZ003W | 2024-11-12T14:04:48.823Z | 2024-11-20T14:24:55.840Z |
5519704 | 5519704 | 20241111123515_5hTgQ | NZ003W | 2024-11-12T14:04:47.979Z | 2024-11-20T14:24:55.695Z |
5519452 | 5519452 | 20241111112725_31B5J | NZ003W | 2024-11-12T14:04:04.794Z | 2024-11-20T14:24:50.599Z |
5519185 | 5519185 | 20241111103545_XJquG | NZ003W | 2024-11-12T14:03:16.963Z | 2024-11-20T14:24:46.342Z |
5507604 | 5507604 | 20241109115740_NrsT3 | NZ003W | 2024-11-10T14:05:36.565Z | 2024-11-18T14:26:12.385Z |
5501694 | 5501694 | 20241107151550_xCtXS | NZ003W | 2024-11-09T14:10:13.462Z | 2024-11-16T14:27:45.431Z |
5500541 | 5500541 | 20241108160223_PJHcn | NZ003W | 2024-11-09T14:06:29.246Z | 2024-11-17T14:23:23.459Z |
5500475 | 5500475 | 20241108154912_Yjx3g | NZ003W | 2024-11-09T14:06:20.145Z | 2024-11-17T14:23:22.863Z |
5499955 | 5499955 | 20241108141339_62tMf | NZ003W | 2024-11-09T14:05:23.849Z | 2024-11-17T14:23:17.584Z |
5499924 | 5499924 | 20241108140421_tpu6c | NZ003W | 2024-11-09T14:05:20.323Z | 2024-11-17T14:23:17.235Z |
5499811 | 5499811 | 20241108133821_BAy7C | NZ003W | 2024-11-09T14:04:59.764Z | 2024-11-17T14:23:16.218Z |
5499751 | 5499751 | 20241108131642_UiJIk | NZ003W | 2024-11-09T14:04:53.684Z | 2024-11-17T14:23:15.807Z |
5499238 | 5499238 | 20241108114214_noYsZ | NZ003W | 2024-11-09T14:03:36.094Z | 2024-11-17T14:23:08.246Z |
5494113 | 5494113 | 20241107154103_BHY5h | NZ003W | 2024-11-08T14:05:23.958Z | 2024-11-16T14:27:48.082Z |
5493951 | 5493951 | 20241107144803_e4lq2 | NZ003W | 2024-11-08T14:05:02.771Z | 2024-11-16T14:27:43.585Z |
5492542 | 5492542 | 20241107085801_iRP2K | NZ003W | 2024-11-08T14:01:23.032Z | 2024-11-16T14:27:26.663Z |
5480964 | 5480964 | 20241104114837_3HewB | NZ003W | 2024-11-06T14:08:10.790Z | 2024-11-13T14:27:24.349Z |
5480960 | 5480960 | 20241104111605_IMCAO | NZ003W | 2024-11-06T14:08:03.580Z | 2024-11-13T14:27:23.980Z |
5480661 | 5480661 | 20241105143224_xO2mc | NZ003W | 2024-11-06T14:06:17.093Z | 2024-11-14T14:23:05.450Z |
5480545 | 5480545 | 20241105134346_oOD3h | NZ003W | 2024-11-06T14:05:53.652Z | 2024-11-14T14:23:04.753Z |
5480532 | 5480532 | 20241105133519_uC4H2 | NZ003W | 2024-11-06T14:05:52.377Z | 2024-11-14T14:23:04.612Z |
5480522 | 5480522 | 20241105133050_y3z46 | NZ003W | 2024-11-06T14:05:51.301Z | 2024-11-14T14:23:04.600Z |
5480376 | 5480376 | 20241105123738_EA9vH | NZ003W | 2024-11-06T14:05:22.580Z | 2024-11-14T14:23:03.993Z |
5480302 | 5480302 | 20241105122005_iyBZh | NZ003W | 2024-11-06T14:05:11.714Z | 2024-11-14T14:23:03.721Z |
5480234 | 5480234 | 20241105120506_P99f9 | NZ003W | 2024-11-06T14:05:00.967Z | 2024-11-14T14:23:03.115Z |
5480178 | 5480178 | 20241105115655_gip3a | NZ003W | 2024-11-06T14:04:45.331Z | 2024-11-14T14:23:02.909Z |
5480103 | 5480103 | 20241105113853_HwppM | NZ003W | 2024-11-06T14:04:31.024Z | 2024-11-14T14:23:02.637Z |
5480079 | 5480079 | 20241105113205_JLJr2 | NZ003W | 2024-11-06T14:04:27.440Z | 2024-11-14T14:23:01.922Z |
5480036 | 5480036 | 20241105112434_G34Hz | NZ003W | 2024-11-06T14:04:21.897Z | 2024-11-14T14:23:01.667Z |
5480030 | 5480030 | 20241105112017_AxZ0Y | NZ003W | 2024-11-06T14:04:21.182Z | 2024-11-14T14:23:01.635Z |
5479877 | 5479877 | 20241105105525_5EcmK | NZ003W | 2024-11-06T14:03:47.942Z | 2024-11-14T14:23:00.848Z |
5473899 | 5473899 | 20241103151903_2kgxU | NZ003W | 2024-11-05T14:09:51.636Z | 2024-11-12T14:27:50.183Z |
5473776 | 5473776 | 20241103150134_M1Msm | NZ003W | 2024-11-05T14:09:43.305Z | 2024-11-12T14:27:49.996Z |
5473611 | 5473611 | 20241103143851_eXLSG | NZ003W | 2024-11-05T14:09:12.390Z | 2024-11-12T14:27:49.807Z |
5473595 | 5473595 | 20241103143704_qhaHa | NZ003W | 2024-11-05T14:09:10.585Z | 2024-11-12T14:27:49.777Z |
5473584 | 5473584 | 20241103143554_fdP6n | NZ003W | 2024-11-05T14:09:09.280Z | 2024-11-12T14:27:49.772Z |
5473502 | 5473502 | 20241103142607_ffnIr | NZ003W | 2024-11-05T14:09:01.044Z | 2024-11-12T14:27:49.675Z |
5473233 | 5473233 | 20241103134810_Oddaq | NZ003W | 2024-11-05T14:08:40.510Z | 2024-11-12T14:27:48.284Z |
5473018 | 5473018 | 20241103131510_331Aj | NZ003W | 2024-11-05T14:08:03.913Z | 2024-11-12T14:27:47.572Z |
5472804 | 5472804 | 20241103124459_dlH50 | NZ003W | 2024-11-05T14:07:43.804Z | 2024-11-12T14:27:46.743Z |
5472572 | 5472572 | 20241104154610_cIB3k | NZ003W | 2024-11-05T14:06:16.347Z | 2024-11-13T14:27:26.488Z |
5472517 | 5472517 | 20241104153238_vSEng | NZ003W | 2024-11-05T14:06:02.553Z | 2024-11-13T14:27:26.402Z |
5472266 | 5472266 | 20241104141928_nobwR | NZ003W | 2024-11-05T14:05:32.697Z | 2024-11-13T14:27:26.026Z |
5472252 | 5472252 | 20241104141437_2ErEJ | NZ003W | 2024-11-05T14:05:30.952Z | 2024-11-13T14:27:25.957Z |
5472205 | 5472205 | 20241104140352_9OcWB | NZ003W | 2024-11-05T14:05:26.638Z | 2024-11-13T14:27:25.885Z |
5472128 | 5472128 | 20241104134945_PgOwB | NZ003W | 2024-11-05T14:05:12.805Z | 2024-11-13T14:27:25.720Z |
5472078 | 5472078 | 20241104133454_2O4G2 | NZ003W | 2024-11-05T14:05:04.658Z | 2024-11-13T14:27:25.688Z |
5472013 | 5472013 | 20241104132109_2FLOI | NZ003W | 2024-11-05T14:04:58.131Z | 2024-11-13T14:27:25.576Z |
5472002 | 5472002 | 20241104132058_T85Tv | NZ003W | 2024-11-05T14:04:57.344Z | 2024-11-13T14:27:25.565Z |
5471997 | 5471997 | 20241104132038_D85zP | NZ003W | 2024-11-05T14:04:56.276Z | 2024-11-13T14:27:25.562Z |
5471958 | 5471958 | 20241104130915_LAJEU | NZ003W | 2024-11-05T14:04:53.059Z | 2024-11-13T14:27:25.518Z |
5471929 | 5471929 | 20241104130245_1SCHv | NZ003W | 2024-11-05T14:04:49.163Z | 2024-11-13T14:27:25.475Z |
5471910 | 5471910 | 20241104130057_uJEjT | NZ003W | 2024-11-05T14:04:48.182Z | 2024-11-13T14:27:25.459Z |
5471765 | 5471765 | 20241104123420_u3IjM | NZ003W | 2024-11-05T14:04:34.041Z | 2024-11-13T14:27:25.070Z |
5471759 | 5471759 | 20241104123414_W04ZE | NZ003W | 2024-11-05T14:04:33.650Z | 2024-11-13T14:27:25.069Z |
5471581 | 5471581 | 20241104120537_fGORq | NZ003W | 2024-11-05T14:03:58.580Z | 2024-11-13T14:27:24.757Z |
5471537 | 5471537 | 20241104120048_2a78O | NZ003W | 2024-11-05T14:03:54.003Z | 2024-11-13T14:27:24.447Z |
5471397 | 5471397 | 20241104113840_43Eh8 | NZ003W | 2024-11-05T14:03:40.485Z | 2024-11-13T14:27:24.191Z |
5470984 | 5470984 | 20241104102333_fVeAw | NZ003W | 2024-11-05T14:02:26.647Z | 2024-11-13T14:27:23.346Z |
5470781 | 5470781 | 20241104094657_pN9HZ | NZ003W | 2024-11-05T14:01:50.933Z | 2024-11-13T14:27:22.912Z |
5470633 | 5470633 | 20241104091225_7DUuY | NZ003W | 2024-11-05T14:01:21.526Z | 2024-11-13T14:27:22.523Z |
5470587 | 5470587 | 20241104085547_t4B3I | NZ003W | 2024-11-05T14:01:09.824Z | 2024-11-13T14:27:22.433Z |
5465486 | 5465486 | 20241103121200_jadz3 | NZ003W | 2024-11-04T14:03:48.319Z | 2024-11-12T14:27:46.257Z |
5465217 | 5465217 | 20241103110258_R8x1e | NZ003W | 2024-11-04T14:03:05.684Z | 2024-11-12T14:27:45.389Z |
5465154 | 5465154 | 20241103105138_mX2ka | NZ003W | 2024-11-04T14:02:57.857Z | 2024-11-12T14:27:45.251Z |
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);