participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
814 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 |
---|---|---|---|---|---|
5613524 | 5613524 | 20241125234849_AxSS0 | CZ000G | 2024-11-27T14:18:32.518Z | 2024-11-30T14:26:21.206Z |
5613084 | 5613084 | 20241125230251_ZY8wM | CZ000G | 2024-11-27T14:18:08.385Z | 2024-11-30T14:26:18.816Z |
5613017 | 5613017 | 20241125225349_KYtD8 | CZ000G | 2024-11-27T14:18:03.738Z | 2024-11-30T14:26:18.500Z |
5612870 | 5612870 | 20241125224121_0sIgy | CZ000G | 2024-11-27T14:17:58.577Z | 2024-11-30T14:26:16.761Z |
5612399 | 5612399 | 20241125214002_Zh9NQ | CZ000G | 2024-11-27T14:17:44.835Z | 2024-11-30T14:26:13.030Z |
5604053 | 5604053 | 20241124201148_DSNUY | CZ000G | 2024-11-26T14:16:18.901Z | 2024-11-30T14:27:11.429Z |
5599107 | 5599107 | 20241123234155_c4xzJ | CZ000G | 2024-11-25T14:16:42.366Z | 2024-11-30T14:27:53.713Z |
5591044 | 5591044 | 20241122210549_q3W0S | CZ000G | 2024-11-24T14:19:20.692Z | 2024-11-30T14:28:26.994Z |
5570618 | 5570618 | 20241120202927_NMWUt | CZ000G | 2024-11-22T14:15:56.257Z | 2024-11-29T14:26:40.520Z |
5570605 | 5570605 | 20241120202350_39GRj | CZ000G | 2024-11-22T14:15:53.389Z | 2024-11-29T14:26:40.382Z |
5553712 | 5553712 | 20241118035535_LXWja | CZ000G | 2024-11-19T14:11:19.412Z | 2024-11-26T14:28:54.216Z |
5553465 | 5553465 | 20241118024804_2RW2H | CZ000G | 2024-11-19T14:10:38.427Z | 2024-11-26T14:28:51.059Z |
5517766 | 5517766 | 20241110044716_GfrYk | CZ000G | 2024-11-11T14:14:50.738Z | 2024-11-18T14:26:38.128Z |
5517122 | 5517122 | 20241110025029_AGPn6 | CZ000G | 2024-11-11T14:13:56.763Z | 2024-11-18T14:26:34.796Z |
5517039 | 5517039 | 20241110023801_Fx0AZ | CZ000G | 2024-11-11T14:13:46.249Z | 2024-11-18T14:26:34.354Z |
5516973 | 5516973 | 20241110022857_vBcGn | CZ000G | 2024-11-11T14:13:39.682Z | 2024-11-18T14:26:34.042Z |
5516798 | 5516798 | 20241110020459_QJ9lE | CZ000G | 2024-11-11T14:13:23.269Z | 2024-11-18T14:26:33.382Z |
5516692 | 5516692 | 20241110014316_MRfVg | CZ000G | 2024-11-11T14:13:15.370Z | 2024-11-18T14:26:32.837Z |
5516667 | 5516667 | 20241110013716_cWWKu | CZ000G | 2024-11-11T14:13:14.336Z | 2024-11-18T14:26:32.701Z |
5516512 | 5516512 | 20241110011052_BPFtG | CZ000G | 2024-11-11T14:13:05.726Z | 2024-11-18T14:26:31.617Z |
5516324 | 5516324 | 20241110004024_EJsMV | CZ000G | 2024-11-11T14:12:44.244Z | 2024-11-18T14:26:30.683Z |
5516234 | 5516234 | 20241110001814_spI9p | CZ000G | 2024-11-11T14:12:31.740Z | 2024-11-18T14:26:30.213Z |
5515955 | 5515955 | 20241109232014_dg3Yf | CZ000G | 2024-11-11T14:11:50.877Z | 2024-11-18T14:26:28.640Z |
5515783 | 5515783 | 20241109224343_KrQyh | CZ000G | 2024-11-11T14:11:28.077Z | 2024-11-18T14:26:27.956Z |
5515679 | 5515679 | 20241109222235_UEoj5 | CZ000G | 2024-11-11T14:11:21.311Z | 2024-11-18T14:26:27.395Z |
5515669 | 5515669 | 20241109221824_sh3GR | CZ000G | 2024-11-11T14:11:20.670Z | 2024-11-18T14:26:27.343Z |
5515657 | 5515657 | 20241109221621_yL5Sn | CZ000G | 2024-11-11T14:11:19.872Z | 2024-11-18T14:26:27.269Z |
5515505 | 5515505 | 20241109214021_XLv0z | CZ000G | 2024-11-11T14:11:09.154Z | 2024-11-18T14:26:26.413Z |
5515495 | 5515495 | 20241109213821_8k6n2 | CZ000G | 2024-11-11T14:11:08.329Z | 2024-11-18T14:26:26.329Z |
5514939 | 5514939 | 20241109183740_2LOF8 | CZ000G | 2024-11-11T14:09:46.390Z | 2024-11-18T14:26:23.475Z |
5511036 | 5511036 | 20241109041049_Sw44q | CZ000G | 2024-11-10T14:16:06.756Z | 2024-11-17T14:24:03.628Z |
5510879 | 5510879 | 20241109034807_SVBj4 | CZ000G | 2024-11-10T14:15:48.851Z | 2024-11-17T14:24:02.136Z |
5510794 | 5510794 | 20241109033714_gq6nd | CZ000G | 2024-11-10T14:15:43.395Z | 2024-11-17T14:24:01.399Z |
5510707 | 5510707 | 20241109032803_beGjm | CZ000G | 2024-11-10T14:15:35.565Z | 2024-11-17T14:24:00.589Z |
5510576 | 5510576 | 20241109030318_aJNpX | CZ000G | 2024-11-10T14:15:27.655Z | 2024-11-17T14:23:59.396Z |
5510244 | 5510244 | 20241109020536_BzpGv | CZ000G | 2024-11-10T14:14:51.363Z | 2024-11-17T14:23:54.540Z |
5509845 | 5509845 | 20241109004958_p7es4 | CZ000G | 2024-11-10T14:14:06.720Z | 2024-11-17T14:23:49.988Z |
5509504 | 5509504 | 20241108233402_y0gUs | CZ000G | 2024-11-10T14:13:28.586Z | 2024-11-17T14:23:46.266Z |
5509445 | 5509445 | 20241108231925_KPhsk | CZ000G | 2024-11-10T14:13:23.742Z | 2024-11-17T14:23:44.571Z |
5509067 | 5509067 | 20241108214029_1O51Q | CZ000G | 2024-11-10T14:12:26.619Z | 2024-11-17T14:23:39.960Z |
5505141 | 5505141 | 20241108035832_YMiHT | CZ000G | 2024-11-09T14:15:50.366Z | 2024-11-16T14:28:28.075Z |
5505075 | 5505075 | 20241108034920_Bvtvj | CZ000G | 2024-11-09T14:15:41.807Z | 2024-11-16T14:28:26.325Z |
5504880 | 5504880 | 20241108031211_8xZ1n | CZ000G | 2024-11-09T14:15:19.389Z | 2024-11-16T14:28:24.384Z |
5504361 | 5504361 | 20241108014816_qTCig | CZ000G | 2024-11-09T14:14:29.152Z | 2024-11-16T14:28:19.392Z |
5504088 | 5504088 | 20241108005105_xXM2O | CZ000G | 2024-11-09T14:14:03.658Z | 2024-11-16T14:28:15.942Z |
5503949 | 5503949 | 20241108002330_jRZqu | CZ000G | 2024-11-09T14:13:54.458Z | 2024-11-16T14:28:14.090Z |
5503689 | 5503689 | 20241107233012_ordsC | CZ000G | 2024-11-09T14:13:35.731Z | 2024-11-16T14:28:11.248Z |
5503504 | 5503504 | 20241107223748_mMiiG | CZ000G | 2024-11-09T14:13:13.626Z | 2024-11-16T14:28:08.338Z |
5503484 | 5503484 | 20241107222953_YXCxg | CZ000G | 2024-11-09T14:13:09.937Z | 2024-11-16T14:28:07.710Z |
5503206 | 5503206 | 20241107205837_fAJbT | CZ000G | 2024-11-09T14:12:34.006Z | 2024-11-16T14:28:04.468Z |
5503155 | 5503155 | 20241107205318_aVGka | CZ000G | 2024-11-09T14:12:28.312Z | 2024-11-16T14:28:03.829Z |
5502415 | 5502415 | 20241107182636_sJcIk | CZ000G | 2024-11-09T14:11:17.920Z | 2024-11-16T14:27:55.404Z |
5502230 | 5502230 | 20241107174703_16PSV | CZ000G | 2024-11-09T14:11:05.038Z | 2024-11-16T14:27:51.937Z |
5491577 | 5491577 | 20241106035449_t1VWp | CZ000G | 2024-11-07T14:16:25.482Z | 2024-11-14T14:23:26.183Z |
5491565 | 5491565 | 20241106035046_FcIRo | CZ000G | 2024-11-07T14:16:23.682Z | 2024-11-14T14:23:26.122Z |
5491561 | 5491561 | 20241106034748_B4Zw8 | CZ000G | 2024-11-07T14:16:23.184Z | 2024-11-14T14:23:26.087Z |
5491302 | 5491302 | 20241106025214_NGuFD | CZ000G | 2024-11-07T14:15:49.557Z | 2024-11-14T14:23:25.064Z |
5491273 | 5491273 | 20241106024349_UhxKJ | CZ000G | 2024-11-07T14:15:45.398Z | 2024-11-14T14:23:25.021Z |
5491262 | 5491262 | 20241106023848_6djdS | CZ000G | 2024-11-07T14:15:43.606Z | 2024-11-14T14:23:25.004Z |
5490246 | 5490246 | 20241105214705_dGaEK | CZ000G | 2024-11-07T14:13:42.955Z | 2024-11-14T14:23:18.390Z |
5489354 | 5489354 | 20241105183910_TiIS3 | CZ000G | 2024-11-07T14:11:55.566Z | 2024-11-14T14:23:12.571Z |
5485146 | 5485146 | 20241105040958_7EQL9 | CZ000G | 2024-11-06T14:17:50.240Z | 2024-11-13T14:27:40.858Z |
5484997 | 5484997 | 20241105035226_zg43J | CZ000G | 2024-11-06T14:17:37.536Z | 2024-11-13T14:27:40.449Z |
5484787 | 5484787 | 20241105033028_veZbH | CZ000G | 2024-11-06T14:17:17.051Z | 2024-11-13T14:27:39.858Z |
5483976 | 5483976 | 20241105015055_3stMk | CZ000G | 2024-11-06T14:15:59.718Z | 2024-11-13T14:27:37.077Z |
5483909 | 5483909 | 20241105014337_tMB9P | CZ000G | 2024-11-06T14:15:52.717Z | 2024-11-13T14:27:37.011Z |
5478587 | 5478587 | 20241104043546_x9tt6 | CZ000G | 2024-11-05T14:18:32.777Z | 2024-11-12T14:28:16.282Z |
5476503 | 5476503 | 20241103233618_Koxm1 | CZ000G | 2024-11-05T14:15:32.076Z | 2024-11-12T14:28:06.335Z |
5476026 | 5476026 | 20241103221017_6PDtK | CZ000G | 2024-11-05T14:14:40.484Z | 2024-11-12T14:28:02.445Z |
5475903 | 5475903 | 20241103214833_cB2u0 | CZ000G | 2024-11-05T14:14:32.925Z | 2024-11-12T14:28:01.782Z |
5475649 | 5475649 | 20241103205502_IErKJ | CZ000G | 2024-11-05T14:13:55.646Z | 2024-11-12T14:28:00.148Z |
5475604 | 5475604 | 20241103204906_8kgWJ | CZ000G | 2024-11-05T14:13:52.433Z | 2024-11-12T14:28:00.052Z |
5475120 | 5475120 | 20241103190939_gvzIC | CZ000G | 2024-11-05T14:12:34.625Z | 2024-11-12T14:27:57.176Z |
5474566 | 5474566 | 20241103173926_o22o7 | CZ000G | 2024-11-05T14:11:16.254Z | 2024-11-12T14:27:52.990Z |
5474441 | 5474441 | 20241103171945_2MOTs | CZ000G | 2024-11-05T14:11:05.643Z | 2024-11-12T14:27:51.734Z |
5468340 | 5468340 | 20241103001439_Zi0JN | CZ000G | 2024-11-04T14:13:58.804Z | 2024-11-11T14:22:52.781Z |
5468198 | 5468198 | 20241102234828_73odw | CZ000G | 2024-11-04T14:13:43.707Z | 2024-11-11T14:22:52.006Z |
5468189 | 5468189 | 20241102234740_R3G2l | CZ000G | 2024-11-04T14:13:38.876Z | 2024-11-11T14:22:51.986Z |
5468096 | 5468096 | 20241102232730_ea3BE | CZ000G | 2024-11-04T14:13:16.160Z | 2024-11-11T14:22:51.293Z |
5468054 | 5468054 | 20241102232238_Yyinb | CZ000G | 2024-11-04T14:13:11.847Z | 2024-11-11T14:22:51.105Z |
5467515 | 5467515 | 20241102213420_ypnxl | CZ000G | 2024-11-04T14:11:49.552Z | 2024-11-11T14:22:47.415Z |
5467397 | 5467397 | 20241102205844_Q63nO | CZ000G | 2024-11-04T14:11:25.770Z | 2024-11-11T14:22:46.698Z |
5466951 | 5466951 | 20241102192851_b2pjF | CZ000G | 2024-11-04T14:10:21.937Z | 2024-11-11T14:22:44.509Z |
5466744 | 5466744 | 20241102184403_oxUAX | CZ000G | 2024-11-04T14:09:41.332Z | 2024-11-11T14:22:42.982Z |
5466188 | 5466188 | 20241102164253_i7A3s | CZ000G | 2024-11-04T14:08:12.140Z | 2024-11-11T14:22:39.704Z |
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 |
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);