participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
784 rows where station_code = "CZ000G" 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 |
---|---|---|---|---|---|
5511036 | 5511036 | 20241109041049_Sw44q | CZ000G | 2024-11-10T14:16:06.756Z | 2024-11-10T14:16:52.671Z |
5510879 | 5510879 | 20241109034807_SVBj4 | CZ000G | 2024-11-10T14:15:48.851Z | 2024-11-10T14:16:52.637Z |
5510794 | 5510794 | 20241109033714_gq6nd | CZ000G | 2024-11-10T14:15:43.395Z | 2024-11-10T14:16:52.618Z |
5510707 | 5510707 | 20241109032803_beGjm | CZ000G | 2024-11-10T14:15:35.565Z | 2024-11-10T14:16:52.598Z |
5510576 | 5510576 | 20241109030318_aJNpX | CZ000G | 2024-11-10T14:15:27.655Z | 2024-11-10T14:16:52.567Z |
5510244 | 5510244 | 20241109020536_BzpGv | CZ000G | 2024-11-10T14:14:51.363Z | 2024-11-10T14:16:52.486Z |
5509845 | 5509845 | 20241109004958_p7es4 | CZ000G | 2024-11-10T14:14:06.720Z | 2024-11-10T14:16:52.389Z |
5509504 | 5509504 | 20241108233402_y0gUs | CZ000G | 2024-11-10T14:13:28.586Z | 2024-11-10T14:16:52.287Z |
5509445 | 5509445 | 20241108231925_KPhsk | CZ000G | 2024-11-10T14:13:23.742Z | 2024-11-10T14:16:52.268Z |
5509067 | 5509067 | 20241108214029_1O51Q | CZ000G | 2024-11-10T14:12:26.619Z | 2024-11-10T14:16:52.156Z |
5505141 | 5505141 | 20241108035832_YMiHT | CZ000G | 2024-11-09T14:15:50.366Z | 2024-11-10T14:20:05.175Z |
5505075 | 5505075 | 20241108034920_Bvtvj | CZ000G | 2024-11-09T14:15:41.807Z | 2024-11-10T14:20:03.432Z |
5504880 | 5504880 | 20241108031211_8xZ1n | CZ000G | 2024-11-09T14:15:19.389Z | 2024-11-10T14:19:55.520Z |
5504361 | 5504361 | 20241108014816_qTCig | CZ000G | 2024-11-09T14:14:29.152Z | 2024-11-10T14:19:36.958Z |
5504088 | 5504088 | 20241108005105_xXM2O | CZ000G | 2024-11-09T14:14:03.658Z | 2024-11-10T14:19:29.859Z |
5503949 | 5503949 | 20241108002330_jRZqu | CZ000G | 2024-11-09T14:13:54.458Z | 2024-11-10T14:19:24.364Z |
5503689 | 5503689 | 20241107233012_ordsC | CZ000G | 2024-11-09T14:13:35.731Z | 2024-11-10T14:19:16.494Z |
5503504 | 5503504 | 20241107223748_mMiiG | CZ000G | 2024-11-09T14:13:13.626Z | 2024-11-10T14:19:11.745Z |
5503484 | 5503484 | 20241107222953_YXCxg | CZ000G | 2024-11-09T14:13:09.937Z | 2024-11-10T14:19:10.895Z |
5503206 | 5503206 | 20241107205837_fAJbT | CZ000G | 2024-11-09T14:12:34.006Z | 2024-11-10T14:19:00.965Z |
5503155 | 5503155 | 20241107205318_aVGka | CZ000G | 2024-11-09T14:12:28.312Z | 2024-11-10T14:18:59.248Z |
5502415 | 5502415 | 20241107182636_sJcIk | CZ000G | 2024-11-09T14:11:17.920Z | 2024-11-10T14:18:37.404Z |
5502230 | 5502230 | 20241107174703_16PSV | CZ000G | 2024-11-09T14:11:05.038Z | 2024-11-10T14:18:30.077Z |
5491577 | 5491577 | 20241106035449_t1VWp | CZ000G | 2024-11-07T14:16:25.482Z | 2024-11-10T14:23:27.926Z |
5491565 | 5491565 | 20241106035046_FcIRo | CZ000G | 2024-11-07T14:16:23.682Z | 2024-11-10T14:23:27.859Z |
5491561 | 5491561 | 20241106034748_B4Zw8 | CZ000G | 2024-11-07T14:16:23.184Z | 2024-11-10T14:23:27.752Z |
5491302 | 5491302 | 20241106025214_NGuFD | CZ000G | 2024-11-07T14:15:49.557Z | 2024-11-10T14:23:24.641Z |
5491273 | 5491273 | 20241106024349_UhxKJ | CZ000G | 2024-11-07T14:15:45.398Z | 2024-11-10T14:23:24.522Z |
5491262 | 5491262 | 20241106023848_6djdS | CZ000G | 2024-11-07T14:15:43.606Z | 2024-11-10T14:23:24.344Z |
5490246 | 5490246 | 20241105214705_dGaEK | CZ000G | 2024-11-07T14:13:42.955Z | 2024-11-10T14:23:12.120Z |
5489354 | 5489354 | 20241105183910_TiIS3 | CZ000G | 2024-11-07T14:11:55.566Z | 2024-11-10T14:23:01.462Z |
5485146 | 5485146 | 20241105040958_7EQL9 | CZ000G | 2024-11-06T14:17:50.240Z | 2024-11-10T14:24:27.455Z |
5484997 | 5484997 | 20241105035226_zg43J | CZ000G | 2024-11-06T14:17:37.536Z | 2024-11-10T14:24:26.532Z |
5484787 | 5484787 | 20241105033028_veZbH | CZ000G | 2024-11-06T14:17:17.051Z | 2024-11-10T14:24:25.099Z |
5483976 | 5483976 | 20241105015055_3stMk | CZ000G | 2024-11-06T14:15:59.718Z | 2024-11-10T14:24:18.428Z |
5483909 | 5483909 | 20241105014337_tMB9P | CZ000G | 2024-11-06T14:15:52.717Z | 2024-11-10T14:24:18.165Z |
5478587 | 5478587 | 20241104043546_x9tt6 | CZ000G | 2024-11-05T14:18:32.777Z | 2024-11-10T14:25:23.482Z |
5476503 | 5476503 | 20241103233618_Koxm1 | CZ000G | 2024-11-05T14:15:32.076Z | 2024-11-10T14:25:08.061Z |
5476026 | 5476026 | 20241103221017_6PDtK | CZ000G | 2024-11-05T14:14:40.484Z | 2024-11-10T14:25:03.722Z |
5475903 | 5475903 | 20241103214833_cB2u0 | CZ000G | 2024-11-05T14:14:32.925Z | 2024-11-10T14:25:02.065Z |
5475649 | 5475649 | 20241103205502_IErKJ | CZ000G | 2024-11-05T14:13:55.646Z | 2024-11-10T14:24:59.008Z |
5475604 | 5475604 | 20241103204906_8kgWJ | CZ000G | 2024-11-05T14:13:52.433Z | 2024-11-10T14:24:58.459Z |
5475120 | 5475120 | 20241103190939_gvzIC | CZ000G | 2024-11-05T14:12:34.625Z | 2024-11-10T14:24:51.855Z |
5474566 | 5474566 | 20241103173926_o22o7 | CZ000G | 2024-11-05T14:11:16.254Z | 2024-11-10T14:24:48.497Z |
5474441 | 5474441 | 20241103171945_2MOTs | CZ000G | 2024-11-05T14:11:05.643Z | 2024-11-10T14:24:47.938Z |
5468340 | 5468340 | 20241103001439_Zi0JN | CZ000G | 2024-11-04T14:13:58.804Z | 2024-11-10T14:25:57.094Z |
5468198 | 5468198 | 20241102234828_73odw | CZ000G | 2024-11-04T14:13:43.707Z | 2024-11-10T14:25:55.847Z |
5468189 | 5468189 | 20241102234740_R3G2l | CZ000G | 2024-11-04T14:13:38.876Z | 2024-11-10T14:25:55.839Z |
5468096 | 5468096 | 20241102232730_ea3BE | CZ000G | 2024-11-04T14:13:16.160Z | 2024-11-10T14:25:55.034Z |
5468054 | 5468054 | 20241102232238_Yyinb | CZ000G | 2024-11-04T14:13:11.847Z | 2024-11-10T14:25:54.535Z |
5467515 | 5467515 | 20241102213420_ypnxl | CZ000G | 2024-11-04T14:11:49.552Z | 2024-11-10T14:25:51.755Z |
5467397 | 5467397 | 20241102205844_Q63nO | CZ000G | 2024-11-04T14:11:25.770Z | 2024-11-10T14:25:51.045Z |
5466951 | 5466951 | 20241102192851_b2pjF | CZ000G | 2024-11-04T14:10:21.937Z | 2024-11-10T14:25:48.425Z |
5466744 | 5466744 | 20241102184403_oxUAX | CZ000G | 2024-11-04T14:09:41.332Z | 2024-11-10T14:25:47.626Z |
5466188 | 5466188 | 20241102164253_i7A3s | CZ000G | 2024-11-04T14:08:12.140Z | 2024-11-10T14:25:43.475Z |
5430115 | 5430115 | 20241028211151_5aobM | CZ000G | 2024-10-31T12:17:40.540Z | 2024-11-06T14:27:18.887Z |
5429392 | 5429392 | 20241028191856_rvWm3 | CZ000G | 2024-10-31T12:16:30.693Z | 2024-11-06T14:27:15.892Z |
5388204 | 5388204 | 20241025041739_121qv | CZ000G | 2024-10-27T12:22:04.138Z | 2024-11-02T12:28:33.840Z |
5385469 | 5385469 | 20241024225043_oLfY6 | CZ000G | 2024-10-27T12:18:58.906Z | 2024-11-02T12:28:29.855Z |
5385318 | 5385318 | 20241024222355_SbCp1 | CZ000G | 2024-10-27T12:18:44.320Z | 2024-11-02T12:28:29.544Z |
5385273 | 5385273 | 20241024221713_3Xvhm | CZ000G | 2024-10-27T12:18:39.928Z | 2024-11-02T12:28:29.438Z |
5384883 | 5384883 | 20241024211247_OlSSQ | CZ000G | 2024-10-27T12:17:55.732Z | 2024-11-02T12:28:28.561Z |
5384651 | 5384651 | 20241024203223_opu2O | CZ000G | 2024-10-27T12:17:23.199Z | 2024-11-02T12:28:27.525Z |
5384049 | 5384049 | 20241024192807_tcQir | CZ000G | 2024-10-27T12:16:44.752Z | 2024-11-02T12:28:26.682Z |
5383552 | 5383552 | 20241024183214_uxALU | CZ000G | 2024-10-27T12:15:43.841Z | 2024-11-02T12:28:25.751Z |
5383462 | 5383462 | 20241024182302_ZHddG | CZ000G | 2024-10-27T12:15:30.595Z | 2024-11-02T12:28:25.378Z |
5382850 | 5382850 | 20241024171317_cZ5Kc | CZ000G | 2024-10-27T12:14:30.760Z | 2024-11-02T12:28:24.465Z |
5375746 | 5375746 | 20241024032728_6d9If | CZ000G | 2024-10-26T12:21:38.596Z | 2024-11-01T12:27:01.177Z |
5375635 | 5375635 | 20241024032208_siYcw | CZ000G | 2024-10-26T12:21:34.269Z | 2024-11-01T12:27:01.141Z |
5375371 | 5375371 | 20241024030925_8llIZ | CZ000G | 2024-10-26T12:21:22.510Z | 2024-11-01T12:27:00.651Z |
5374536 | 5374536 | 20241024023221_xTgKL | CZ000G | 2024-10-26T12:20:52.562Z | 2024-11-01T12:26:59.461Z |
5374336 | 5374336 | 20241024022255_hAxaj | CZ000G | 2024-10-26T12:20:45.487Z | 2024-11-01T12:26:58.851Z |
5373953 | 5373953 | 20241024020215_QNfft | CZ000G | 2024-10-26T12:20:32.554Z | 2024-11-01T12:26:58.607Z |
5373603 | 5373603 | 20241024014637_ecC3g | CZ000G | 2024-10-26T12:20:18.067Z | 2024-11-01T12:26:58.336Z |
5373011 | 5373011 | 20241024011932_jPQRT | CZ000G | 2024-10-26T12:19:53.181Z | 2024-11-01T12:26:58.094Z |
5355544 | 5355544 | 20241023034919_lGr7L | CZ000G | 2024-10-24T12:21:25.814Z | 2024-10-31T12:30:08.060Z |
5344305 | 5344305 | 20241022041452_VcITG | CZ000G | 2024-10-23T12:18:31.328Z | 2024-10-30T12:26:51.128Z |
5343810 | 5343810 | 20241022034721_YsCWg | CZ000G | 2024-10-23T12:18:08.707Z | 2024-10-30T12:26:50.617Z |
5343792 | 5343792 | 20241022034618_32Dit | CZ000G | 2024-10-23T12:18:07.966Z | 2024-10-30T12:26:50.548Z |
5343472 | 5343472 | 20241022033054_xeGHu | CZ000G | 2024-10-23T12:17:47.510Z | 2024-10-30T12:26:50.049Z |
5343284 | 5343284 | 20241022032032_Il3kJ | CZ000G | 2024-10-23T12:17:41.391Z | 2024-10-30T12:26:49.810Z |
5343210 | 5343210 | 20241022031626_VWktI | CZ000G | 2024-10-23T12:17:39.088Z | 2024-10-30T12:26:49.618Z |
5342522 | 5342522 | 20241022023223_q3jX3 | CZ000G | 2024-10-23T12:17:01.117Z | 2024-10-30T12:26:48.590Z |
5342427 | 5342427 | 20241022022558_fYhfe | CZ000G | 2024-10-23T12:16:52.509Z | 2024-10-30T12:26:48.497Z |
5341989 | 5341989 | 20241022020257_Jbn6a | CZ000G | 2024-10-23T12:16:27.626Z | 2024-10-30T12:26:47.780Z |
5341192 | 5341192 | 20241022012015_V1S7M | CZ000G | 2024-10-23T12:15:27.970Z | 2024-10-30T12:26:46.659Z |
5340139 | 5340139 | 20241021234822_u2xWq | CZ000G | 2024-10-23T12:14:20.404Z | 2024-10-30T12:26:45.422Z |
5339448 | 5339448 | 20241021224036_OFUww | CZ000G | 2024-10-23T12:13:07.821Z | 2024-10-30T12:26:44.195Z |
5339132 | 5339132 | 20241021215150_1f2iM | CZ000G | 2024-10-23T12:12:36.944Z | 2024-10-30T12:26:43.659Z |
5338156 | 5338156 | 20241021184709_nPU3G | CZ000G | 2024-10-23T12:10:24.940Z | 2024-10-30T12:26:41.814Z |
5334961 | 5334961 | 20241021033628_peIGN | CZ000G | 2024-10-22T12:17:40.036Z | 2024-10-29T12:26:35.779Z |
5327664 | 5327664 | 20241020031356_HBuWc | CZ000G | 2024-10-21T12:12:42.257Z | 2024-10-28T12:26:46.297Z |
5327653 | 5327653 | 20241020030941_ibSju | CZ000G | 2024-10-21T12:12:38.820Z | 2024-10-28T12:26:46.220Z |
5327544 | 5327544 | 20241020023640_L43gC | CZ000G | 2024-10-21T12:12:18.294Z | 2024-10-28T12:26:45.565Z |
5327308 | 5327308 | 20241020013055_auNKA | CZ000G | 2024-10-21T12:11:54.319Z | 2024-10-28T12:26:44.620Z |
5327185 | 5327185 | 20241020004821_Cnv4j | CZ000G | 2024-10-21T12:11:25.692Z | 2024-10-28T12:26:43.903Z |
5327076 | 5327076 | 20241020001533_ont3i | CZ000G | 2024-10-21T12:11:10.436Z | 2024-10-28T12:26:43.375Z |
5326997 | 5326997 | 20241019234613_mPpX2 | CZ000G | 2024-10-21T12:11:02.413Z | 2024-10-28T12:26:43.170Z |
5326943 | 5326943 | 20241019230626_cCl9K | CZ000G | 2024-10-21T12:10:57.988Z | 2024-10-28T12:26:43.106Z |
5323175 | 5323175 | 20241018222505_wgCCw | CZ000G | 2024-10-20T12:05:21.601Z | 2024-10-27T12:28:49.700Z |
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);