participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,627 rows where station_code = "NZ001X" 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 |
---|---|---|---|---|---|
5494066 | 5494066 | 20241107152612_TvXUM | NZ001X | 2024-11-08T14:05:19.528Z | 2024-11-08T14:05:19.528Z |
5494000 | 5494000 | 20241107150728_5pZla | NZ001X | 2024-11-08T14:05:14.000Z | 2024-11-08T14:05:14.000Z |
5493962 | 5493962 | 20241107145248_B4frt | NZ001X | 2024-11-08T14:05:05.457Z | 2024-11-08T14:05:05.457Z |
5493955 | 5493955 | 20241107144806_foIcm | NZ001X | 2024-11-08T14:05:03.569Z | 2024-11-08T14:05:03.569Z |
5493871 | 5493871 | 20241107142309_3Xt6E | NZ001X | 2024-11-08T14:04:48.092Z | 2024-11-08T14:04:48.092Z |
5493822 | 5493822 | 20241107135756_X59io | NZ001X | 2024-11-08T14:04:41.924Z | 2024-11-08T14:04:41.924Z |
5493683 | 5493683 | 20241107130104_CrKmw | NZ001X | 2024-11-08T14:04:29.351Z | 2024-11-08T14:04:29.351Z |
5493638 | 5493638 | 20241107125124_mZOvf | NZ001X | 2024-11-08T14:04:24.686Z | 2024-11-08T14:04:24.686Z |
5493597 | 5493597 | 20241107124354_lbXlt | NZ001X | 2024-11-08T14:04:14.707Z | 2024-11-08T14:04:14.707Z |
5493575 | 5493575 | 20241107123858_leMvU | NZ001X | 2024-11-08T14:04:08.990Z | 2024-11-08T14:04:08.990Z |
5493529 | 5493529 | 20241107122650_qziM3 | NZ001X | 2024-11-08T14:03:59.362Z | 2024-11-08T14:03:59.362Z |
5493501 | 5493501 | 20241107122302_uh70z | NZ001X | 2024-11-08T14:03:53.596Z | 2024-11-08T14:03:53.596Z |
5493248 | 5493248 | 20241107112537_4fo8b | NZ001X | 2024-11-08T14:03:19.455Z | 2024-11-08T14:03:19.455Z |
5493189 | 5493189 | 20241107111531_tr1b2 | NZ001X | 2024-11-08T14:03:05.294Z | 2024-11-08T14:03:05.294Z |
5493131 | 5493131 | 20241107110132_3r7bN | NZ001X | 2024-11-08T14:02:56.242Z | 2024-11-08T14:02:56.242Z |
5493051 | 5493051 | 20241107104327_5tf6m | NZ001X | 2024-11-08T14:02:46.562Z | 2024-11-08T14:02:46.562Z |
5492908 | 5492908 | 20241107101856_z21jn | NZ001X | 2024-11-08T14:02:31.759Z | 2024-11-08T14:02:31.759Z |
5492573 | 5492573 | 20241107090748_BmotK | NZ001X | 2024-11-08T14:01:29.130Z | 2024-11-08T14:01:29.130Z |
5473727 | 5473727 | 20241103145521_7Oh3W | NZ001X | 2024-11-05T14:09:35.541Z | 2024-11-08T14:19:18.629Z |
5473714 | 5473714 | 20241103145313_bpT4B | NZ001X | 2024-11-05T14:09:30.731Z | 2024-11-08T14:19:18.474Z |
5473201 | 5473201 | 20241103134038_x0319 | NZ001X | 2024-11-05T14:08:33.574Z | 2024-11-08T14:19:14.173Z |
5473169 | 5473169 | 20241103133648_fYW8X | NZ001X | 2024-11-05T14:08:27.730Z | 2024-11-08T14:19:13.858Z |
5473027 | 5473027 | 20241103131630_JsLDo | NZ001X | 2024-11-05T14:08:04.096Z | 2024-11-08T14:19:12.821Z |
5465416 | 5465416 | 20241103115239_jljM3 | NZ001X | 2024-11-04T14:03:40.907Z | 2024-11-08T14:19:08.489Z |
5465346 | 5465346 | 20241103113159_YixNK | NZ001X | 2024-11-04T14:03:32.417Z | 2024-11-08T14:19:07.751Z |
5464761 | 5464761 | 20241103090735_Sgb8Z | NZ001X | 2024-11-04T14:01:36.442Z | 2024-11-08T14:19:00.833Z |
5461022 | 5461022 | 20241101153700_pWZ2r | NZ001X | 2024-11-03T14:14:39.627Z | 2024-11-08T14:21:40.929Z |
5460386 | 5460386 | 20241101140145_SPyWH | NZ001X | 2024-11-03T14:13:41.049Z | 2024-11-08T14:21:38.564Z |
5460310 | 5460310 | 20241101134100_zl9MB | NZ001X | 2024-11-03T14:13:34.966Z | 2024-11-08T14:21:38.423Z |
5460016 | 5460016 | 20241101123023_1PsXT | NZ001X | 2024-11-03T14:13:07.945Z | 2024-11-08T14:21:36.149Z |
5459959 | 5459959 | 20241101122409_8hdCA | NZ001X | 2024-11-03T14:12:58.215Z | 2024-11-08T14:21:35.521Z |
5459740 | 5459740 | 20241101114648_6O7A3 | NZ001X | 2024-11-03T14:12:32.381Z | 2024-11-08T14:21:33.294Z |
5457025 | 5457025 | 20241102131504_YV0W4 | NZ001X | 2024-11-03T14:06:23.451Z | 2024-11-08T14:20:37.300Z |
5456998 | 5456998 | 20241102131239_2i1ty | NZ001X | 2024-11-03T14:06:20.387Z | 2024-11-08T14:20:37.160Z |
5437934 | 5437934 | 20241030160400_pGTaU | NZ001X | 2024-11-01T12:10:44.461Z | 2024-11-08T14:22:58.492Z |
5437653 | 5437653 | 20241030153222_PTpzY | NZ001X | 2024-11-01T12:10:09.360Z | 2024-11-08T14:22:57.619Z |
5437611 | 5437611 | 20241030152745_PrYS5 | NZ001X | 2024-11-01T12:10:05.298Z | 2024-11-08T14:22:57.579Z |
5437256 | 5437256 | 20241030144829_3GR96 | NZ001X | 2024-11-01T12:09:18.164Z | 2024-11-08T14:22:56.795Z |
5437192 | 5437192 | 20241030143958_n2g2p | NZ001X | 2024-11-01T12:09:13.311Z | 2024-11-08T14:22:56.762Z |
5437053 | 5437053 | 20241030142343_HvFjY | NZ001X | 2024-11-01T12:08:48.570Z | 2024-11-08T14:22:56.427Z |
5436647 | 5436647 | 20241030133058_yE1v3 | NZ001X | 2024-11-01T12:08:01.063Z | 2024-11-08T14:22:54.566Z |
5436607 | 5436607 | 20241030132752_T7qHd | NZ001X | 2024-11-01T12:07:57.412Z | 2024-11-08T14:22:54.500Z |
5436423 | 5436423 | 20241030130522_h75Vy | NZ001X | 2024-11-01T12:07:32.478Z | 2024-11-08T14:22:54.036Z |
5436403 | 5436403 | 20241030130200_9zRTQ | NZ001X | 2024-11-01T12:07:29.155Z | 2024-11-08T14:22:54.028Z |
5436254 | 5436254 | 20241030124207_u3eLk | NZ001X | 2024-11-01T12:07:10.888Z | 2024-11-08T14:22:53.623Z |
5435811 | 5435811 | 20241030115901_YoPJJ | NZ001X | 2024-11-01T12:05:57.794Z | 2024-11-08T14:22:51.752Z |
5435775 | 5435775 | 20241030115553_X1R0q | NZ001X | 2024-11-01T12:05:52.678Z | 2024-11-08T14:22:51.697Z |
5435672 | 5435672 | 20241030114908_BWKAm | NZ001X | 2024-11-01T12:05:44.954Z | 2024-11-08T14:22:51.350Z |
5435333 | 5435333 | 20241030111851_Becwl | NZ001X | 2024-11-01T12:04:56.043Z | 2024-11-08T14:22:50.235Z |
5435029 | 5435029 | 20241030104035_I8T2t | NZ001X | 2024-11-01T12:04:00.991Z | 2024-11-08T14:22:48.972Z |
5434811 | 5434811 | 20241030101539_5pN3A | NZ001X | 2024-11-01T12:03:27.482Z | 2024-11-08T14:22:47.932Z |
5434703 | 5434703 | 20241030100441_3sOi9 | NZ001X | 2024-11-01T12:03:11.257Z | 2024-11-08T14:22:47.463Z |
5427233 | 5427233 | 20241028144817_AItiK | NZ001X | 2024-10-31T12:13:21.622Z | 2024-11-06T14:27:11.534Z |
5426733 | 5426733 | 20241028135041_DMNs2 | NZ001X | 2024-10-31T12:12:25.094Z | 2024-11-06T14:27:10.586Z |
5425016 | 5425016 | 20241029154049_bMVdK | NZ001X | 2024-10-31T12:06:40.678Z | 2024-11-07T14:26:33.436Z |
5422652 | 5422652 | 20241028132504_tKW2R | NZ001X | 2024-10-30T12:20:29.435Z | 2024-11-06T14:27:10.371Z |
5422505 | 5422505 | 20241028130917_lztZ3 | NZ001X | 2024-10-30T12:20:27.333Z | 2024-11-06T14:27:10.256Z |
5421856 | 5421856 | 20241028115013_3N52c | NZ001X | 2024-10-30T12:20:16.421Z | 2024-11-06T14:27:08.588Z |
5421721 | 5421721 | 20241028112622_uD5HK | NZ001X | 2024-10-30T12:20:13.485Z | 2024-11-06T14:27:08.351Z |
5421691 | 5421691 | 20241028112203_Z3xp6 | NZ001X | 2024-10-30T12:20:12.711Z | 2024-11-06T14:27:08.299Z |
5421666 | 5421666 | 20241028111831_SCRzu | NZ001X | 2024-10-30T12:20:11.636Z | 2024-11-06T14:27:08.221Z |
5416158 | 5416158 | 20241027152301_ii1KQ | NZ001X | 2024-10-30T12:11:10.428Z | 2024-11-05T14:27:04.391Z |
5415353 | 5415353 | 20241027134334_QL70C | NZ001X | 2024-10-30T12:09:36.717Z | 2024-11-05T14:27:03.582Z |
5415247 | 5415247 | 20241027132719_IhfPk | NZ001X | 2024-10-30T12:09:24.783Z | 2024-11-05T14:27:03.402Z |
5392295 | 5392295 | 20241026154821_ez5jx | NZ001X | 2024-10-28T12:07:40.935Z | 2024-11-04T14:28:38.062Z |
5392287 | 5392287 | 20241026154735_9aEo9 | NZ001X | 2024-10-28T12:07:40.300Z | 2024-11-04T14:28:38.048Z |
5392255 | 5392255 | 20241026153904_rYanp | NZ001X | 2024-10-28T12:07:30.077Z | 2024-11-04T14:28:37.742Z |
5392180 | 5392180 | 20241026152640_F5cFj | NZ001X | 2024-10-28T12:07:18.440Z | 2024-11-04T14:28:37.491Z |
5392175 | 5392175 | 20241026152603_32SX0 | NZ001X | 2024-10-28T12:07:17.992Z | 2024-11-04T14:28:37.479Z |
5391995 | 5391995 | 20241026143225_8VTu3 | NZ001X | 2024-10-28T12:07:00.767Z | 2024-11-04T14:28:37.150Z |
5391871 | 5391871 | 20241026135537_IyAB6 | NZ001X | 2024-10-28T12:06:40.902Z | 2024-11-04T14:28:36.832Z |
5391460 | 5391460 | 20241026115903_C4lvE | NZ001X | 2024-10-28T12:05:38.103Z | 2024-11-04T14:28:34.924Z |
5391333 | 5391333 | 20241026114053_PYU3q | NZ001X | 2024-10-28T12:05:14.648Z | 2024-11-04T14:28:34.256Z |
5391185 | 5391185 | 20241026112119_L11qx | NZ001X | 2024-10-28T12:04:51.487Z | 2024-11-04T14:28:33.708Z |
5382123 | 5382123 | 20241024160458_VUcDD | NZ001X | 2024-10-27T12:13:14.090Z | 2024-11-02T12:28:23.470Z |
5381981 | 5381981 | 20241024155425_O52BB | NZ001X | 2024-10-27T12:13:05.751Z | 2024-11-02T12:28:23.343Z |
5381891 | 5381891 | 20241024154721_9PqLD | NZ001X | 2024-10-27T12:12:59.269Z | 2024-11-02T12:28:23.257Z |
5381877 | 5381877 | 20241024154612_mSe2v | NZ001X | 2024-10-27T12:12:56.115Z | 2024-11-02T12:28:23.236Z |
5381701 | 5381701 | 20241024153142_E1B1R | NZ001X | 2024-10-27T12:12:27.976Z | 2024-11-02T12:28:23.066Z |
5371871 | 5371871 | 20241024152745_iZtVV | NZ001X | 2024-10-26T12:12:49.798Z | 2024-11-02T12:28:23.040Z |
5371869 | 5371869 | 20241024152729_a3T0t | NZ001X | 2024-10-26T12:12:49.640Z | 2024-11-02T12:28:23.037Z |
5371377 | 5371377 | 20241024144923_Cplwq | NZ001X | 2024-10-26T12:11:50.746Z | 2024-11-02T12:28:22.126Z |
5371371 | 5371371 | 20241024144621_MNzeR | NZ001X | 2024-10-26T12:11:48.617Z | 2024-11-02T12:28:22.102Z |
5370684 | 5370684 | 20241024133808_sXMZp | NZ001X | 2024-10-26T12:10:09.769Z | 2024-11-02T12:28:21.054Z |
5370601 | 5370601 | 20241024132928_XSpoA | NZ001X | 2024-10-26T12:09:59.634Z | 2024-11-02T12:28:20.952Z |
5370449 | 5370449 | 20241024130643_rdI3y | NZ001X | 2024-10-26T12:09:41.508Z | 2024-11-02T12:28:20.742Z |
5370315 | 5370315 | 20241024125347_VkERe | NZ001X | 2024-10-26T12:09:16.168Z | 2024-11-02T12:28:20.599Z |
5370048 | 5370048 | 20241024122024_hkl25 | NZ001X | 2024-10-26T12:08:32.533Z | 2024-11-02T12:28:19.812Z |
5369492 | 5369492 | 20241024113409_MbYO4 | NZ001X | 2024-10-26T12:07:02.895Z | 2024-11-02T12:28:18.651Z |
5369489 | 5369489 | 20241024113409_RizNG | NZ001X | 2024-10-26T12:07:02.604Z | 2024-11-02T12:28:18.634Z |
5369390 | 5369390 | 20241024112428_1V9gB | NZ001X | 2024-10-26T12:06:51.095Z | 2024-11-02T12:28:18.470Z |
5347579 | 5347579 | 20241022154450_VKmUx | NZ001X | 2024-10-24T12:08:29.864Z | 2024-10-31T12:29:50.732Z |
5347517 | 5347517 | 20241022153207_dJ29g | NZ001X | 2024-10-24T12:08:19.203Z | 2024-10-31T12:29:50.639Z |
5347507 | 5347507 | 20241022153032_g1KNs | NZ001X | 2024-10-24T12:08:18.203Z | 2024-10-31T12:29:50.629Z |
5347476 | 5347476 | 20241022152239_3v2Fl | NZ001X | 2024-10-24T12:08:15.229Z | 2024-10-31T12:29:50.529Z |
5347380 | 5347380 | 20241022150500_OsOUo | NZ001X | 2024-10-24T12:07:49.303Z | 2024-10-31T12:29:50.411Z |
5331658 | 5331658 | 20241021150852_VZSJB | NZ001X | 2024-10-22T12:09:25.346Z | 2024-10-30T12:26:39.870Z |
5331442 | 5331442 | 20241021143529_knZ7n | NZ001X | 2024-10-22T12:09:02.806Z | 2024-10-30T12:26:39.499Z |
5331440 | 5331440 | 20241021143527_M5Jb4 | NZ001X | 2024-10-22T12:09:02.652Z | 2024-10-30T12:26:39.495Z |
5330737 | 5330737 | 20241021123658_WL2hU | NZ001X | 2024-10-22T12:07:32.850Z | 2024-10-30T12:26:38.306Z |
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);