participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,682 rows where station_code = "CZ0008" 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 |
---|---|---|---|---|---|
5077693 | 5077693 | 20240911011119_6rmos | CZ0008 | 2024-09-15T12:15:00.351Z | 2024-09-19T12:21:39.520Z |
5077404 | 5077404 | 20240911004932_aMqkO | CZ0008 | 2024-09-15T12:14:43.093Z | 2024-09-19T12:21:38.970Z |
5076940 | 5076940 | 20240911001453_Ggn54 | CZ0008 | 2024-09-15T12:14:13.687Z | 2024-09-19T12:21:37.864Z |
5076844 | 5076844 | 20240911001034_gdbLC | CZ0008 | 2024-09-15T12:14:06.636Z | 2024-09-19T12:21:37.621Z |
5076702 | 5076702 | 20240911000335_BG339 | CZ0008 | 2024-09-15T12:13:56.848Z | 2024-09-19T12:21:37.477Z |
5076646 | 5076646 | 20240910235413_XgA6m | CZ0008 | 2024-09-15T12:13:49.803Z | 2024-09-19T12:21:37.421Z |
5076560 | 5076560 | 20240910234642_2JxkR | CZ0008 | 2024-09-15T12:13:43.115Z | 2024-09-19T12:21:37.345Z |
5065152 | 5065152 | 20240910031602_3zPRN | CZ0008 | 2024-09-14T12:16:29.338Z | 2024-09-18T12:15:18.525Z |
5065109 | 5065109 | 20240910030702_K9cQM | CZ0008 | 2024-09-14T12:16:26.153Z | 2024-09-18T12:15:18.409Z |
5065094 | 5065094 | 20240910030339_zU2Le | CZ0008 | 2024-09-14T12:16:24.901Z | 2024-09-18T12:15:18.373Z |
5065067 | 5065067 | 20240910030049_CAgxV | CZ0008 | 2024-09-14T12:16:22.122Z | 2024-09-18T12:15:18.323Z |
5064963 | 5064963 | 20240910024536_OrDMT | CZ0008 | 2024-09-14T12:16:13.720Z | 2024-09-18T12:15:17.989Z |
5064885 | 5064885 | 20240910022252_Mwqex | CZ0008 | 2024-09-14T12:16:08.250Z | 2024-09-18T12:15:17.611Z |
5064880 | 5064880 | 20240910022230_iaxDj | CZ0008 | 2024-09-14T12:16:08.092Z | 2024-09-18T12:15:17.605Z |
5059856 | 5059856 | 20240910190601_QtD5k | CZ0008 | 2024-09-14T12:07:26.548Z | 2024-09-19T12:21:31.332Z |
5054418 | 5054418 | 20240908024902_Qnqsc | CZ0008 | 2024-09-13T12:16:40.694Z | 2024-09-16T12:21:15.521Z |
5054148 | 5054148 | 20240908021626_QE6jS | CZ0008 | 2024-09-13T12:16:31.408Z | 2024-09-16T12:21:14.146Z |
5053974 | 5053974 | 20240908015641_W8X9E | CZ0008 | 2024-09-13T12:16:24.817Z | 2024-09-16T12:21:13.409Z |
5053964 | 5053964 | 20240908015622_gZfFU | CZ0008 | 2024-09-13T12:16:24.481Z | 2024-09-16T12:21:13.400Z |
5053959 | 5053959 | 20240908015610_dISb0 | CZ0008 | 2024-09-13T12:16:24.475Z | 2024-09-16T12:21:13.399Z |
5053679 | 5053679 | 20240908011646_6rR9b | CZ0008 | 2024-09-13T12:16:13.305Z | 2024-09-16T12:21:12.405Z |
5053312 | 5053312 | 20240908000918_novAe | CZ0008 | 2024-09-13T12:15:58.462Z | 2024-09-16T12:21:10.316Z |
5052923 | 5052923 | 20240907223747_nyeoY | CZ0008 | 2024-09-13T12:15:36.036Z | 2024-09-16T12:21:08.604Z |
5052746 | 5052746 | 20240907215043_LLw8r | CZ0008 | 2024-09-13T12:15:24.851Z | 2024-09-16T12:21:07.506Z |
5052597 | 5052597 | 20240907211311_Zsq4M | CZ0008 | 2024-09-13T12:15:14.954Z | 2024-09-16T12:21:06.623Z |
5039912 | 5039912 | 20240906022551_Z6Qx4 | CZ0008 | 2024-09-12T12:15:50.642Z | 2024-09-14T12:23:05.803Z |
5039796 | 5039796 | 20240906020331_pEUsZ | CZ0008 | 2024-09-12T12:15:45.514Z | 2024-09-14T12:23:04.717Z |
5039311 | 5039311 | 20240906001821_ebSyk | CZ0008 | 2024-09-12T12:15:25.807Z | 2024-09-14T12:23:01.379Z |
5033392 | 5033392 | 20240907025422_qAnSx | CZ0008 | 2024-09-12T12:09:25.029Z | 2024-09-15T12:21:29.981Z |
5033206 | 5033206 | 20240907023811_HgoFw | CZ0008 | 2024-09-12T12:08:57.723Z | 2024-09-15T12:21:29.201Z |
5032979 | 5032979 | 20240907021046_sPl8D | CZ0008 | 2024-09-12T12:08:41.166Z | 2024-09-15T12:21:28.692Z |
5032883 | 5032883 | 20240907015939_Sa2fM | CZ0008 | 2024-09-12T12:08:16.032Z | 2024-09-15T12:21:28.130Z |
5032871 | 5032871 | 20240907015758_yzjhd | CZ0008 | 2024-09-12T12:08:14.318Z | 2024-09-15T12:21:28.122Z |
5032868 | 5032868 | 20240907015755_5wKMp | CZ0008 | 2024-09-12T12:08:13.337Z | 2024-09-15T12:21:28.121Z |
5032063 | 5032063 | 20240907000450_8WYKF | CZ0008 | 2024-09-12T12:06:28.915Z | 2024-09-15T12:21:25.182Z |
5031966 | 5031966 | 20240906234743_gPm0J | CZ0008 | 2024-09-12T12:06:12.778Z | 2024-09-15T12:21:24.905Z |
5031840 | 5031840 | 20240906233110_poNkn | CZ0008 | 2024-09-12T12:05:54.824Z | 2024-09-15T12:21:24.410Z |
5031712 | 5031712 | 20240906230531_N9C3u | CZ0008 | 2024-09-12T12:05:31.789Z | 2024-09-15T12:21:23.930Z |
5031584 | 5031584 | 20240906223714_t3KwB | CZ0008 | 2024-09-12T12:05:13.454Z | 2024-09-15T12:21:23.274Z |
5031456 | 5031456 | 20240906220014_MOt7K | CZ0008 | 2024-09-12T12:04:54.759Z | 2024-09-15T12:21:22.526Z |
5025593 | 5025593 | 20240906022551_w4VYX | CZ0008 | 2024-09-11T12:06:54.845Z | 2024-09-11T12:16:32.708Z |
5025466 | 5025466 | 20240906020331_8glcQ | CZ0008 | 2024-09-11T12:06:39.999Z | 2024-09-11T12:16:32.643Z |
5025359 | 5025359 | 20240906015318_i5FYp | CZ0008 | 2024-09-11T12:06:20.599Z | 2024-09-14T12:23:04.106Z |
5025224 | 5025224 | 20240906012909_UuTuI | CZ0008 | 2024-09-11T12:06:02.077Z | 2024-09-14T12:23:03.541Z |
5024939 | 5024939 | 20240906001821_hAE22 | CZ0008 | 2024-09-11T12:05:17.414Z | 2024-09-11T12:16:32.393Z |
5010200 | 5010200 | 20240904024215_DpVKF | CZ0008 | 2024-09-09T12:08:27.288Z | 2024-09-12T12:19:26.324Z |
5009400 | 5009400 | 20240904011924_Jf7YI | CZ0008 | 2024-09-09T12:07:42.452Z | 2024-09-12T12:19:22.666Z |
5009397 | 5009397 | 20240904011904_J716o | CZ0008 | 2024-09-09T12:07:42.069Z | 2024-09-12T12:19:22.636Z |
5009202 | 5009202 | 20240904010320_a8MmO | CZ0008 | 2024-09-09T12:07:29.688Z | 2024-09-12T12:19:21.983Z |
5007616 | 5007616 | 20240903215137_3QDlu | CZ0008 | 2024-09-09T12:05:56.220Z | 2024-09-12T12:19:14.165Z |
5007522 | 5007522 | 20240903213301_UME6h | CZ0008 | 2024-09-09T12:05:51.851Z | 2024-09-12T12:19:13.648Z |
5007215 | 5007215 | 20240903202609_xW1rC | CZ0008 | 2024-09-09T12:05:36.267Z | 2024-09-12T12:19:12.116Z |
4998293 | 4998293 | 20240903024122_g0cgU | CZ0008 | 2024-09-08T12:07:28.096Z | 2024-09-11T12:21:11.937Z |
4998193 | 4998193 | 20240903022853_kFWIa | CZ0008 | 2024-09-08T12:07:22.391Z | 2024-09-11T12:21:11.411Z |
4998048 | 4998048 | 20240903020908_wDooE | CZ0008 | 2024-09-08T12:07:08.915Z | 2024-09-11T12:21:10.748Z |
4998040 | 4998040 | 20240903020846_cOIwA | CZ0008 | 2024-09-08T12:07:08.281Z | 2024-09-11T12:21:10.680Z |
4997980 | 4997980 | 20240903015856_BSMNC | CZ0008 | 2024-09-08T12:07:02.254Z | 2024-09-11T12:21:10.318Z |
4997924 | 4997924 | 20240903014557_ElDWV | CZ0008 | 2024-09-08T12:06:58.083Z | 2024-09-11T12:21:09.980Z |
4997922 | 4997922 | 20240903014543_HXmxB | CZ0008 | 2024-09-08T12:06:57.932Z | 2024-09-11T12:21:09.968Z |
4997889 | 4997889 | 20240903014143_eCO31 | CZ0008 | 2024-09-08T12:06:55.873Z | 2024-09-11T12:21:09.730Z |
4997766 | 4997766 | 20240903012707_uhdxA | CZ0008 | 2024-09-08T12:06:47.387Z | 2024-09-11T12:21:08.497Z |
4997651 | 4997651 | 20240903005639_U2FNl | CZ0008 | 2024-09-08T12:06:33.583Z | 2024-09-11T12:21:07.112Z |
4991573 | 4991573 | 20240901024838_oH8Tp | CZ0008 | 2024-09-07T12:12:12.904Z | 2024-09-09T12:27:12.944Z |
4991564 | 4991564 | 20240901024806_GaHIF | CZ0008 | 2024-09-07T12:12:11.171Z | 2024-09-09T12:27:12.813Z |
4991381 | 4991381 | 20240901022733_xAVI5 | CZ0008 | 2024-09-07T12:11:59.572Z | 2024-09-09T12:27:06.825Z |
4991337 | 4991337 | 20240901022154_3RIMR | CZ0008 | 2024-09-07T12:11:57.197Z | 2024-09-09T12:27:05.688Z |
4991315 | 4991315 | 20240901021849_SYnoD | CZ0008 | 2024-09-07T12:11:54.459Z | 2024-09-09T12:27:05.109Z |
4991175 | 4991175 | 20240901020533_m3nuj | CZ0008 | 2024-09-07T12:11:40.697Z | 2024-09-09T12:27:01.943Z |
4991152 | 4991152 | 20240901020310_8eilS | CZ0008 | 2024-09-07T12:11:37.240Z | 2024-09-09T12:27:01.263Z |
4991144 | 4991144 | 20240901020159_Y5nRZ | CZ0008 | 2024-09-07T12:11:36.557Z | 2024-09-09T12:27:01.037Z |
4990982 | 4990982 | 20240901014113_ldcnc | CZ0008 | 2024-09-07T12:11:24.842Z | 2024-09-09T12:26:56.883Z |
4990740 | 4990740 | 20240901010343_Spdvq | CZ0008 | 2024-09-07T12:11:00.416Z | 2024-09-09T12:26:35.287Z |
4990725 | 4990725 | 20240901010128_02c71 | CZ0008 | 2024-09-07T12:10:59.334Z | 2024-09-09T12:26:33.938Z |
4990550 | 4990550 | 20240901003300_DjYUk | CZ0008 | 2024-09-07T12:10:45.961Z | 2024-09-09T12:26:23.206Z |
4990538 | 4990538 | 20240901002940_XJoHA | CZ0008 | 2024-09-07T12:10:44.748Z | 2024-09-09T12:26:22.985Z |
4990133 | 4990133 | 20240831233150_YFu4D | CZ0008 | 2024-09-07T12:10:06.190Z | 2024-09-09T12:26:11.520Z |
4990065 | 4990065 | 20240831231925_730vs | CZ0008 | 2024-09-07T12:09:58.453Z | 2024-09-09T12:26:09.871Z |
4989987 | 4989987 | 20240831231123_cHlG2 | CZ0008 | 2024-09-07T12:09:53.524Z | 2024-09-09T12:26:08.130Z |
4989871 | 4989871 | 20240831225025_xuWPE | CZ0008 | 2024-09-07T12:09:44.724Z | 2024-09-09T12:26:02.743Z |
4989855 | 4989855 | 20240831224713_31p0G | CZ0008 | 2024-09-07T12:09:43.445Z | 2024-09-09T12:26:01.331Z |
4989822 | 4989822 | 20240831224013_LLng2 | CZ0008 | 2024-09-07T12:09:37.680Z | 2024-09-09T12:25:54.274Z |
4989739 | 4989739 | 20240831222101_3VU3n | CZ0008 | 2024-09-07T12:09:26.923Z | 2024-09-09T12:25:43.374Z |
4982027 | 4982027 | 20240812002923_dYLTU | CZ0008 | 2024-09-06T12:14:41.695Z | 2024-09-06T12:14:41.695Z |
4981788 | 4981788 | 20240812002729_COJrY | CZ0008 | 2024-09-06T12:14:37.851Z | 2024-09-06T12:14:37.851Z |
4980969 | 4980969 | 20240812001756_yL8It | CZ0008 | 2024-09-06T12:14:25.165Z | 2024-09-06T12:14:25.165Z |
4980851 | 4980851 | 20240812001634_Kf632 | CZ0008 | 2024-09-06T12:14:20.747Z | 2024-09-06T12:14:20.747Z |
4980420 | 4980420 | 20240812001217_wnyaw | CZ0008 | 2024-09-06T12:14:00.035Z | 2024-09-06T12:14:00.035Z |
4980406 | 4980406 | 20240812001201_E4cmz | CZ0008 | 2024-09-06T12:13:58.905Z | 2024-09-06T12:13:58.905Z |
4979403 | 4979403 | 20240812000150_vJpiB | CZ0008 | 2024-09-06T12:13:14.473Z | 2024-09-06T12:13:14.473Z |
4979057 | 4979057 | 20240811235852_xAiWW | CZ0008 | 2024-09-06T12:12:54.976Z | 2024-09-06T12:12:54.976Z |
4978428 | 4978428 | 20240811235043_AYU2A | CZ0008 | 2024-09-06T12:12:33.583Z | 2024-09-06T12:12:33.583Z |
4978286 | 4978286 | 20240811234922_gkqFU | CZ0008 | 2024-09-06T12:12:31.803Z | 2024-09-06T12:12:31.803Z |
4978036 | 4978036 | 20240811234722_sR8Oq | CZ0008 | 2024-09-06T12:12:28.141Z | 2024-09-06T12:12:28.141Z |
4977890 | 4977890 | 20240811234556_XlJHa | CZ0008 | 2024-09-06T12:12:26.037Z | 2024-09-06T12:12:26.037Z |
4977840 | 4977840 | 20240811234508_lt7qX | CZ0008 | 2024-09-06T12:12:23.993Z | 2024-09-06T12:12:23.993Z |
4977164 | 4977164 | 20240811233646_CVwAt | CZ0008 | 2024-09-06T12:12:05.906Z | 2024-09-06T12:12:05.906Z |
4976531 | 4976531 | 20240811233128_Ezn3r | CZ0008 | 2024-09-06T12:11:35.925Z | 2024-09-06T12:11:35.925Z |
4976362 | 4976362 | 20240811232914_BbEP2 | CZ0008 | 2024-09-06T12:11:27.048Z | 2024-09-06T12:11:27.048Z |
4976014 | 4976014 | 20240811232450_XcVny | CZ0008 | 2024-09-06T12:11:02.181Z | 2024-09-06T12:11:02.181Z |
4975961 | 4975961 | 20240811232403_v5xU5 | CZ0008 | 2024-09-06T12:10:59.356Z | 2024-09-06T12:10:59.356Z |
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);