participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
958 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 |
---|---|---|---|---|---|
5570603 | 5570603 | 20241120202350_39GRj | CZ000B | 2024-11-22T14:15:53.389Z | 2024-11-23T14:23:13.530Z |
5553711 | 5553711 | 20241118035535_LXWja | CZ000B | 2024-11-19T14:11:19.412Z | 2024-11-23T14:25:30.525Z |
5553652 | 5553652 | 20241118034048_tCI3U | CZ000B | 2024-11-19T14:11:10.135Z | 2024-11-23T14:25:30.316Z |
5517765 | 5517765 | 20241110044716_GfrYk | CZ000B | 2024-11-11T14:14:50.738Z | 2024-11-18T14:26:38.128Z |
5517551 | 5517551 | 20241110040154_Y9V2Z | CZ000B | 2024-11-11T14:14:34.778Z | 2024-11-18T14:26:37.127Z |
5517485 | 5517485 | 20241110035346_naUQn | CZ000B | 2024-11-11T14:14:29.550Z | 2024-11-18T14:26:36.760Z |
5516511 | 5516511 | 20241110011052_BPFtG | CZ000B | 2024-11-11T14:13:05.726Z | 2024-11-18T14:26:31.617Z |
5516323 | 5516323 | 20241110004024_EJsMV | CZ000B | 2024-11-11T14:12:44.244Z | 2024-11-18T14:26:30.683Z |
5516271 | 5516271 | 20241110002626_cKF8J | CZ000B | 2024-11-11T14:12:38.649Z | 2024-11-18T14:26:30.388Z |
5516233 | 5516233 | 20241110001814_spI9p | CZ000B | 2024-11-11T14:12:31.740Z | 2024-11-18T14:26:30.212Z |
5516037 | 5516037 | 20241109233838_Y3i8w | CZ000B | 2024-11-11T14:12:01.668Z | 2024-11-18T14:26:29.103Z |
5516010 | 5516010 | 20241109233433_R39fD | CZ000B | 2024-11-11T14:11:58.943Z | 2024-11-18T14:26:28.934Z |
5515818 | 5515818 | 20241109225103_Npn2k | CZ000B | 2024-11-11T14:11:32.898Z | 2024-11-18T14:26:28.107Z |
5515782 | 5515782 | 20241109224343_KrQyh | CZ000B | 2024-11-11T14:11:28.077Z | 2024-11-18T14:26:27.956Z |
5515578 | 5515578 | 20241109220337_B0iKl | CZ000B | 2024-11-11T14:11:14.574Z | 2024-11-18T14:26:26.848Z |
5515504 | 5515504 | 20241109214021_XLv0z | CZ000B | 2024-11-11T14:11:09.154Z | 2024-11-18T14:26:26.413Z |
5515384 | 5515384 | 20241109210608_wvGf1 | CZ000B | 2024-11-11T14:10:53.044Z | 2024-11-18T14:26:25.789Z |
5515360 | 5515360 | 20241109205632_DeAJz | CZ000B | 2024-11-11T14:10:50.315Z | 2024-11-18T14:26:25.698Z |
5515236 | 5515236 | 20241109195956_4QotY | CZ000B | 2024-11-11T14:10:25.215Z | 2024-11-18T14:26:25.057Z |
5515147 | 5515147 | 20241109194107_Bh4R3 | CZ000B | 2024-11-11T14:10:11.054Z | 2024-11-18T14:26:24.547Z |
5515117 | 5515117 | 20241109192737_sYbvT | CZ000B | 2024-11-11T14:10:06.215Z | 2024-11-18T14:26:24.372Z |
5510878 | 5510878 | 20241109034807_SVBj4 | CZ000B | 2024-11-10T14:15:48.851Z | 2024-11-17T14:24:02.136Z |
5510589 | 5510589 | 20241109030536_07tzl | CZ000B | 2024-11-10T14:15:28.537Z | 2024-11-17T14:23:59.554Z |
5510069 | 5510069 | 20241109013852_R27EG | CZ000B | 2024-11-10T14:14:32.613Z | 2024-11-17T14:23:52.653Z |
5509503 | 5509503 | 20241108233402_y0gUs | CZ000B | 2024-11-10T14:13:28.586Z | 2024-11-17T14:23:46.266Z |
5509444 | 5509444 | 20241108231925_KPhsk | CZ000B | 2024-11-10T14:13:23.742Z | 2024-11-17T14:23:44.571Z |
5509377 | 5509377 | 20241108230220_v9Wlc | CZ000B | 2024-11-10T14:13:17.027Z | 2024-11-17T14:23:43.737Z |
5509066 | 5509066 | 20241108214029_1O51Q | CZ000B | 2024-11-10T14:12:26.618Z | 2024-11-17T14:23:39.960Z |
5508894 | 5508894 | 20241108203006_Aj2p1 | CZ000B | 2024-11-10T14:12:00.634Z | 2024-11-17T14:23:36.151Z |
5505140 | 5505140 | 20241108035832_YMiHT | CZ000B | 2024-11-09T14:15:50.366Z | 2024-11-16T14:28:28.075Z |
5503154 | 5503154 | 20241107205318_aVGka | CZ000B | 2024-11-09T14:12:28.312Z | 2024-11-16T14:28:03.829Z |
5502577 | 5502577 | 20241107191022_7DY6k | CZ000B | 2024-11-09T14:11:45.770Z | 2024-11-16T14:27:57.630Z |
5502363 | 5502363 | 20241107181331_56ula | CZ000B | 2024-11-09T14:11:13.578Z | 2024-11-16T14:27:54.621Z |
5491576 | 5491576 | 20241106035449_t1VWp | CZ000B | 2024-11-07T14:16:25.482Z | 2024-11-14T14:23:26.183Z |
5490670 | 5490670 | 20241106000217_yuiF5 | CZ000B | 2024-11-07T14:14:27.782Z | 2024-11-14T14:23:21.184Z |
5490630 | 5490630 | 20241105234758_U8aSY | CZ000B | 2024-11-07T14:14:20.309Z | 2024-11-14T14:23:21.032Z |
5490450 | 5490450 | 20241105225350_AuVmb | CZ000B | 2024-11-07T14:14:02.987Z | 2024-11-14T14:23:20.365Z |
5484642 | 5484642 | 20241105031620_rbup3 | CZ000B | 2024-11-06T14:17:07.672Z | 2024-11-13T14:27:38.993Z |
5484117 | 5484117 | 20241105021045_XrIgL | CZ000B | 2024-11-06T14:16:19.612Z | 2024-11-13T14:27:37.346Z |
5483908 | 5483908 | 20241105014337_tMB9P | CZ000B | 2024-11-06T14:15:52.701Z | 2024-11-13T14:27:37.011Z |
5475974 | 5475974 | 20241103220300_1D3m2 | CZ000B | 2024-11-05T14:14:36.889Z | 2024-11-12T14:28:01.992Z |
5475693 | 5475693 | 20241103210411_Ruzi0 | CZ000B | 2024-11-05T14:14:01.653Z | 2024-11-12T14:28:00.542Z |
5475647 | 5475647 | 20241103205502_IErKJ | CZ000B | 2024-11-05T14:13:55.646Z | 2024-11-12T14:28:00.148Z |
5475603 | 5475603 | 20241103204906_8kgWJ | CZ000B | 2024-11-05T14:13:52.433Z | 2024-11-12T14:28:00.052Z |
5475597 | 5475597 | 20241103204720_TwetH | CZ000B | 2024-11-05T14:13:52.061Z | 2024-11-12T14:28:00.049Z |
5474965 | 5474965 | 20241103184250_oys8f | CZ000B | 2024-11-05T14:12:20.297Z | 2024-11-12T14:27:55.853Z |
5474919 | 5474919 | 20241103183713_se4OL | CZ000B | 2024-11-05T14:12:16.729Z | 2024-11-12T14:27:55.589Z |
5474462 | 5474462 | 20241103172436_KkdVz | CZ000B | 2024-11-05T14:11:07.000Z | 2024-11-12T14:27:51.874Z |
5469397 | 5469397 | 20241103032146_BRXHJ | CZ000B | 2024-11-04T14:16:23.986Z | 2024-11-11T14:23:00.044Z |
5468188 | 5468188 | 20241102234740_R3G2l | CZ000B | 2024-11-04T14:13:38.876Z | 2024-11-11T14:22:51.986Z |
5468094 | 5468094 | 20241102232730_ea3BE | CZ000B | 2024-11-04T14:13:16.160Z | 2024-11-11T14:22:51.293Z |
5468039 | 5468039 | 20241102231947_GmWO0 | CZ000B | 2024-11-04T14:13:10.179Z | 2024-11-11T14:22:51.056Z |
5467948 | 5467948 | 20241102230116_v0Mgh | CZ000B | 2024-11-04T14:13:00.985Z | 2024-11-11T14:22:50.570Z |
5467935 | 5467935 | 20241102225829_a2YZE | CZ000B | 2024-11-04T14:12:59.098Z | 2024-11-11T14:22:50.358Z |
5467878 | 5467878 | 20241102224835_5TWTE | CZ000B | 2024-11-04T14:12:53.827Z | 2024-11-11T14:22:50.249Z |
5467738 | 5467738 | 20241102222753_io2jS | CZ000B | 2024-11-04T14:12:26.380Z | 2024-11-11T14:22:49.233Z |
5467627 | 5467627 | 20241102220717_2zaWq | CZ000B | 2024-11-04T14:12:15.389Z | 2024-11-11T14:22:48.548Z |
5467483 | 5467483 | 20241102212723_5pcSE | CZ000B | 2024-11-04T14:11:41.082Z | 2024-11-11T14:22:47.313Z |
5467396 | 5467396 | 20241102205844_Q63nO | CZ000B | 2024-11-04T14:11:25.770Z | 2024-11-11T14:22:46.698Z |
5467090 | 5467090 | 20241102200515_RWqBJ | CZ000B | 2024-11-04T14:10:36.553Z | 2024-11-11T14:22:45.297Z |
5466950 | 5466950 | 20241102192851_b2pjF | CZ000B | 2024-11-04T14:10:21.883Z | 2024-11-11T14:22:44.509Z |
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 |
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);