participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
937 rows where station_code = "CZ000B" 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 |
---|---|---|---|---|---|
5510878 | 5510878 | 20241109034807_SVBj4 | CZ000B | 2024-11-10T14:15:48.851Z | 2024-11-10T14:16:52.637Z |
5510589 | 5510589 | 20241109030536_07tzl | CZ000B | 2024-11-10T14:15:28.537Z | 2024-11-10T14:16:52.571Z |
5510069 | 5510069 | 20241109013852_R27EG | CZ000B | 2024-11-10T14:14:32.613Z | 2024-11-10T14:16:52.445Z |
5509503 | 5509503 | 20241108233402_y0gUs | CZ000B | 2024-11-10T14:13:28.586Z | 2024-11-10T14:16:52.287Z |
5509444 | 5509444 | 20241108231925_KPhsk | CZ000B | 2024-11-10T14:13:23.742Z | 2024-11-10T14:16:52.268Z |
5509377 | 5509377 | 20241108230220_v9Wlc | CZ000B | 2024-11-10T14:13:17.027Z | 2024-11-10T14:16:52.245Z |
5509066 | 5509066 | 20241108214029_1O51Q | CZ000B | 2024-11-10T14:12:26.618Z | 2024-11-10T14:16:52.156Z |
5508894 | 5508894 | 20241108203006_Aj2p1 | CZ000B | 2024-11-10T14:12:00.634Z | 2024-11-10T14:16:52.085Z |
5505140 | 5505140 | 20241108035832_YMiHT | CZ000B | 2024-11-09T14:15:50.366Z | 2024-11-10T14:20:05.175Z |
5503154 | 5503154 | 20241107205318_aVGka | CZ000B | 2024-11-09T14:12:28.312Z | 2024-11-10T14:18:59.248Z |
5502577 | 5502577 | 20241107191022_7DY6k | CZ000B | 2024-11-09T14:11:45.770Z | 2024-11-10T14:18:42.595Z |
5502363 | 5502363 | 20241107181331_56ula | CZ000B | 2024-11-09T14:11:13.578Z | 2024-11-10T14:18:35.136Z |
5491576 | 5491576 | 20241106035449_t1VWp | CZ000B | 2024-11-07T14:16:25.482Z | 2024-11-10T14:23:27.926Z |
5490670 | 5490670 | 20241106000217_yuiF5 | CZ000B | 2024-11-07T14:14:27.782Z | 2024-11-10T14:23:16.905Z |
5490630 | 5490630 | 20241105234758_U8aSY | CZ000B | 2024-11-07T14:14:20.309Z | 2024-11-10T14:23:15.688Z |
5490450 | 5490450 | 20241105225350_AuVmb | CZ000B | 2024-11-07T14:14:02.987Z | 2024-11-10T14:23:14.000Z |
5484642 | 5484642 | 20241105031620_rbup3 | CZ000B | 2024-11-06T14:17:07.672Z | 2024-11-10T14:24:23.856Z |
5484117 | 5484117 | 20241105021045_XrIgL | CZ000B | 2024-11-06T14:16:19.612Z | 2024-11-10T14:24:19.659Z |
5483908 | 5483908 | 20241105014337_tMB9P | CZ000B | 2024-11-06T14:15:52.701Z | 2024-11-10T14:24:18.165Z |
5475974 | 5475974 | 20241103220300_1D3m2 | CZ000B | 2024-11-05T14:14:36.889Z | 2024-11-10T14:25:03.273Z |
5475693 | 5475693 | 20241103210411_Ruzi0 | CZ000B | 2024-11-05T14:14:01.653Z | 2024-11-10T14:24:59.472Z |
5475647 | 5475647 | 20241103205502_IErKJ | CZ000B | 2024-11-05T14:13:55.646Z | 2024-11-10T14:24:59.008Z |
5475603 | 5475603 | 20241103204906_8kgWJ | CZ000B | 2024-11-05T14:13:52.433Z | 2024-11-10T14:24:58.459Z |
5475597 | 5475597 | 20241103204720_TwetH | CZ000B | 2024-11-05T14:13:52.061Z | 2024-11-10T14:24:58.437Z |
5474965 | 5474965 | 20241103184250_oys8f | CZ000B | 2024-11-05T14:12:20.297Z | 2024-11-10T14:24:50.625Z |
5474919 | 5474919 | 20241103183713_se4OL | CZ000B | 2024-11-05T14:12:16.729Z | 2024-11-10T14:24:50.356Z |
5474462 | 5474462 | 20241103172436_KkdVz | CZ000B | 2024-11-05T14:11:07.000Z | 2024-11-10T14:24:48.029Z |
5469397 | 5469397 | 20241103032146_BRXHJ | CZ000B | 2024-11-04T14:16:23.986Z | 2024-11-10T14:26:02.474Z |
5468188 | 5468188 | 20241102234740_R3G2l | CZ000B | 2024-11-04T14:13:38.876Z | 2024-11-10T14:25:55.839Z |
5468094 | 5468094 | 20241102232730_ea3BE | CZ000B | 2024-11-04T14:13:16.160Z | 2024-11-10T14:25:55.034Z |
5468039 | 5468039 | 20241102231947_GmWO0 | CZ000B | 2024-11-04T14:13:10.179Z | 2024-11-10T14:25:54.504Z |
5467948 | 5467948 | 20241102230116_v0Mgh | CZ000B | 2024-11-04T14:13:00.985Z | 2024-11-10T14:25:53.934Z |
5467935 | 5467935 | 20241102225829_a2YZE | CZ000B | 2024-11-04T14:12:59.098Z | 2024-11-10T14:25:53.877Z |
5467878 | 5467878 | 20241102224835_5TWTE | CZ000B | 2024-11-04T14:12:53.827Z | 2024-11-10T14:25:53.530Z |
5467738 | 5467738 | 20241102222753_io2jS | CZ000B | 2024-11-04T14:12:26.380Z | 2024-11-10T14:25:52.831Z |
5467627 | 5467627 | 20241102220717_2zaWq | CZ000B | 2024-11-04T14:12:15.389Z | 2024-11-10T14:25:52.199Z |
5467483 | 5467483 | 20241102212723_5pcSE | CZ000B | 2024-11-04T14:11:41.082Z | 2024-11-10T14:25:51.705Z |
5467396 | 5467396 | 20241102205844_Q63nO | CZ000B | 2024-11-04T14:11:25.770Z | 2024-11-10T14:25:51.045Z |
5467090 | 5467090 | 20241102200515_RWqBJ | CZ000B | 2024-11-04T14:10:36.553Z | 2024-11-10T14:25:49.498Z |
5466950 | 5466950 | 20241102192851_b2pjF | CZ000B | 2024-11-04T14:10:21.883Z | 2024-11-10T14:25:48.425Z |
5429014 | 5429014 | 20241028183507_02Iny | CZ000B | 2024-10-31T12:15:52.080Z | 2024-11-06T14:27:14.905Z |
5388031 | 5388031 | 20241025035405_SFuud | CZ000B | 2024-10-27T12:21:54.460Z | 2024-11-02T12:28:33.631Z |
5387865 | 5387865 | 20241025033253_ejovA | CZ000B | 2024-10-27T12:21:46.830Z | 2024-11-02T12:28:33.347Z |
5387534 | 5387534 | 20241025025051_s7G13 | CZ000B | 2024-10-27T12:21:27.149Z | 2024-11-02T12:28:32.701Z |
5387428 | 5387428 | 20241025023539_jAtw3 | CZ000B | 2024-10-27T12:21:20.356Z | 2024-11-02T12:28:32.578Z |
5386411 | 5386411 | 20241025003728_1nFdV | CZ000B | 2024-10-27T12:20:03.852Z | 2024-11-02T12:28:31.201Z |
5385272 | 5385272 | 20241024221713_3Xvhm | CZ000B | 2024-10-27T12:18:39.928Z | 2024-11-02T12:28:29.438Z |
5384981 | 5384981 | 20241024213028_8rFr0 | CZ000B | 2024-10-27T12:18:07.301Z | 2024-11-02T12:28:28.861Z |
5384882 | 5384882 | 20241024211247_OlSSQ | CZ000B | 2024-10-27T12:17:55.732Z | 2024-11-02T12:28:28.561Z |
5384829 | 5384829 | 20241024210131_eDHkb | CZ000B | 2024-10-27T12:17:47.740Z | 2024-11-02T12:28:28.404Z |
5384517 | 5384517 | 20241024201621_a8dBR | CZ000B | 2024-10-27T12:17:09.482Z | 2024-11-02T12:28:27.290Z |
5384427 | 5384427 | 20241024200700_obDsC | CZ000B | 2024-10-27T12:17:03.463Z | 2024-11-02T12:28:27.196Z |
5383461 | 5383461 | 20241024182302_ZHddG | CZ000B | 2024-10-27T12:15:30.574Z | 2024-11-02T12:28:25.378Z |
5376378 | 5376378 | 20241024035257_XOxxD | CZ000B | 2024-10-26T12:21:59.721Z | 2024-11-01T12:27:01.518Z |
5376231 | 5376231 | 20241024034609_1RQOl | CZ000B | 2024-10-26T12:21:53.873Z | 2024-11-01T12:27:01.465Z |
5375848 | 5375848 | 20241024033310_vQKOV | CZ000B | 2024-10-26T12:21:42.213Z | 2024-11-01T12:27:01.234Z |
5375801 | 5375801 | 20241024033012_eAkJ8 | CZ000B | 2024-10-26T12:21:40.192Z | 2024-11-01T12:27:01.201Z |
5375700 | 5375700 | 20241024032519_d2RfA | CZ000B | 2024-10-26T12:21:35.821Z | 2024-11-01T12:27:01.165Z |
5374748 | 5374748 | 20241024024229_LjUQA | CZ000B | 2024-10-26T12:21:00.440Z | 2024-11-01T12:26:59.560Z |
5374558 | 5374558 | 20241024023436_FkzJd | CZ000B | 2024-10-26T12:20:53.259Z | 2024-11-01T12:26:59.468Z |
5374335 | 5374335 | 20241024022255_hAxaj | CZ000B | 2024-10-26T12:20:45.487Z | 2024-11-01T12:26:58.851Z |
5355737 | 5355737 | 20241023040801_yoTrV | CZ000B | 2024-10-24T12:21:33.922Z | 2024-10-31T12:30:08.603Z |
5344262 | 5344262 | 20241022041246_ctw3u | CZ000B | 2024-10-23T12:18:30.231Z | 2024-10-30T12:26:51.097Z |
5343215 | 5343215 | 20241022031654_rnzdD | CZ000B | 2024-10-23T12:17:39.527Z | 2024-10-30T12:26:49.647Z |
5342851 | 5342851 | 20241022025023_jAIH6 | CZ000B | 2024-10-23T12:17:26.559Z | 2024-10-30T12:26:48.992Z |
5342521 | 5342521 | 20241022023223_q3jX3 | CZ000B | 2024-10-23T12:17:01.117Z | 2024-10-30T12:26:48.590Z |
5342426 | 5342426 | 20241022022558_fYhfe | CZ000B | 2024-10-23T12:16:52.509Z | 2024-10-30T12:26:48.497Z |
5341346 | 5341346 | 20241022012818_j0aLV | CZ000B | 2024-10-23T12:15:41.035Z | 2024-10-30T12:26:46.938Z |
5340660 | 5340660 | 20241022004033_kb0w3 | CZ000B | 2024-10-23T12:14:46.276Z | 2024-10-30T12:26:46.117Z |
5339936 | 5339936 | 20241021233048_SchOf | CZ000B | 2024-10-23T12:14:10.287Z | 2024-10-30T12:26:45.094Z |
5339131 | 5339131 | 20241021215150_1f2iM | CZ000B | 2024-10-23T12:12:36.909Z | 2024-10-30T12:26:43.659Z |
5335238 | 5335238 | 20241021041401_SPKQz | CZ000B | 2024-10-22T12:18:04.426Z | 2024-10-29T12:26:36.084Z |
5335159 | 5335159 | 20241021040355_DQV4D | CZ000B | 2024-10-22T12:18:00.580Z | 2024-10-29T12:26:36.010Z |
5335127 | 5335127 | 20241021040028_k72Yo | CZ000B | 2024-10-22T12:17:59.492Z | 2024-10-29T12:26:35.992Z |
5327543 | 5327543 | 20241020023640_L43gC | CZ000B | 2024-10-21T12:12:18.294Z | 2024-10-28T12:26:45.565Z |
5327112 | 5327112 | 20241020002130_pLiUR | CZ000B | 2024-10-21T12:11:14.019Z | 2024-10-28T12:26:43.469Z |
5326996 | 5326996 | 20241019234613_mPpX2 | CZ000B | 2024-10-21T12:11:02.413Z | 2024-10-28T12:26:43.170Z |
5323174 | 5323174 | 20241018222505_wgCCw | CZ000B | 2024-10-20T12:05:21.600Z | 2024-10-27T12:28:49.700Z |
5318520 | 5318520 | 20241017034322_JE9nB | CZ000B | 2024-10-18T12:03:55.867Z | 2024-10-25T12:24:36.083Z |
5318484 | 5318484 | 20241017033603_OHSAv | CZ000B | 2024-10-18T12:03:52.530Z | 2024-10-25T12:24:36.025Z |
5318378 | 5318378 | 20241017025738_2gZ4w | CZ000B | 2024-10-18T12:03:41.327Z | 2024-10-25T12:24:35.051Z |
5318247 | 5318247 | 20241017014748_XdS4w | CZ000B | 2024-10-18T12:03:14.670Z | 2024-10-25T12:24:34.102Z |
5318189 | 5318189 | 20241017002059_TnN1g | CZ000B | 2024-10-18T12:03:05.991Z | 2024-10-25T12:24:33.675Z |
5318184 | 5318184 | 20241017001458_bjQAG | CZ000B | 2024-10-18T12:03:05.502Z | 2024-10-25T12:24:33.659Z |
5317264 | 5317264 | 20241016034454_frhdX | CZ000B | 2024-10-17T12:08:15.292Z | 2024-10-24T12:27:59.639Z |
5317194 | 5317194 | 20241016032519_RM9oj | CZ000B | 2024-10-17T12:08:03.607Z | 2024-10-24T12:27:59.308Z |
5317058 | 5317058 | 20241016024805_WeX20 | CZ000B | 2024-10-17T12:07:44.203Z | 2024-10-24T12:27:58.714Z |
5316990 | 5316990 | 20241016022019_iwMpD | CZ000B | 2024-10-17T12:07:31.743Z | 2024-10-24T12:27:58.508Z |
5316902 | 5316902 | 20241016015319_olb2o | CZ000B | 2024-10-17T12:07:19.401Z | 2024-10-24T12:27:58.278Z |
5316878 | 5316878 | 20241016014708_68O9W | CZ000B | 2024-10-17T12:07:15.971Z | 2024-10-24T12:27:58.101Z |
5316838 | 5316838 | 20241016013153_p5b5H | CZ000B | 2024-10-17T12:07:12.442Z | 2024-10-24T12:27:58.019Z |
5316720 | 5316720 | 20241016004402_wYWDO | CZ000B | 2024-10-17T12:07:02.825Z | 2024-10-24T12:27:57.778Z |
5316665 | 5316665 | 20241016002033_WhAoO | CZ000B | 2024-10-17T12:06:57.097Z | 2024-10-24T12:27:57.216Z |
5316619 | 5316619 | 20241015235418_aVDin | CZ000B | 2024-10-17T12:06:54.143Z | 2024-10-24T12:27:57.070Z |
5316554 | 5316554 | 20241015231812_y8GK7 | CZ000B | 2024-10-17T12:06:49.600Z | 2024-10-24T12:27:56.804Z |
5316496 | 5316496 | 20241015223458_sv6Qh | CZ000B | 2024-10-17T12:06:44.899Z | 2024-10-24T12:27:56.636Z |
5316458 | 5316458 | 20241015220531_2Vdr2 | CZ000B | 2024-10-17T12:06:41.733Z | 2024-10-24T12:27:56.568Z |
5316395 | 5316395 | 20241015210846_hW4mz | CZ000B | 2024-10-17T12:06:31.969Z | 2024-10-24T12:27:56.388Z |
5306463 | 5306463 | 20241014022957_0Oxt3 | CZ000B | 2024-10-15T12:07:28.683Z | 2024-10-22T12:24:40.063Z |
5155802 | 5155802 | 20240923184029_9rWjL | CZ000B | 2024-09-25T12:06:15.529Z | 2024-10-01T12:22:20.422Z |
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);