participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,574 rows where station_code = "CZ000D" 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 |
---|---|---|---|---|---|
4983396 | 4983396 | 20240812004407_I5n38 | CZ000D | 2024-09-06T12:15:31.105Z | 2024-09-06T12:15:31.105Z |
4983392 | 4983392 | 20240812004401_ohUua | CZ000D | 2024-09-06T12:15:30.857Z | 2024-09-06T12:15:30.857Z |
4983146 | 4983146 | 20240812004149_oSBCv | CZ000D | 2024-09-06T12:15:17.528Z | 2024-09-06T12:15:17.528Z |
4983124 | 4983124 | 20240812004129_IOAni | CZ000D | 2024-09-06T12:15:15.910Z | 2024-09-06T12:15:15.910Z |
4982508 | 4982508 | 20240812003423_NtOw4 | CZ000D | 2024-09-06T12:14:54.330Z | 2024-09-06T12:14:54.330Z |
4982498 | 4982498 | 20240812003417_3pT7O | CZ000D | 2024-09-06T12:14:53.907Z | 2024-09-06T12:14:53.907Z |
4982458 | 4982458 | 20240812003337_gdFbU | CZ000D | 2024-09-06T12:14:51.071Z | 2024-09-06T12:14:51.071Z |
4982056 | 4982056 | 20240812002942_9rt8u | CZ000D | 2024-09-06T12:14:42.055Z | 2024-09-06T12:14:42.055Z |
4981543 | 4981543 | 20240812002322_z2qr0 | CZ000D | 2024-09-06T12:14:33.067Z | 2024-09-06T12:14:33.067Z |
4981497 | 4981497 | 20240812002248_w7xsz | CZ000D | 2024-09-06T12:14:32.590Z | 2024-09-06T12:14:32.590Z |
4980970 | 4980970 | 20240812001756_yL8It | CZ000D | 2024-09-06T12:14:25.165Z | 2024-09-06T12:14:25.165Z |
4980577 | 4980577 | 20240812001402_Zz6ps | CZ000D | 2024-09-06T12:14:06.089Z | 2024-09-06T12:14:06.089Z |
4980446 | 4980446 | 20240812001226_J1aNR | CZ000D | 2024-09-06T12:14:00.403Z | 2024-09-06T12:14:00.403Z |
4980384 | 4980384 | 20240812001150_h9hbL | CZ000D | 2024-09-06T12:13:57.507Z | 2024-09-06T12:13:57.507Z |
4980176 | 4980176 | 20240812000933_ge3zW | CZ000D | 2024-09-06T12:13:49.833Z | 2024-09-06T12:13:49.833Z |
4980170 | 4980170 | 20240812000933_hjPaW | CZ000D | 2024-09-06T12:13:49.650Z | 2024-09-06T12:13:49.650Z |
4979774 | 4979774 | 20240812000438_2fxgy | CZ000D | 2024-09-06T12:13:27.187Z | 2024-09-06T12:13:27.187Z |
4979664 | 4979664 | 20240812000325_pAPjn | CZ000D | 2024-09-06T12:13:20.458Z | 2024-09-06T12:13:20.458Z |
4979058 | 4979058 | 20240811235852_xAiWW | CZ000D | 2024-09-06T12:12:54.976Z | 2024-09-06T12:12:54.976Z |
4978999 | 4978999 | 20240811235819_q1SP1 | CZ000D | 2024-09-06T12:12:51.550Z | 2024-09-06T12:12:51.550Z |
4978043 | 4978043 | 20240811234723_qAYK3 | CZ000D | 2024-09-06T12:12:28.347Z | 2024-09-06T12:12:28.347Z |
4977841 | 4977841 | 20240811234508_lt7qX | CZ000D | 2024-09-06T12:12:23.993Z | 2024-09-06T12:12:23.993Z |
4977663 | 4977663 | 20240811234316_9gTsR | CZ000D | 2024-09-06T12:12:21.654Z | 2024-09-06T12:12:21.654Z |
4977456 | 4977456 | 20240811233954_vi6ol | CZ000D | 2024-09-06T12:12:17.136Z | 2024-09-06T12:12:17.136Z |
4977165 | 4977165 | 20240811233646_CVwAt | CZ000D | 2024-09-06T12:12:05.906Z | 2024-09-06T12:12:05.906Z |
4977089 | 4977089 | 20240811233605_6AfZL | CZ000D | 2024-09-06T12:12:03.289Z | 2024-09-06T12:12:03.289Z |
4976642 | 4976642 | 20240811233232_j08Uw | CZ000D | 2024-09-06T12:11:42.202Z | 2024-09-06T12:11:42.202Z |
4976504 | 4976504 | 20240811233107_hdxhs | CZ000D | 2024-09-06T12:11:34.520Z | 2024-09-06T12:11:34.520Z |
4976423 | 4976423 | 20240811233003_d7Q4e | CZ000D | 2024-09-06T12:11:31.726Z | 2024-09-06T12:11:31.726Z |
4976296 | 4976296 | 20240811232820_ArVvf | CZ000D | 2024-09-06T12:11:22.893Z | 2024-09-06T12:11:22.893Z |
4976015 | 4976015 | 20240811232450_XcVny | CZ000D | 2024-09-06T12:11:02.181Z | 2024-09-06T12:11:02.181Z |
4975962 | 4975962 | 20240811232403_v5xU5 | CZ000D | 2024-09-06T12:10:59.356Z | 2024-09-06T12:10:59.356Z |
4975957 | 4975957 | 20240811232356_I6IWn | CZ000D | 2024-09-06T12:10:59.264Z | 2024-09-06T12:10:59.264Z |
4975953 | 4975953 | 20240811232355_aILqv | CZ000D | 2024-09-06T12:10:59.129Z | 2024-09-06T12:10:59.129Z |
4975797 | 4975797 | 20240811232204_Jsjgv | CZ000D | 2024-09-06T12:10:49.690Z | 2024-09-06T12:10:49.690Z |
4975634 | 4975634 | 20240811232029_NXeWW | CZ000D | 2024-09-06T12:10:46.549Z | 2024-09-06T12:10:46.549Z |
4975264 | 4975264 | 20240811231640_O7GyK | CZ000D | 2024-09-05T12:11:43.047Z | 2024-09-06T12:10:39.013Z |
4975002 | 4975002 | 20240811231335_nwN9m | CZ000D | 2024-09-05T12:11:38.284Z | 2024-09-06T12:10:35.822Z |
4974988 | 4974988 | 20240811231325_jt19A | CZ000D | 2024-09-05T12:11:37.881Z | 2024-09-06T12:10:35.416Z |
4974821 | 4974821 | 20240811231147_QB1c3 | CZ000D | 2024-09-05T12:11:33.260Z | 2024-09-06T12:10:33.731Z |
4974542 | 4974542 | 20240811230755_Rddm6 | CZ000D | 2024-09-05T12:11:26.068Z | 2024-09-06T12:10:27.855Z |
4974482 | 4974482 | 20240811230731_lzB37 | CZ000D | 2024-09-05T12:11:25.177Z | 2024-09-06T12:10:27.098Z |
4974388 | 4974388 | 20240811230639_nG1oo | CZ000D | 2024-09-05T12:11:23.971Z | 2024-09-06T12:10:26.215Z |
4974246 | 4974246 | 20240811230501_JhKsV | CZ000D | 2024-09-05T12:11:21.491Z | 2024-09-06T12:10:24.255Z |
4973827 | 4973827 | 20240811230037_Zd4xz | CZ000D | 2024-09-05T12:11:12.472Z | 2024-09-06T12:10:07.717Z |
4971867 | 4971867 | 20240811224032_TYd9b | CZ000D | 2024-09-05T12:10:05.814Z | 2024-09-06T12:08:59.263Z |
4971089 | 4971089 | 20240811223154_nAwI4 | CZ000D | 2024-09-05T12:09:37.862Z | 2024-09-06T12:08:48.948Z |
4970644 | 4970644 | 20240811222741_hTc3W | CZ000D | 2024-09-05T12:09:30.102Z | 2024-09-06T12:08:43.315Z |
4970132 | 4970132 | 20240811222121_SkYY2 | CZ000D | 2024-09-05T12:09:19.316Z | 2024-09-06T12:08:25.439Z |
4970066 | 4970066 | 20240811222031_gS6b1 | CZ000D | 2024-09-05T12:09:17.958Z | 2024-09-06T12:08:20.102Z |
4969892 | 4969892 | 20240811221824_or9Di | CZ000D | 2024-09-05T12:09:09.948Z | 2024-09-06T12:08:13.871Z |
4969803 | 4969803 | 20240811221658_2JpGf | CZ000D | 2024-09-05T12:09:04.220Z | 2024-09-06T12:08:07.430Z |
4969737 | 4969737 | 20240811221534_gc124 | CZ000D | 2024-09-05T12:08:58.392Z | 2024-09-06T12:08:01.272Z |
4969657 | 4969657 | 20240811221407_6Axaw | CZ000D | 2024-09-05T12:08:53.088Z | 2024-09-06T12:07:57.594Z |
4969522 | 4969522 | 20240811221252_Nskyt | CZ000D | 2024-09-05T12:08:47.653Z | 2024-09-06T12:07:54.321Z |
4969354 | 4969354 | 20240811221033_POJNW | CZ000D | 2024-09-05T12:08:43.199Z | 2024-09-06T12:07:50.457Z |
4968806 | 4968806 | 20240811220254_Q0JIN | CZ000D | 2024-09-05T12:08:27.467Z | 2024-09-06T12:07:36.584Z |
4968644 | 4968644 | 20240811220045_b2kDb | CZ000D | 2024-09-05T12:08:23.775Z | 2024-09-06T12:07:33.637Z |
4968097 | 4968097 | 20240811215422_46l9K | CZ000D | 2024-09-05T12:08:01.513Z | 2024-09-06T12:07:24.372Z |
4968026 | 4968026 | 20240811215324_xXVLF | CZ000D | 2024-09-05T12:07:57.487Z | 2024-09-06T12:07:20.181Z |
4967946 | 4967946 | 20240811215220_YjNNp | CZ000D | 2024-09-05T12:07:54.607Z | 2024-09-06T12:07:17.265Z |
4967537 | 4967537 | 20240811214533_VNJIt | CZ000D | 2024-09-05T12:07:41.443Z | 2024-09-06T12:07:01.744Z |
4967426 | 4967426 | 20240811214425_HrBye | CZ000D | 2024-09-05T12:07:38.945Z | 2024-09-06T12:06:59.797Z |
4966791 | 4966791 | 20240811213341_hPYkM | CZ000D | 2024-09-05T12:07:14.084Z | 2024-09-06T12:06:47.613Z |
4966597 | 4966597 | 20240811213128_VbAqe | CZ000D | 2024-09-04T12:07:30.519Z | 2024-09-06T12:06:36.379Z |
4966329 | 4966329 | 20240811212726_FWhdX | CZ000D | 2024-09-04T12:07:24.064Z | 2024-09-06T12:06:24.410Z |
4966107 | 4966107 | 20240811212419_qvh3D | CZ000D | 2024-09-04T12:07:18.491Z | 2024-09-06T12:06:13.315Z |
4965764 | 4965764 | 20240811211907_OF6zE | CZ000D | 2024-09-04T12:07:07.339Z | 2024-09-06T12:06:04.485Z |
4965599 | 4965599 | 20240811211721_A03O6 | CZ000D | 2024-09-04T12:07:02.279Z | 2024-09-06T12:06:00.602Z |
4965480 | 4965480 | 20240811211518_znFtZ | CZ000D | 2024-09-04T12:06:58.604Z | 2024-09-06T12:05:57.600Z |
4965213 | 4965213 | 20240811211056_06NRF | CZ000D | 2024-09-04T12:06:52.266Z | 2024-09-06T12:05:51.545Z |
4965145 | 4965145 | 20240811210911_1qQ6Z | CZ000D | 2024-09-04T12:06:49.128Z | 2024-09-06T12:05:48.580Z |
4964865 | 4964865 | 20240811210432_nC9zA | CZ000D | 2024-09-04T12:06:37.445Z | 2024-09-06T12:05:39.653Z |
4964856 | 4964856 | 20240811210414_oRMD1 | CZ000D | 2024-09-04T12:06:37.037Z | 2024-09-06T12:05:38.725Z |
4964208 | 4964208 | 20240811204823_6e7I7 | CZ000D | 2024-09-04T12:06:14.273Z | 2024-09-06T12:05:14.240Z |
4964106 | 4964106 | 20240811204533_6bJIG | CZ000D | 2024-09-04T12:06:08.450Z | 2024-09-06T12:05:11.240Z |
4963871 | 4963871 | 20240811203921_JIpMA | CZ000D | 2024-09-04T12:05:58.902Z | 2024-09-06T12:05:03.035Z |
4963657 | 4963657 | 20240811202750_aUmup | CZ000D | 2024-09-04T12:05:49.476Z | 2024-09-06T12:04:47.990Z |
4963619 | 4963619 | 20240811202555_YfnV5 | CZ000D | 2024-09-04T12:05:46.355Z | 2024-09-06T12:04:46.820Z |
4963442 | 4963442 | 20240811201137_ym2Qq | CZ000D | 2024-09-04T12:05:34.871Z | 2024-09-06T12:04:39.610Z |
4963317 | 4963317 | 20240811195717_YXjob | CZ000D | 2024-09-04T12:05:26.875Z | 2024-09-06T12:04:29.058Z |
4962966 | 4962966 | 20240811193455_74hwY | CZ000D | 2024-09-04T12:05:01.837Z | 2024-09-06T12:04:13.205Z |
4952903 | 4952903 | 20240811022843_bQHRm | CZ000D | 2024-09-03T12:17:08.653Z | 2024-09-06T12:28:12.150Z |
4952583 | 4952583 | 20240811022428_bf8gw | CZ000D | 2024-09-03T12:17:02.163Z | 2024-09-06T12:28:05.710Z |
4952447 | 4952447 | 20240811022213_pDbeA | CZ000D | 2024-09-03T12:16:58.554Z | 2024-09-06T12:28:02.081Z |
4952436 | 4952436 | 20240811022159_SUXI2 | CZ000D | 2024-09-03T12:16:58.146Z | 2024-09-06T12:28:01.609Z |
4952416 | 4952416 | 20240811022115_S80yp | CZ000D | 2024-09-03T12:16:57.536Z | 2024-09-06T12:28:00.747Z |
4952342 | 4952342 | 20240811022001_QVl0a | CZ000D | 2024-09-03T12:16:55.602Z | 2024-09-06T12:27:57.138Z |
4950750 | 4950750 | 20240811021122_PhpX3 | CZ000D | 2024-09-02T12:16:35.339Z | 2024-09-06T12:27:48.460Z |
4950603 | 4950603 | 20240811020936_Nq8GV | CZ000D | 2024-09-02T12:16:32.316Z | 2024-09-06T12:27:46.320Z |
4950557 | 4950557 | 20240811020842_7Wg0V | CZ000D | 2024-09-02T12:16:30.950Z | 2024-09-06T12:27:45.657Z |
4950478 | 4950478 | 20240811020710_jVBSz | CZ000D | 2024-09-02T12:16:29.061Z | 2024-09-06T12:27:44.807Z |
4949828 | 4949828 | 20240811015614_25OH2 | CZ000D | 2024-09-02T12:15:55.650Z | 2024-09-06T12:27:37.973Z |
4949624 | 4949624 | 20240811015302_zoIGj | CZ000D | 2024-09-02T12:15:51.147Z | 2024-09-06T12:27:35.903Z |
4949427 | 4949427 | 20240811014925_VJkQV | CZ000D | 2024-09-02T12:15:45.449Z | 2024-09-06T12:27:32.981Z |
4948770 | 4948770 | 20240811013955_FfIDw | CZ000D | 2024-09-02T12:15:15.156Z | 2024-09-06T12:27:25.716Z |
4948624 | 4948624 | 20240811013725_RYZ4X | CZ000D | 2024-09-02T12:15:09.226Z | 2024-09-06T12:27:22.124Z |
4948022 | 4948022 | 20240811012747_hBcrz | CZ000D | 2024-09-02T12:14:52.773Z | 2024-09-06T12:27:06.630Z |
4947803 | 4947803 | 20240811012518_IYAY5 | CZ000D | 2024-09-02T12:14:48.163Z | 2024-09-06T12:27:02.839Z |
4947692 | 4947692 | 20240811012248_z2kzF | CZ000D | 2024-09-02T12:14:44.787Z | 2024-09-06T12:26:58.124Z |
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);