participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
8,122 rows where station_code = "FR000X" 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 |
---|---|---|---|---|---|
5129272 | 5129272 | 20240917034447_B8XFi | FR000X | 2024-09-19T12:11:25.328Z | 2024-09-19T12:11:25.328Z |
5129174 | 5129174 | 20240917033228_lMv5G | FR000X | 2024-09-19T12:11:20.160Z | 2024-09-19T12:11:20.160Z |
5129094 | 5129094 | 20240917031724_uqGBl | FR000X | 2024-09-19T12:11:15.368Z | 2024-09-19T12:11:15.368Z |
5128784 | 5128784 | 20240917023533_BH8UM | FR000X | 2024-09-19T12:11:01.467Z | 2024-09-19T12:11:01.467Z |
5127647 | 5127647 | 20240916224408_8EedS | FR000X | 2024-09-19T12:09:28.493Z | 2024-09-19T12:09:28.493Z |
5127200 | 5127200 | 20240916205450_E8rqh | FR000X | 2024-09-19T12:08:31.693Z | 2024-09-19T12:08:31.693Z |
5127168 | 5127168 | 20240916204047_Nvekl | FR000X | 2024-09-19T12:08:23.824Z | 2024-09-19T12:08:23.824Z |
5127158 | 5127158 | 20240916203434_vsR8C | FR000X | 2024-09-19T12:08:20.220Z | 2024-09-19T12:08:20.220Z |
5127050 | 5127050 | 20240916201656_ufAEx | FR000X | 2024-09-19T12:07:58.171Z | 2024-09-19T12:07:58.171Z |
5125697 | 5125697 | 20240918032137_XiIto | FR000X | 2024-09-19T12:03:54.156Z | 2024-09-19T12:06:42.071Z |
5125523 | 5125523 | 20240918025318_86aXa | FR000X | 2024-09-19T12:03:26.774Z | 2024-09-19T12:06:42.047Z |
5125509 | 5125509 | 20240918025137_GitIx | FR000X | 2024-09-19T12:03:24.601Z | 2024-09-19T12:06:42.044Z |
5125383 | 5125383 | 20240918022400_VYd7T | FR000X | 2024-09-19T12:03:07.787Z | 2024-09-19T12:06:42.024Z |
5125187 | 5125187 | 20240918010236_CSdDQ | FR000X | 2024-09-19T12:02:28.256Z | 2024-09-19T12:06:41.989Z |
5125155 | 5125155 | 20240918003333_OmqOT | FR000X | 2024-09-19T12:02:24.484Z | 2024-09-19T12:06:41.983Z |
5125022 | 5125022 | 20240917233305_5PT2n | FR000X | 2024-09-19T12:01:57.129Z | 2024-09-19T12:06:41.962Z |
5124567 | 5124567 | 20240917211216_iu1KA | FR000X | 2024-09-19T12:01:08.825Z | 2024-09-19T12:06:41.911Z |
5124343 | 5124343 | 20240917193835_pptQf | FR000X | 2024-09-19T12:00:36.929Z | 2024-09-19T12:06:41.880Z |
5121799 | 5121799 | 20240914041441_9rVaE | FR000X | 2024-09-18T12:11:01.423Z | 2024-09-19T12:20:02.370Z |
5121792 | 5121792 | 20240914041439_BclDK | FR000X | 2024-09-18T12:11:01.417Z | 2024-09-19T12:20:02.369Z |
5121432 | 5121432 | 20240914040121_2NFIY | FR000X | 2024-09-18T12:10:55.370Z | 2024-09-19T12:20:01.838Z |
5121311 | 5121311 | 20240914035814_hGiG0 | FR000X | 2024-09-18T12:10:54.491Z | 2024-09-19T12:20:01.621Z |
5121251 | 5121251 | 20240914035636_uiFn9 | FR000X | 2024-09-18T12:10:52.992Z | 2024-09-19T12:20:01.531Z |
5120882 | 5120882 | 20240914034021_0GOMo | FR000X | 2024-09-18T12:10:48.389Z | 2024-09-19T12:20:00.995Z |
5120680 | 5120680 | 20240914033202_fH3lk | FR000X | 2024-09-18T12:10:45.912Z | 2024-09-19T12:20:00.725Z |
5120557 | 5120557 | 20240914032801_Gq8pV | FR000X | 2024-09-18T12:10:43.124Z | 2024-09-19T12:20:00.565Z |
5120059 | 5120059 | 20240914025821_3O2iZ | FR000X | 2024-09-18T12:10:31.620Z | 2024-09-19T12:19:59.363Z |
5119958 | 5119958 | 20240914025447_y4ee4 | FR000X | 2024-09-18T12:10:29.962Z | 2024-09-19T12:19:59.194Z |
5119759 | 5119759 | 20240914024809_4lyde | FR000X | 2024-09-18T12:10:25.871Z | 2024-09-19T12:19:58.884Z |
5119650 | 5119650 | 20240914024200_FDIBL | FR000X | 2024-09-18T12:10:22.886Z | 2024-09-19T12:19:58.645Z |
5108127 | 5108127 | 20240913042402_vatQw | FR000X | 2024-09-17T12:13:30.830Z | 2024-09-19T12:20:47.856Z |
5107870 | 5107870 | 20240913041242_H8xeN | FR000X | 2024-09-17T12:13:25.244Z | 2024-09-19T12:20:47.612Z |
5107818 | 5107818 | 20240913041144_1s6ON | FR000X | 2024-09-17T12:13:24.220Z | 2024-09-19T12:20:47.577Z |
5107814 | 5107814 | 20240913041111_ppxsb | FR000X | 2024-09-17T12:13:24.052Z | 2024-09-19T12:20:47.566Z |
5106805 | 5106805 | 20240913033538_U5EMJ | FR000X | 2024-09-17T12:13:02.037Z | 2024-09-19T12:20:46.442Z |
5106794 | 5106794 | 20240913033452_SNw2J | FR000X | 2024-09-17T12:13:01.528Z | 2024-09-19T12:20:46.424Z |
5105887 | 5105887 | 20240913030157_6ggA8 | FR000X | 2024-09-17T12:12:31.548Z | 2024-09-19T12:20:45.019Z |
5105517 | 5105517 | 20240913025013_miGgc | FR000X | 2024-09-17T12:12:20.130Z | 2024-09-19T12:20:44.640Z |
5104944 | 5104944 | 20240913022446_Dmclr | FR000X | 2024-09-17T12:11:47.351Z | 2024-09-19T12:20:43.130Z |
5104905 | 5104905 | 20240913022346_wH8wQ | FR000X | 2024-09-17T12:11:46.470Z | 2024-09-19T12:20:43.109Z |
5104478 | 5104478 | 20240913021049_dMpWi | FR000X | 2024-09-17T12:11:36.325Z | 2024-09-19T12:20:41.513Z |
5104330 | 5104330 | 20240913020517_GnkGQ | FR000X | 2024-09-17T12:11:33.296Z | 2024-09-19T12:20:41.365Z |
5104321 | 5104321 | 20240913020440_RxTrX | FR000X | 2024-09-17T12:11:33.003Z | 2024-09-19T12:20:41.359Z |
5104267 | 5104267 | 20240913020150_hqqhZ | FR000X | 2024-09-17T12:11:31.377Z | 2024-09-19T12:20:41.306Z |
5104137 | 5104137 | 20240913015416_MoVMN | FR000X | 2024-09-17T12:11:26.761Z | 2024-09-19T12:20:41.118Z |
5103923 | 5103923 | 20240913014410_zSz3m | FR000X | 2024-09-17T12:11:17.608Z | 2024-09-19T12:20:40.673Z |
5103804 | 5103804 | 20240913014047_z3EeP | FR000X | 2024-09-17T12:11:11.587Z | 2024-09-19T12:20:40.580Z |
5102836 | 5102836 | 20240914014853_hZZaJ | FR000X | 2024-09-17T12:07:39.243Z | 2024-09-19T12:19:55.858Z |
5102357 | 5102357 | 20240914012147_mYCQK | FR000X | 2024-09-17T12:07:04.446Z | 2024-09-19T12:19:53.881Z |
5102308 | 5102308 | 20240914011715_phYkN | FR000X | 2024-09-17T12:06:59.603Z | 2024-09-19T12:19:53.399Z |
5102267 | 5102267 | 20240914011348_ekvUo | FR000X | 2024-09-17T12:06:56.602Z | 2024-09-19T12:19:53.129Z |
5102219 | 5102219 | 20240914011225_Ry2D1 | FR000X | 2024-09-17T12:06:55.028Z | 2024-09-19T12:19:52.885Z |
5102068 | 5102068 | 20240914010421_OxR74 | FR000X | 2024-09-17T12:06:45.796Z | 2024-09-19T12:19:52.356Z |
5102028 | 5102028 | 20240914010040_n1GER | FR000X | 2024-09-17T12:06:42.559Z | 2024-09-19T12:19:52.256Z |
5101965 | 5101965 | 20240914005716_zfFYs | FR000X | 2024-09-17T12:06:29.362Z | 2024-09-19T12:19:51.938Z |
5101860 | 5101860 | 20240914005212_unbNv | FR000X | 2024-09-17T12:06:18.352Z | 2024-09-19T12:19:51.716Z |
5101704 | 5101704 | 20240914004340_8M1TP | FR000X | 2024-09-17T12:06:09.652Z | 2024-09-19T12:19:51.305Z |
5101671 | 5101671 | 20240914004217_hAmUV | FR000X | 2024-09-17T12:06:07.927Z | 2024-09-19T12:19:51.198Z |
5101634 | 5101634 | 20240914004004_eHZv4 | FR000X | 2024-09-17T12:06:05.686Z | 2024-09-19T12:19:51.134Z |
5101588 | 5101588 | 20240914003638_pZAg8 | FR000X | 2024-09-17T12:06:03.160Z | 2024-09-19T12:19:51.008Z |
5101534 | 5101534 | 20240914003341_2MjRV | FR000X | 2024-09-17T12:05:59.455Z | 2024-09-19T12:19:50.865Z |
5101495 | 5101495 | 20240914003022_meuOX | FR000X | 2024-09-17T12:05:56.115Z | 2024-09-19T12:19:50.754Z |
5101288 | 5101288 | 20240914001741_7ItUQ | FR000X | 2024-09-17T12:05:31.755Z | 2024-09-19T12:19:50.175Z |
5101184 | 5101184 | 20240914000956_6lYM3 | FR000X | 2024-09-17T12:05:25.043Z | 2024-09-19T12:19:49.998Z |
5100889 | 5100889 | 20240913235141_e3h27 | FR000X | 2024-09-17T12:05:08.041Z | 2024-09-19T12:19:49.262Z |
5100578 | 5100578 | 20240913233120_BMkna | FR000X | 2024-09-17T12:04:39.581Z | 2024-09-19T12:19:48.144Z |
5100349 | 5100349 | 20240913232303_5fNx8 | FR000X | 2024-09-17T12:04:29.513Z | 2024-09-19T12:19:47.827Z |
5100219 | 5100219 | 20240913230601_qlKDs | FR000X | 2024-09-17T12:04:18.927Z | 2024-09-19T12:19:47.283Z |
5100209 | 5100209 | 20240913230536_E7QmG | FR000X | 2024-09-17T12:04:17.213Z | 2024-09-19T12:19:47.275Z |
5100201 | 5100201 | 20240913230313_eke4d | FR000X | 2024-09-17T12:04:13.282Z | 2024-09-19T12:19:47.221Z |
5100069 | 5100069 | 20240913224611_5xHJx | FR000X | 2024-09-17T12:03:56.028Z | 2024-09-19T12:19:46.824Z |
5100048 | 5100048 | 20240913224413_6yeak | FR000X | 2024-09-17T12:03:53.842Z | 2024-09-19T12:19:46.781Z |
5100022 | 5100022 | 20240913224058_rWmEb | FR000X | 2024-09-17T12:03:51.998Z | 2024-09-19T12:19:46.748Z |
5099954 | 5099954 | 20240913222649_k2b19 | FR000X | 2024-09-17T12:03:45.716Z | 2024-09-19T12:19:46.585Z |
5099942 | 5099942 | 20240913222517_jED5j | FR000X | 2024-09-17T12:03:44.612Z | 2024-09-19T12:19:46.561Z |
5099875 | 5099875 | 20240913221919_M4GW2 | FR000X | 2024-09-17T12:03:41.608Z | 2024-09-19T12:19:46.256Z |
5099853 | 5099853 | 20240913221130_Laxhg | FR000X | 2024-09-17T12:03:39.510Z | 2024-09-19T12:19:46.171Z |
5099671 | 5099671 | 20240913214736_C3oKS | FR000X | 2024-09-17T12:03:22.094Z | 2024-09-19T12:19:45.665Z |
5099379 | 5099379 | 20240913210610_zRsqd | FR000X | 2024-09-17T12:02:50.111Z | 2024-09-19T12:19:44.663Z |
5098801 | 5098801 | 20240913193513_sC6gi | FR000X | 2024-09-17T12:01:38.397Z | 2024-09-19T12:19:41.169Z |
5098694 | 5098694 | 20240913190057_qyvjL | FR000X | 2024-09-17T12:01:22.283Z | 2024-09-19T12:19:40.197Z |
5097975 | 5097975 | 20240913011051_C8gv3 | FR000X | 2024-09-16T12:17:17.663Z | 2024-09-19T12:20:39.234Z |
5097539 | 5097539 | 20240913005319_nJ3uE | FR000X | 2024-09-16T12:17:13.311Z | 2024-09-19T12:20:38.700Z |
5097232 | 5097232 | 20240913003803_w8iHl | FR000X | 2024-09-16T12:17:08.893Z | 2024-09-19T12:20:37.967Z |
5094589 | 5094589 | 20240912041157_2X2bT | FR000X | 2024-09-16T12:14:52.001Z | 2024-09-19T12:21:16.267Z |
5094141 | 5094141 | 20240912035120_0NEPM | FR000X | 2024-09-16T12:14:36.941Z | 2024-09-19T12:21:15.901Z |
5093975 | 5093975 | 20240912034320_K32CS | FR000X | 2024-09-16T12:14:29.488Z | 2024-09-19T12:21:15.795Z |
5093690 | 5093690 | 20240912033246_aBWkS | FR000X | 2024-09-16T12:14:24.012Z | 2024-09-19T12:21:15.591Z |
5093655 | 5093655 | 20240912033153_YHG3P | FR000X | 2024-09-16T12:14:23.526Z | 2024-09-19T12:21:15.579Z |
5093140 | 5093140 | 20240912031237_zLpso | FR000X | 2024-09-16T12:14:12.088Z | 2024-09-19T12:21:14.968Z |
5092878 | 5092878 | 20240912030034_A7Hjp | FR000X | 2024-09-16T12:14:05.862Z | 2024-09-19T12:21:14.627Z |
5092673 | 5092673 | 20240912025423_x7REX | FR000X | 2024-09-16T12:14:01.918Z | 2024-09-19T12:21:14.406Z |
5092535 | 5092535 | 20240912024916_7LFMZ | FR000X | 2024-09-16T12:13:59.052Z | 2024-09-19T12:21:14.297Z |
5092473 | 5092473 | 20240912024711_Z6cC2 | FR000X | 2024-09-16T12:13:57.870Z | 2024-09-19T12:21:14.271Z |
5092087 | 5092087 | 20240912023629_85cp9 | FR000X | 2024-09-16T12:13:40.197Z | 2024-09-19T12:21:13.625Z |
5091948 | 5091948 | 20240912023130_Zrn1s | FR000X | 2024-09-16T12:13:33.309Z | 2024-09-19T12:21:13.526Z |
5091346 | 5091346 | 20240912020544_iqtnc | FR000X | 2024-09-16T12:13:02.309Z | 2024-09-19T12:21:12.896Z |
5090920 | 5090920 | 20240912015054_7IZgU | FR000X | 2024-09-16T12:12:42.154Z | 2024-09-19T12:21:12.348Z |
5090917 | 5090917 | 20240912015043_cRyVf | FR000X | 2024-09-16T12:12:41.916Z | 2024-09-19T12:21:12.346Z |
5090765 | 5090765 | 20240912014504_jrXhu | FR000X | 2024-09-16T12:12:34.953Z | 2024-09-19T12:21:12.042Z |
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);