participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,596 rows where station_code = "CZ0006" 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 |
---|---|---|---|---|---|
5481638 | 5481638 | 20241104185658_lHlOE | CZ0006 | 2024-11-06T14:11:03.022Z | 2024-11-09T14:20:48.520Z |
5477546 | 5477546 | 20241104020659_B38IF | CZ0006 | 2024-11-05T14:17:02.834Z | 2024-11-09T14:22:18.835Z |
5477471 | 5477471 | 20241104020021_iEvBe | CZ0006 | 2024-11-05T14:16:56.096Z | 2024-11-09T14:22:18.145Z |
5468468 | 5468468 | 20241103004211_Xlf5k | CZ0006 | 2024-11-04T14:14:10.161Z | 2024-11-09T14:22:58.503Z |
5468159 | 5468159 | 20241102234223_gGGBk | CZ0006 | 2024-11-04T14:13:27.558Z | 2024-11-09T14:22:57.331Z |
5467698 | 5467698 | 20241102222026_3nIHn | CZ0006 | 2024-11-04T14:12:22.427Z | 2024-11-09T14:22:55.407Z |
5467326 | 5467326 | 20241102204551_d3slT | CZ0006 | 2024-11-04T14:11:18.200Z | 2024-11-09T14:22:54.120Z |
5461752 | 5461752 | 20241101211545_Ntxby | CZ0006 | 2024-11-03T14:16:10.415Z | 2024-11-09T14:23:31.120Z |
5461270 | 5461270 | 20241101172803_WDWvP | CZ0006 | 2024-11-03T14:14:59.385Z | 2024-11-09T14:23:27.649Z |
5443223 | 5443223 | 20241030040612_CShYH | CZ0006 | 2024-11-01T12:20:23.625Z | 2024-11-07T14:26:50.136Z |
5430002 | 5430002 | 20241028204424_CzAG5 | CZ0006 | 2024-10-31T12:17:22.708Z | 2024-11-06T14:27:18.309Z |
5429530 | 5429530 | 20241028193223_UEmmn | CZ0006 | 2024-10-31T12:16:41.877Z | 2024-11-06T14:27:16.359Z |
5428983 | 5428983 | 20241028183217_8SXAK | CZ0006 | 2024-10-31T12:15:49.245Z | 2024-11-06T14:27:14.889Z |
5428956 | 5428956 | 20241028182842_2MpTu | CZ0006 | 2024-10-31T12:15:46.678Z | 2024-11-06T14:27:14.846Z |
5388102 | 5388102 | 20241025040342_1YObW | CZ0006 | 2024-10-27T12:21:59.733Z | 2024-11-02T12:28:33.747Z |
5388083 | 5388083 | 20241025040103_GGIFP | CZ0006 | 2024-10-27T12:21:58.725Z | 2024-11-02T12:28:33.741Z |
5388066 | 5388066 | 20241025035814_RdHUL | CZ0006 | 2024-10-27T12:21:57.818Z | 2024-11-02T12:28:33.734Z |
5387309 | 5387309 | 20241025022201_JaFE8 | CZ0006 | 2024-10-27T12:21:10.347Z | 2024-11-02T12:28:32.380Z |
5387250 | 5387250 | 20241025021627_L1lwK | CZ0006 | 2024-10-27T12:21:04.881Z | 2024-11-02T12:28:32.322Z |
5387244 | 5387244 | 20241025021609_N66pP | CZ0006 | 2024-10-27T12:21:03.286Z | 2024-11-02T12:28:32.316Z |
5387027 | 5387027 | 20241025015253_thpGI | CZ0006 | 2024-10-27T12:20:48.699Z | 2024-11-02T12:28:31.941Z |
5386985 | 5386985 | 20241025014659_4Zq4u | CZ0006 | 2024-10-27T12:20:45.988Z | 2024-11-02T12:28:31.792Z |
5386983 | 5386983 | 20241025014620_RGoYv | CZ0006 | 2024-10-27T12:20:45.874Z | 2024-11-02T12:28:31.790Z |
5386964 | 5386964 | 20241025014509_8KSlP | CZ0006 | 2024-10-27T12:20:43.947Z | 2024-11-02T12:28:31.759Z |
5386867 | 5386867 | 20241025013604_ZLbqS | CZ0006 | 2024-10-27T12:20:36.998Z | 2024-11-02T12:28:31.673Z |
5386718 | 5386718 | 20241025011827_p3Lgc | CZ0006 | 2024-10-27T12:20:21.530Z | 2024-11-02T12:28:31.517Z |
5386678 | 5386678 | 20241025011316_mdgub | CZ0006 | 2024-10-27T12:20:17.798Z | 2024-11-02T12:28:31.484Z |
5386516 | 5386516 | 20241025005509_3lTd4 | CZ0006 | 2024-10-27T12:20:08.943Z | 2024-11-02T12:28:31.301Z |
5386361 | 5386361 | 20241025003002_b3WXi | CZ0006 | 2024-10-27T12:20:01.591Z | 2024-11-02T12:28:31.112Z |
5385257 | 5385257 | 20241024221341_2E7nU | CZ0006 | 2024-10-27T12:18:38.523Z | 2024-11-02T12:28:29.415Z |
5385237 | 5385237 | 20241024221228_TEYaG | CZ0006 | 2024-10-27T12:18:36.616Z | 2024-11-02T12:28:29.357Z |
5385022 | 5385022 | 20241024213913_t770x | CZ0006 | 2024-10-27T12:18:14.912Z | 2024-11-02T12:28:28.958Z |
5384476 | 5384476 | 20241024201213_gmL0e | CZ0006 | 2024-10-27T12:17:07.374Z | 2024-11-02T12:28:27.245Z |
5383067 | 5383067 | 20241024174011_v0rsq | CZ0006 | 2024-10-27T12:14:43.792Z | 2024-11-02T12:28:24.679Z |
5355034 | 5355034 | 20241023030543_rVFp6 | CZ0006 | 2024-10-24T12:21:00.816Z | 2024-10-31T12:30:07.018Z |
5354931 | 5354931 | 20241023025712_HvY3e | CZ0006 | 2024-10-24T12:20:57.804Z | 2024-10-31T12:30:06.766Z |
5341144 | 5341144 | 20241022011704_eawMy | CZ0006 | 2024-10-23T12:15:24.814Z | 2024-10-30T12:26:46.635Z |
5339920 | 5339920 | 20241021232826_C4zPf | CZ0006 | 2024-10-23T12:14:08.113Z | 2024-10-30T12:26:45.088Z |
5321776 | 5321776 | 20241015033450_5Iubt | CZ0006 | 2024-10-19T12:17:53.470Z | 2024-10-23T12:24:50.863Z |
5317388 | 5317388 | 20241016041352_90M3f | CZ0006 | 2024-10-17T12:08:31.971Z | 2024-10-24T12:28:00.147Z |
5317359 | 5317359 | 20241016040634_PmHWX | CZ0006 | 2024-10-17T12:08:28.019Z | 2024-10-24T12:28:00.062Z |
5316870 | 5316870 | 20241016014222_nPoza | CZ0006 | 2024-10-17T12:07:15.192Z | 2024-10-24T12:27:58.071Z |
5316414 | 5316414 | 20241015212419_Papd1 | CZ0006 | 2024-10-17T12:06:36.729Z | 2024-10-24T12:27:56.462Z |
5316241 | 5316241 | 20241015181918_4ACOg | CZ0006 | 2024-10-17T12:06:06.655Z | 2024-10-24T12:27:55.875Z |
5312662 | 5312662 | 20241015042120_zaEmV | CZ0006 | 2024-10-16T12:10:53.925Z | 2024-10-23T12:24:52.603Z |
5312625 | 5312625 | 20241015041012_wyvsN | CZ0006 | 2024-10-16T12:10:51.772Z | 2024-10-23T12:24:52.493Z |
5312620 | 5312620 | 20241015040932_ULX0i | CZ0006 | 2024-10-16T12:10:51.523Z | 2024-10-23T12:24:52.451Z |
5294270 | 5294270 | 20241012033545_JyAN2 | CZ0006 | 2024-10-13T12:18:27.672Z | 2024-10-20T12:25:09.738Z |
5294202 | 5294202 | 20241012032622_lru1j | CZ0006 | 2024-10-13T12:18:23.524Z | 2024-10-20T12:25:09.153Z |
5293958 | 5293958 | 20241012024414_zy3Pu | CZ0006 | 2024-10-13T12:18:03.933Z | 2024-10-20T12:25:05.512Z |
5293873 | 5293873 | 20241012023139_HYNq0 | CZ0006 | 2024-10-13T12:17:57.502Z | 2024-10-20T12:25:04.897Z |
5293860 | 5293860 | 20241012022921_QQ08M | CZ0006 | 2024-10-13T12:17:57.061Z | 2024-10-20T12:25:04.755Z |
5293763 | 5293763 | 20241012021426_CvXJh | CZ0006 | 2024-10-13T12:17:50.525Z | 2024-10-20T12:25:03.719Z |
5293596 | 5293596 | 20241012015512_QhLc6 | CZ0006 | 2024-10-13T12:17:40.251Z | 2024-10-20T12:25:02.264Z |
5293471 | 5293471 | 20241012013902_vHru0 | CZ0006 | 2024-10-13T12:17:30.782Z | 2024-10-20T12:25:00.184Z |
5292947 | 5292947 | 20241012003735_McxAP | CZ0006 | 2024-10-13T12:16:48.253Z | 2024-10-20T12:24:53.714Z |
5291550 | 5291550 | 20241011211839_YbAOq | CZ0006 | 2024-10-13T12:14:46.468Z | 2024-10-20T12:24:33.034Z |
5291027 | 5291027 | 20241011193743_zwksV | CZ0006 | 2024-10-13T12:13:51.432Z | 2024-10-20T12:24:24.123Z |
5254092 | 5254092 | 20241007013207_X7H5V | CZ0006 | 2024-10-08T12:14:04.450Z | 2024-10-15T12:29:12.869Z |
5253855 | 5253855 | 20241007005528_pVl9h | CZ0006 | 2024-10-08T12:13:46.713Z | 2024-10-15T12:29:11.277Z |
5253440 | 5253440 | 20241006235639_e0Rw2 | CZ0006 | 2024-10-08T12:13:15.410Z | 2024-10-15T12:29:09.267Z |
5252975 | 5252975 | 20241006221933_eKivx | CZ0006 | 2024-10-08T12:12:49.484Z | 2024-10-15T12:29:06.187Z |
5248309 | 5248309 | 20241007041524_tUKqO | CZ0006 | 2024-10-08T12:02:04.061Z | 2024-10-16T12:20:59.399Z |
5248283 | 5248283 | 20241007041323_7zL2u | CZ0006 | 2024-10-08T12:01:56.504Z | 2024-10-16T12:20:59.078Z |
5248220 | 5248220 | 20241007040802_27lOm | CZ0006 | 2024-10-08T12:01:48.233Z | 2024-10-16T12:20:58.659Z |
5248207 | 5248207 | 20241007040606_lfPSa | CZ0006 | 2024-10-08T12:01:46.750Z | 2024-10-16T12:20:58.624Z |
5248001 | 5248001 | 20241007034242_CeY0q | CZ0006 | 2024-10-08T12:01:13.761Z | 2024-10-16T12:20:57.882Z |
5247722 | 5247722 | 20241007031208_aOLnX | CZ0006 | 2024-10-08T12:00:31.389Z | 2024-10-16T12:20:56.536Z |
5246054 | 5246054 | 20241006005104_6krWi | CZ0006 | 2024-10-07T12:16:10.575Z | 2024-10-14T12:24:37.091Z |
5246017 | 5246017 | 20241006004556_WleR5 | CZ0006 | 2024-10-07T12:16:09.214Z | 2024-10-14T12:24:37.054Z |
5193087 | 5193087 | 20240928235256_qqd97 | CZ0006 | 2024-09-30T12:19:03.790Z | 2024-10-06T12:28:26.885Z |
5192859 | 5192859 | 20240928232532_fUdpr | CZ0006 | 2024-09-30T12:18:56.040Z | 2024-10-06T12:28:26.409Z |
5192410 | 5192410 | 20240928223552_FijEP | CZ0006 | 2024-09-30T12:18:40.320Z | 2024-10-06T12:28:25.677Z |
5192033 | 5192033 | 20240928213239_3Jk8R | CZ0006 | 2024-09-30T12:18:22.628Z | 2024-10-06T12:28:24.896Z |
5185556 | 5185556 | 20240929023449_D2278 | CZ0006 | 2024-09-30T12:04:31.795Z | 2024-10-07T12:21:18.480Z |
5185499 | 5185499 | 20240929022832_nHnCN | CZ0006 | 2024-09-30T12:04:23.175Z | 2024-10-07T12:21:18.263Z |
5185052 | 5185052 | 20240929015251_o9X22 | CZ0006 | 2024-09-30T12:03:15.585Z | 2024-10-07T12:21:16.983Z |
5184947 | 5184947 | 20240929014556_dr6bZ | CZ0006 | 2024-09-30T12:03:01.620Z | 2024-10-07T12:21:16.891Z |
5184719 | 5184719 | 20240929012300_8yqvr | CZ0006 | 2024-09-30T12:02:22.024Z | 2024-10-07T12:21:16.221Z |
5184665 | 5184665 | 20240929011840_SjU67 | CZ0006 | 2024-09-30T12:02:16.401Z | 2024-10-07T12:21:16.134Z |
5169691 | 5169691 | 20240927024916_cyfm9 | CZ0006 | 2024-09-28T12:03:39.004Z | 2024-10-05T12:28:33.350Z |
5169675 | 5169675 | 20240927024601_5ja4c | CZ0006 | 2024-09-28T12:03:34.340Z | 2024-10-05T12:28:33.204Z |
5169626 | 5169626 | 20240927024006_NdHUT | CZ0006 | 2024-09-28T12:03:23.419Z | 2024-10-05T12:28:32.737Z |
5169297 | 5169297 | 20240927011147_VCEht | CZ0006 | 2024-09-28T12:02:03.250Z | 2024-10-05T12:28:30.020Z |
5169289 | 5169289 | 20240927010826_b9NRU | CZ0006 | 2024-09-28T12:02:01.349Z | 2024-10-05T12:28:29.979Z |
5169172 | 5169172 | 20240927002911_3ACTk | CZ0006 | 2024-09-28T12:01:35.026Z | 2024-10-05T12:28:29.097Z |
5155574 | 5155574 | 20240924002400_4WOg6 | CZ0006 | 2024-09-25T12:01:34.472Z | 2024-10-02T12:18:46.186Z |
5155532 | 5155532 | 20240924000045_AmlN6 | CZ0006 | 2024-09-25T12:01:26.243Z | 2024-10-02T12:18:46.093Z |
5155526 | 5155526 | 20240923235851_p2AoX | CZ0006 | 2024-09-25T12:01:24.451Z | 2024-10-02T12:18:46.038Z |
5150435 | 5150435 | 20240922214931_KcLfS | CZ0006 | 2024-09-24T12:00:22.604Z | 2024-10-01T12:22:00.435Z |
5150026 | 5150026 | 20240921182612_Rcatx | CZ0006 | 2024-09-23T12:11:30.499Z | 2024-09-29T12:22:14.574Z |
5146968 | 5146968 | 20240922032926_3ePZw | CZ0006 | 2024-09-23T12:04:08.216Z | 2024-09-30T12:22:41.120Z |
5146868 | 5146868 | 20240922030439_fCWxd | CZ0006 | 2024-09-23T12:03:56.358Z | 2024-09-30T12:22:40.338Z |
5146809 | 5146809 | 20240922024104_hCWwA | CZ0006 | 2024-09-23T12:03:49.859Z | 2024-09-30T12:22:39.975Z |
5146790 | 5146790 | 20240922023604_4r96y | CZ0006 | 2024-09-23T12:03:47.907Z | 2024-09-30T12:22:39.790Z |
5146764 | 5146764 | 20240922023008_VnAWK | CZ0006 | 2024-09-23T12:03:45.498Z | 2024-09-30T12:22:39.510Z |
5146705 | 5146705 | 20240922021611_MMzUS | CZ0006 | 2024-09-23T12:03:39.103Z | 2024-09-30T12:22:39.139Z |
5146460 | 5146460 | 20240922011756_ammS9 | CZ0006 | 2024-09-23T12:02:49.405Z | 2024-09-30T12:22:37.200Z |
5146303 | 5146303 | 20240922003950_UvXXL | CZ0006 | 2024-09-23T12:02:29.818Z | 2024-09-30T12:22:36.310Z |
5145726 | 5145726 | 20240921220259_nX2Ws | CZ0006 | 2024-09-23T12:00:53.004Z | 2024-09-30T12:22:32.645Z |
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);