participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
431 rows where station_code = "CZ000J" 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 |
---|---|---|---|---|---|
5063447 | 5063447 | 20240909211634_WAfs1 | CZ000J | 2024-09-14T12:14:00.440Z | 2024-09-18T12:15:13.929Z |
4970061 | 4970061 | 20240811222028_hCi4m | CZ000J | 2024-09-05T12:09:17.792Z | 2024-09-06T12:08:19.616Z |
4969511 | 4969511 | 20240811221234_iq0pd | CZ000J | 2024-09-05T12:08:47.208Z | 2024-09-06T12:07:53.852Z |
4968992 | 4968992 | 20240811220535_RWNrk | CZ000J | 2024-09-05T12:08:33.055Z | 2024-09-06T12:07:40.949Z |
4968668 | 4968668 | 20240811220122_uYlr8 | CZ000J | 2024-09-05T12:08:24.293Z | 2024-09-06T12:07:34.062Z |
4968613 | 4968613 | 20240811220007_s9LtU | CZ000J | 2024-09-05T12:08:23.013Z | 2024-09-06T12:07:33.033Z |
4968370 | 4968370 | 20240811215708_Z3oSv | CZ000J | 2024-09-05T12:08:15.016Z | 2024-09-06T12:07:28.877Z |
4967959 | 4967959 | 20240811215229_psGuI | CZ000J | 2024-09-05T12:07:54.954Z | 2024-09-06T12:07:17.669Z |
4967943 | 4967943 | 20240811215219_aXig6 | CZ000J | 2024-09-05T12:07:54.384Z | 2024-09-06T12:07:17.028Z |
4964929 | 4964929 | 20240811210525_oULOf | CZ000J | 2024-09-04T12:06:39.016Z | 2024-09-06T12:05:43.296Z |
4964728 | 4964728 | 20240811210151_NFe3M | CZ000J | 2024-09-04T12:06:32.255Z | 2024-09-06T12:05:31.863Z |
4964387 | 4964387 | 20240811205337_WgfXw | CZ000J | 2024-09-04T12:06:20.129Z | 2024-09-06T12:05:18.937Z |
4964375 | 4964375 | 20240811205309_TSTk1 | CZ000J | 2024-09-04T12:06:19.501Z | 2024-09-06T12:05:18.451Z |
4963877 | 4963877 | 20240811203927_AIweQ | CZ000J | 2024-09-04T12:05:59.242Z | 2024-09-06T12:05:04.426Z |
4963555 | 4963555 | 20240811202034_ppqr8 | CZ000J | 2024-09-04T12:05:41.837Z | 2024-09-06T12:04:43.746Z |
4963534 | 4963534 | 20240811201850_2JyLv | CZ000J | 2024-09-04T12:05:39.169Z | 2024-09-06T12:04:42.980Z |
4963457 | 4963457 | 20240811201233_xLZ9g | CZ000J | 2024-09-04T12:05:35.723Z | 2024-09-06T12:04:40.309Z |
4963323 | 4963323 | 20240811195811_J3dqt | CZ000J | 2024-09-04T12:05:27.287Z | 2024-09-06T12:04:29.318Z |
4963268 | 4963268 | 20240811195229_LHfYM | CZ000J | 2024-09-04T12:05:23.684Z | 2024-09-06T12:04:26.794Z |
4937827 | 4937827 | 20240810220126_4d0ew | CZ000J | 2024-09-01T12:08:38.764Z | 2024-09-06T12:22:32.734Z |
4937745 | 4937745 | 20240810215851_aJLfQ | CZ000J | 2024-09-01T12:08:35.083Z | 2024-09-06T12:22:28.625Z |
4937679 | 4937679 | 20240810215726_woJdv | CZ000J | 2024-09-01T12:08:32.630Z | 2024-09-06T12:22:26.237Z |
4937449 | 4937449 | 20240810215024_U2TX5 | CZ000J | 2024-09-01T12:08:17.289Z | 2024-09-06T12:22:15.686Z |
4937375 | 4937375 | 20240810214749_VUin2 | CZ000J | 2024-09-01T12:08:12.743Z | 2024-09-06T12:22:10.573Z |
4937039 | 4937039 | 20240810213811_cBI0e | CZ000J | 2024-09-01T12:08:00.717Z | 2024-09-06T12:21:56.990Z |
4937034 | 4937034 | 20240810213809_zxCja | CZ000J | 2024-09-01T12:08:00.508Z | 2024-09-06T12:21:56.900Z |
4936609 | 4936609 | 20240810212410_6fn2K | CZ000J | 2024-09-01T12:07:38.093Z | 2024-09-06T12:21:41.772Z |
4936405 | 4936405 | 20240810211543_lobiN | CZ000J | 2024-09-01T12:07:29.706Z | 2024-09-06T12:21:31.903Z |
4936120 | 4936120 | 20240810210140_nIj2p | CZ000J | 2024-09-01T12:07:08.231Z | 2024-09-06T12:21:15.251Z |
4936117 | 4936117 | 20240810210133_5e21s | CZ000J | 2024-09-01T12:07:08.102Z | 2024-09-06T12:21:14.884Z |
4936000 | 4936000 | 20240810205628_eRTeo | CZ000J | 2024-09-01T12:07:04.110Z | 2024-09-06T12:21:11.465Z |
4935915 | 4935915 | 20240810205213_6J3Ki | CZ000J | 2024-09-01T12:07:00.146Z | 2024-09-06T12:21:07.747Z |
4935772 | 4935772 | 20240810204322_3buGe | CZ000J | 2024-09-01T12:06:52.448Z | 2024-09-06T12:20:56.326Z |
4935625 | 4935625 | 20240810203430_hDxq9 | CZ000J | 2024-09-01T12:06:41.216Z | 2024-09-06T12:20:49.019Z |
4935573 | 4935573 | 20240810202842_QhAIZ | CZ000J | 2024-09-01T12:06:36.884Z | 2024-09-06T12:20:45.797Z |
4935488 | 4935488 | 20240810202241_BDpFg | CZ000J | 2024-09-01T12:06:32.743Z | 2024-09-06T12:20:41.748Z |
4935217 | 4935217 | 20240810195054_ldJzP | CZ000J | 2024-09-01T12:06:12.733Z | 2024-09-06T12:20:32.134Z |
4935113 | 4935113 | 20240810194128_gg5FY | CZ000J | 2024-09-01T12:06:05.703Z | 2024-09-06T12:20:27.610Z |
4914467 | 4914467 | 20240809222030_lJzZe | CZ000J | 2024-08-30T12:09:12.548Z | 2024-09-02T12:23:31.437Z |
4913848 | 4913848 | 20240809215730_eL6r0 | CZ000J | 2024-08-30T12:08:41.497Z | 2024-09-02T12:23:05.426Z |
4913401 | 4913401 | 20240809214713_37trt | CZ000J | 2024-08-29T12:09:10.446Z | 2024-09-02T12:22:52.988Z |
4913342 | 4913342 | 20240809214602_3yxRd | CZ000J | 2024-08-29T12:09:05.485Z | 2024-09-02T12:22:48.953Z |
4911532 | 4911532 | 20240809201352_FLbT3 | CZ000J | 2024-08-29T12:07:32.566Z | 2024-09-02T12:21:49.072Z |
4758783 | 4758783 | 20240730221935_RgCWO | CZ000J | 2024-08-05T12:14:41.170Z | 2024-08-08T12:23:42.912Z |
4758290 | 4758290 | 20240730214956_z2ODk | CZ000J | 2024-08-05T12:14:14.011Z | 2024-08-08T12:23:24.468Z |
4758138 | 4758138 | 20240730214132_K1ttN | CZ000J | 2024-08-05T12:14:05.434Z | 2024-08-08T12:23:16.074Z |
4757759 | 4757759 | 20240730211309_fMhDs | CZ000J | 2024-08-05T12:13:39.477Z | 2024-08-08T12:23:01.361Z |
4757360 | 4757360 | 20240730202151_ZVz8J | CZ000J | 2024-08-05T12:13:11.774Z | 2024-08-08T12:22:44.017Z |
4748327 | 4748327 | 20240729221247_4k1R2 | CZ000J | 2024-08-04T12:15:12.815Z | 2024-08-06T12:15:24.482Z |
4748226 | 4748226 | 20240729220857_gfLc3 | CZ000J | 2024-08-04T12:15:10.414Z | 2024-08-06T12:15:24.368Z |
4748121 | 4748121 | 20240729220436_7ZU4A | CZ000J | 2024-08-04T12:15:05.601Z | 2024-08-06T12:15:23.989Z |
4747458 | 4747458 | 20240729212441_wxmJQ | CZ000J | 2024-08-04T12:14:43.470Z | 2024-08-06T12:15:21.377Z |
4747362 | 4747362 | 20240729211746_jS2GB | CZ000J | 2024-08-04T12:14:40.616Z | 2024-08-06T12:15:21.041Z |
4727302 | 4727302 | 20240728211024_253R2 | CZ000J | 2024-07-31T12:12:54.536Z | 2024-08-05T12:20:26.059Z |
4727116 | 4727116 | 20240728202619_vK7WN | CZ000J | 2024-07-31T12:12:47.249Z | 2024-08-05T12:20:25.326Z |
4689424 | 4689424 | 20240725204057_IlI9j | CZ000J | 2024-07-27T12:00:29.156Z | 2024-08-03T12:21:00.283Z |
4689419 | 4689419 | 20240725203928_6HkjG | CZ000J | 2024-07-27T12:00:28.688Z | 2024-08-03T12:21:00.224Z |
4670830 | 4670830 | 20240719215115_OOT4P | CZ000J | 2024-07-21T12:01:59.382Z | 2024-07-28T12:14:50.972Z |
4664422 | 4664422 | 20240717014302_k5PAn | CZ000J | 2024-07-19T12:08:58.188Z | 2024-07-25T12:14:07.136Z |
4664340 | 4664340 | 20240717013058_a8AuA | CZ000J | 2024-07-19T12:08:52.983Z | 2024-07-25T12:14:06.477Z |
4662400 | 4662400 | 20240718005635_c0e6I | CZ000J | 2024-07-19T12:04:30.306Z | 2024-07-26T12:17:41.832Z |
4662276 | 4662276 | 20240718003920_BCR3h | CZ000J | 2024-07-19T12:04:19.361Z | 2024-07-26T12:17:39.102Z |
4662108 | 4662108 | 20240718001332_khmqz | CZ000J | 2024-07-19T12:04:09.192Z | 2024-07-26T12:17:36.451Z |
4661986 | 4661986 | 20240718000257_zVv1r | CZ000J | 2024-07-19T12:04:02.855Z | 2024-07-26T12:17:35.590Z |
4661919 | 4661919 | 20240717235312_wiGTw | CZ000J | 2024-07-19T12:03:58.494Z | 2024-07-26T12:17:34.704Z |
4661856 | 4661856 | 20240717234746_xnTRk | CZ000J | 2024-07-19T12:03:51.156Z | 2024-07-26T12:17:33.978Z |
4661521 | 4661521 | 20240717230201_r5Snp | CZ000J | 2024-07-19T12:03:17.523Z | 2024-07-26T12:17:31.165Z |
4661380 | 4661380 | 20240717222725_7BWpd | CZ000J | 2024-07-19T12:03:06.676Z | 2024-07-26T12:17:29.792Z |
4661325 | 4661325 | 20240717221550_Wg7XK | CZ000J | 2024-07-19T12:03:02.963Z | 2024-07-26T12:17:28.863Z |
4661205 | 4661205 | 20240717215254_CKFfU | CZ000J | 2024-07-19T12:02:54.998Z | 2024-07-26T12:17:26.045Z |
4655257 | 4655257 | 20240717002134_tQs7r | CZ000J | 2024-07-18T12:05:46.300Z | 2024-07-25T12:14:01.006Z |
4655175 | 4655175 | 20240717001700_xui3L | CZ000J | 2024-07-18T12:05:42.799Z | 2024-07-25T12:14:00.663Z |
4655166 | 4655166 | 20240717001602_dTrIV | CZ000J | 2024-07-18T12:05:42.045Z | 2024-07-25T12:14:00.598Z |
4655154 | 4655154 | 20240717001457_ck0DV | CZ000J | 2024-07-18T12:05:41.217Z | 2024-07-25T12:14:00.485Z |
4655153 | 4655153 | 20240717001451_y80Mm | CZ000J | 2024-07-18T12:05:41.015Z | 2024-07-25T12:14:00.475Z |
4655074 | 4655074 | 20240717000735_Eg0Kt | CZ000J | 2024-07-18T12:05:29.826Z | 2024-07-25T12:13:59.494Z |
4648775 | 4648775 | 20240715001204_C1vjT | CZ000J | 2024-07-17T12:08:14.748Z | 2024-07-23T12:08:44.128Z |
4611547 | 4611547 | 20240710003928_yR6OK | CZ000J | 2024-07-12T12:06:54.996Z | 2024-07-18T12:16:58.197Z |
4611536 | 4611536 | 20240710003631_AxF2q | CZ000J | 2024-07-12T12:06:54.643Z | 2024-07-18T12:16:58.080Z |
4610955 | 4610955 | 20240709205219_y3PKg | CZ000J | 2024-07-12T12:06:27.450Z | 2024-07-18T12:16:53.123Z |
4602895 | 4602895 | 20240709000703_XfOol | CZ000J | 2024-07-11T12:09:54.665Z | 2024-07-16T12:09:25.854Z |
4602672 | 4602672 | 20240708230249_UuEuj | CZ000J | 2024-07-11T12:09:35.556Z | 2024-07-16T12:09:24.530Z |
4602568 | 4602568 | 20240708222857_bw2zC | CZ000J | 2024-07-11T12:09:25.585Z | 2024-07-16T12:09:23.992Z |
4595326 | 4595326 | 20240707230928_Ny96v | CZ000J | 2024-07-10T12:10:59.731Z | 2024-07-15T12:12:26.354Z |
4595193 | 4595193 | 20240707230156_1T1DW | CZ000J | 2024-07-10T12:10:54.946Z | 2024-07-15T12:12:25.513Z |
4594859 | 4594859 | 20240707222324_tLAKu | CZ000J | 2024-07-10T12:10:34.519Z | 2024-07-15T12:12:24.210Z |
4570204 | 4570204 | 20240705233717_4dauj | CZ000J | 2024-07-08T12:01:29.620Z | 2024-07-14T12:13:49.466Z |
4569850 | 4569850 | 20240705222357_s33eq | CZ000J | 2024-07-08T12:00:37.643Z | 2024-07-14T12:13:47.361Z |
4534754 | 4534754 | 20240702005308_hR5jX | CZ000J | 2024-07-03T12:01:38.726Z | 2024-07-10T12:15:25.281Z |
4521408 | 4521408 | 20240629004851_3om3B | CZ000J | 2024-06-30T12:04:50.097Z | 2024-07-07T12:13:49.118Z |
4521399 | 4521399 | 20240629004758_CiuTA | CZ000J | 2024-06-30T12:04:49.638Z | 2024-07-07T12:13:49.106Z |
4521284 | 4521284 | 20240629004055_PGefl | CZ000J | 2024-06-30T12:04:46.527Z | 2024-07-07T12:13:48.922Z |
4521083 | 4521083 | 20240629001954_0o22m | CZ000J | 2024-06-30T12:04:38.481Z | 2024-07-07T12:13:48.534Z |
4520450 | 4520450 | 20240628232503_x3QA5 | CZ000J | 2024-06-30T12:04:03.729Z | 2024-07-07T12:13:47.525Z |
4519985 | 4519985 | 20240628224640_4O72f | CZ000J | 2024-06-30T12:03:38.662Z | 2024-07-07T12:13:46.562Z |
4514595 | 4514595 | 20240628005434_VojND | CZ000J | 2024-06-29T12:06:49.261Z | 2024-07-06T12:16:27.681Z |
4504401 | 4504401 | 20240625231321_diefk | CZ000J | 2024-06-27T12:03:41.496Z | 2024-07-04T12:08:50.590Z |
4504289 | 4504289 | 20240625230217_L8RXH | CZ000J | 2024-06-27T12:03:34.811Z | 2024-07-04T12:08:49.787Z |
4504012 | 4504012 | 20240625222450_CHD83 | CZ000J | 2024-06-27T12:03:07.454Z | 2024-07-04T12:08:48.039Z |
4501159 | 4501159 | 20240625004504_t2iXE | CZ000J | 2024-06-26T12:04:48.585Z | 2024-07-03T12:13:17.349Z |
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);