participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "FR0006" 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 |
---|---|---|---|---|---|
5572084 | 5572084 | 20241121013117_3uOoc | FR0006 | 2024-11-22T14:17:56.691Z | 2024-11-22T14:19:22.256Z |
5571285 | 5571285 | 20241120231306_BwYBm | FR0006 | 2024-11-22T14:16:48.077Z | 2024-11-22T14:19:22.091Z |
5570764 | 5570764 | 20241120205322_kB7fh | FR0006 | 2024-11-22T14:16:04.464Z | 2024-11-22T14:19:21.977Z |
5569799 | 5569799 | 20241120173339_FWLO3 | FR0006 | 2024-11-22T14:14:12.972Z | 2024-11-22T14:19:21.807Z |
5557491 | 5557491 | 20241120045047_1kVz2 | FR0006 | 2024-11-21T14:01:00.455Z | 2024-11-22T14:19:21.079Z |
5557441 | 5557441 | 20241120044541_ouK2a | FR0006 | 2024-11-21T14:00:51.314Z | 2024-11-22T14:19:21.070Z |
5557275 | 5557275 | 20241120043316_aikaD | FR0006 | 2024-11-21T14:00:20.533Z | 2024-11-22T14:19:21.045Z |
5489003 | 5489003 | 20241105173235_a3kVp | FR0006 | 2024-11-07T14:11:09.930Z | 2024-11-14T14:23:09.422Z |
5485264 | 5485264 | 20241105043255_TK11W | FR0006 | 2024-11-06T14:18:00.349Z | 2024-11-13T14:27:41.444Z |
5485233 | 5485233 | 20241105042654_B3abf | FR0006 | 2024-11-06T14:17:57.309Z | 2024-11-13T14:27:41.018Z |
5485208 | 5485208 | 20241105042242_kOXjS | FR0006 | 2024-11-06T14:17:54.241Z | 2024-11-13T14:27:40.987Z |
5485101 | 5485101 | 20241105040455_qopNO | FR0006 | 2024-11-06T14:17:45.978Z | 2024-11-13T14:27:40.746Z |
5485094 | 5485094 | 20241105040335_hu94m | FR0006 | 2024-11-06T14:17:44.757Z | 2024-11-13T14:27:40.706Z |
5485049 | 5485049 | 20241105035732_YTQmB | FR0006 | 2024-11-06T14:17:41.402Z | 2024-11-13T14:27:40.508Z |
5484990 | 5484990 | 20241105035144_HFhe8 | FR0006 | 2024-11-06T14:17:36.825Z | 2024-11-13T14:27:40.436Z |
5484677 | 5484677 | 20241105031909_HRkFc | FR0006 | 2024-11-06T14:17:09.402Z | 2024-11-13T14:27:39.305Z |
5484504 | 5484504 | 20241105025843_SSWPn | FR0006 | 2024-11-06T14:16:58.506Z | 2024-11-13T14:27:38.464Z |
5484457 | 5484457 | 20241105025334_MLO5I | FR0006 | 2024-11-06T14:16:55.986Z | 2024-11-13T14:27:38.109Z |
5484393 | 5484393 | 20241105024248_vj7Hl | FR0006 | 2024-11-06T14:16:52.386Z | 2024-11-13T14:27:37.836Z |
5484308 | 5484308 | 20241105023305_inETU | FR0006 | 2024-11-06T14:16:47.747Z | 2024-11-13T14:27:37.709Z |
5484263 | 5484263 | 20241105022819_vpNSJ | FR0006 | 2024-11-06T14:16:40.374Z | 2024-11-13T14:27:37.583Z |
5484204 | 5484204 | 20241105021959_nuK3V | FR0006 | 2024-11-06T14:16:31.757Z | 2024-11-13T14:27:37.526Z |
5484051 | 5484051 | 20241105020539_orDi2 | FR0006 | 2024-11-06T14:16:08.711Z | 2024-11-13T14:27:37.198Z |
5484041 | 5484041 | 20241105020438_7AtXT | FR0006 | 2024-11-06T14:16:08.108Z | 2024-11-13T14:27:37.188Z |
5483922 | 5483922 | 20241105014449_7uKqb | FR0006 | 2024-11-06T14:15:53.846Z | 2024-11-13T14:27:37.016Z |
5483640 | 5483640 | 20241105011425_lzJUY | FR0006 | 2024-11-06T14:15:33.197Z | 2024-11-13T14:27:36.541Z |
5483594 | 5483594 | 20241105010220_N5jAB | FR0006 | 2024-11-06T14:15:30.515Z | 2024-11-13T14:27:36.469Z |
5483390 | 5483390 | 20241105003514_CBh2I | FR0006 | 2024-11-06T14:15:10.162Z | 2024-11-13T14:27:36.173Z |
5483339 | 5483339 | 20241105002807_2Us32 | FR0006 | 2024-11-06T14:15:00.609Z | 2024-11-13T14:27:36.051Z |
5483337 | 5483337 | 20241105002754_0U4Mp | FR0006 | 2024-11-06T14:15:00.442Z | 2024-11-13T14:27:36.049Z |
5483284 | 5483284 | 20241105002314_sh36o | FR0006 | 2024-11-06T14:14:53.510Z | 2024-11-13T14:27:35.975Z |
5483279 | 5483279 | 20241105002241_TmSVO | FR0006 | 2024-11-06T14:14:52.307Z | 2024-11-13T14:27:35.961Z |
5483152 | 5483152 | 20241105000441_dML8h | FR0006 | 2024-11-06T14:14:42.683Z | 2024-11-13T14:27:35.782Z |
5478429 | 5478429 | 20241104040923_oAYwt | FR0006 | 2024-11-05T14:18:21.903Z | 2024-11-12T14:28:15.281Z |
5478296 | 5478296 | 20241104034849_wcvO2 | FR0006 | 2024-11-05T14:18:11.987Z | 2024-11-12T14:28:14.883Z |
5478223 | 5478223 | 20241104033919_Zghge | FR0006 | 2024-11-05T14:18:05.020Z | 2024-11-12T14:28:14.627Z |
5478209 | 5478209 | 20241104033629_Ysz2j | FR0006 | 2024-11-05T14:18:03.971Z | 2024-11-12T14:28:14.559Z |
5478129 | 5478129 | 20241104032421_wswmQ | FR0006 | 2024-11-05T14:17:58.323Z | 2024-11-12T14:28:14.415Z |
5478051 | 5478051 | 20241104031411_KZcyb | FR0006 | 2024-11-05T14:17:47.953Z | 2024-11-12T14:28:13.932Z |
5478020 | 5478020 | 20241104030907_v61nd | FR0006 | 2024-11-05T14:17:45.429Z | 2024-11-12T14:28:13.868Z |
5477890 | 5477890 | 20241104025124_r2JyJ | FR0006 | 2024-11-05T14:17:34.860Z | 2024-11-12T14:28:13.149Z |
5477809 | 5477809 | 20241104023909_7f4RE | FR0006 | 2024-11-05T14:17:26.586Z | 2024-11-12T14:28:13.021Z |
5477778 | 5477778 | 20241104023417_aowBx | FR0006 | 2024-11-05T14:17:24.386Z | 2024-11-12T14:28:12.875Z |
5477626 | 5477626 | 20241104021536_3jnUu | FR0006 | 2024-11-05T14:17:10.126Z | 2024-11-12T14:28:12.179Z |
5477433 | 5477433 | 20241104015109_XeLqx | FR0006 | 2024-11-05T14:16:53.139Z | 2024-11-12T14:28:11.742Z |
5477406 | 5477406 | 20241104014856_chlsH | FR0006 | 2024-11-05T14:16:50.511Z | 2024-11-12T14:28:11.240Z |
5477246 | 5477246 | 20241104012547_qqiWv | FR0006 | 2024-11-05T14:16:36.209Z | 2024-11-12T14:28:10.447Z |
5477197 | 5477197 | 20241104011808_FtEDF | FR0006 | 2024-11-05T14:16:30.737Z | 2024-11-12T14:28:09.995Z |
5477190 | 5477190 | 20241104011604_eVZZR | FR0006 | 2024-11-05T14:16:30.057Z | 2024-11-12T14:28:09.961Z |
5477155 | 5477155 | 20241104010909_CtRAp | FR0006 | 2024-11-05T14:16:27.768Z | 2024-11-12T14:28:09.875Z |
5476985 | 5476985 | 20241104004841_WHvED | FR0006 | 2024-11-05T14:16:15.872Z | 2024-11-12T14:28:07.980Z |
5476886 | 5476886 | 20241104003818_OsfM6 | FR0006 | 2024-11-05T14:16:10.298Z | 2024-11-12T14:28:07.836Z |
5476866 | 5476866 | 20241104003632_WVrW3 | FR0006 | 2024-11-05T14:16:08.749Z | 2024-11-12T14:28:07.768Z |
5476864 | 5476864 | 20241104003627_DNiQd | FR0006 | 2024-11-05T14:16:08.505Z | 2024-11-12T14:28:07.759Z |
5476641 | 5476641 | 20241103235837_paD9a | FR0006 | 2024-11-05T14:15:47.687Z | 2024-11-12T14:28:06.642Z |
5476539 | 5476539 | 20241103234105_EAgDT | FR0006 | 2024-11-05T14:15:35.611Z | 2024-11-12T14:28:06.448Z |
5476414 | 5476414 | 20241103232142_oVB3l | FR0006 | 2024-11-05T14:15:18.622Z | 2024-11-12T14:28:05.962Z |
5476327 | 5476327 | 20241103230913_XwrdO | FR0006 | 2024-11-05T14:15:04.710Z | 2024-11-12T14:28:05.509Z |
5476294 | 5476294 | 20241103230234_NrpMs | FR0006 | 2024-11-05T14:15:01.024Z | 2024-11-12T14:28:04.938Z |
5476286 | 5476286 | 20241103225835_kOR1J | FR0006 | 2024-11-05T14:15:00.091Z | 2024-11-12T14:28:04.911Z |
5476213 | 5476213 | 20241103224453_anKl7 | FR0006 | 2024-11-05T14:14:52.860Z | 2024-11-12T14:28:03.859Z |
5476191 | 5476191 | 20241103224032_nZ50k | FR0006 | 2024-11-05T14:14:50.718Z | 2024-11-12T14:28:03.723Z |
5476158 | 5476158 | 20241103223600_8KChw | FR0006 | 2024-11-05T14:14:49.041Z | 2024-11-12T14:28:03.436Z |
5476078 | 5476078 | 20241103221607_i8iSm | FR0006 | 2024-11-05T14:14:43.256Z | 2024-11-12T14:28:02.681Z |
5475982 | 5475982 | 20241103220357_ylFa2 | FR0006 | 2024-11-05T14:14:37.206Z | 2024-11-12T14:28:02.007Z |
5475950 | 5475950 | 20241103215938_NK17w | FR0006 | 2024-11-05T14:14:35.399Z | 2024-11-12T14:28:01.894Z |
5475933 | 5475933 | 20241103215552_GxHEb | FR0006 | 2024-11-05T14:14:34.328Z | 2024-11-12T14:28:01.839Z |
5475907 | 5475907 | 20241103214847_6Qla9 | FR0006 | 2024-11-05T14:14:33.012Z | 2024-11-12T14:28:01.793Z |
5475642 | 5475642 | 20241103205432_XPnGK | FR0006 | 2024-11-05T14:13:55.230Z | 2024-11-12T14:28:00.122Z |
5475639 | 5475639 | 20241103205413_kOuuc | FR0006 | 2024-11-05T14:13:55.192Z | 2024-11-12T14:28:00.119Z |
5475456 | 5475456 | 20241103200942_sLSC1 | FR0006 | 2024-11-05T14:13:41.274Z | 2024-11-12T14:27:58.648Z |
5475253 | 5475253 | 20241103193603_QYSPw | FR0006 | 2024-11-05T14:12:54.404Z | 2024-11-12T14:27:57.849Z |
5475155 | 5475155 | 20241103191946_Fvgti | FR0006 | 2024-11-05T14:12:37.435Z | 2024-11-12T14:27:57.372Z |
5474729 | 5474729 | 20241103180710_KReHS | FR0006 | 2024-11-05T14:11:45.394Z | 2024-11-12T14:27:54.068Z |
5441965 | 5441965 | 20241030001111_FiBPl | FR0006 | 2024-11-01T12:19:14.735Z | 2024-11-07T14:26:44.423Z |
5441437 | 5441437 | 20241029221536_VxxTL | FR0006 | 2024-11-01T12:18:35.869Z | 2024-11-07T14:26:42.094Z |
5441269 | 5441269 | 20241029212445_7CbxM | FR0006 | 2024-11-01T12:18:22.414Z | 2024-11-07T14:26:41.487Z |
5441224 | 5441224 | 20241029211250_oVxlr | FR0006 | 2024-11-01T12:18:19.445Z | 2024-11-07T14:26:41.286Z |
5433442 | 5433442 | 20241029195922_rIwv8 | FR0006 | 2024-10-31T12:22:15.931Z | 2024-11-07T14:26:39.604Z |
5433390 | 5433390 | 20241029193314_v5Eq3 | FR0006 | 2024-10-31T12:22:11.924Z | 2024-11-07T14:26:38.912Z |
5432838 | 5432838 | 20241029045233_ll2qP | FR0006 | 2024-10-31T12:21:36.400Z | 2024-11-06T14:27:28.905Z |
5432791 | 5432791 | 20241029044008_zjbqs | FR0006 | 2024-10-31T12:21:35.257Z | 2024-11-06T14:27:28.721Z |
5432637 | 5432637 | 20241029040632_3hm9N | FR0006 | 2024-10-31T12:21:29.517Z | 2024-11-06T14:27:28.260Z |
5432512 | 5432512 | 20241029034524_2GwGY | FR0006 | 2024-10-31T12:21:25.303Z | 2024-11-06T14:27:27.722Z |
5432415 | 5432415 | 20241029032946_c2X2j | FR0006 | 2024-10-31T12:21:21.736Z | 2024-11-06T14:27:26.983Z |
5432405 | 5432405 | 20241029032806_vs9kv | FR0006 | 2024-10-31T12:21:21.123Z | 2024-11-06T14:27:26.825Z |
5432345 | 5432345 | 20241029031726_IrAjP | FR0006 | 2024-10-31T12:21:18.540Z | 2024-11-06T14:27:26.738Z |
5432217 | 5432217 | 20241029025525_l1g9X | FR0006 | 2024-10-31T12:21:13.218Z | 2024-11-06T14:27:26.262Z |
5432118 | 5432118 | 20241029024409_nMrA2 | FR0006 | 2024-10-31T12:21:03.397Z | 2024-11-06T14:27:25.983Z |
5432087 | 5432087 | 20241029024113_h5ovA | FR0006 | 2024-10-31T12:21:02.072Z | 2024-11-06T14:27:25.954Z |
5432030 | 5432030 | 20241029023313_OPjG2 | FR0006 | 2024-10-31T12:20:56.996Z | 2024-11-06T14:27:25.709Z |
5431902 | 5431902 | 20241029021415_RJP1z | FR0006 | 2024-10-31T12:20:48.115Z | 2024-11-06T14:27:25.207Z |
5431853 | 5431853 | 20241029020558_13iDI | FR0006 | 2024-10-31T12:20:44.353Z | 2024-11-06T14:27:25.096Z |
5431739 | 5431739 | 20241029015256_uy0YN | FR0006 | 2024-10-31T12:20:35.482Z | 2024-11-06T14:27:24.645Z |
5431645 | 5431645 | 20241029014053_lHp4t | FR0006 | 2024-10-31T12:20:28.143Z | 2024-11-06T14:27:24.347Z |
5431492 | 5431492 | 20241029012023_bv3l3 | FR0006 | 2024-10-31T12:20:14.286Z | 2024-11-06T14:27:23.944Z |
5431426 | 5431426 | 20241029011005_P4hcM | FR0006 | 2024-10-31T12:20:07.858Z | 2024-11-06T14:27:23.713Z |
5431423 | 5431423 | 20241029010933_9Ye36 | FR0006 | 2024-10-31T12:20:07.368Z | 2024-11-06T14:27:23.596Z |
5431414 | 5431414 | 20241029010822_pbNJ0 | FR0006 | 2024-10-31T12:20:06.488Z | 2024-11-06T14:27:23.526Z |
5431182 | 5431182 | 20241029003956_fFEaE | FR0006 | 2024-10-31T12:19:44.053Z | 2024-11-06T14:27:22.928Z |
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);