participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,443 rows where station_code = "FR0012" 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 |
---|---|---|---|---|---|
5570995 | 5570995 | 20241120215229_3v53o | FR0012 | 2024-11-22T14:16:17.367Z | 2024-11-22T14:19:22.020Z |
5564787 | 5564787 | 20241120032634_qJ5Z2 | FR0012 | 2024-11-21T14:18:03.348Z | 2024-11-22T14:21:36.453Z |
5564783 | 5564783 | 20241120032558_vafkt | FR0012 | 2024-11-21T14:18:03.223Z | 2024-11-22T14:21:36.415Z |
5478683 | 5478683 | 20241104050645_YRgpI | FR0012 | 2024-11-05T14:18:41.632Z | 2024-11-12T14:28:16.560Z |
5478513 | 5478513 | 20241104042215_2USWK | FR0012 | 2024-11-05T14:18:27.018Z | 2024-11-12T14:28:15.751Z |
5478510 | 5478510 | 20241104042122_3Nif1 | FR0012 | 2024-11-05T14:18:26.818Z | 2024-11-12T14:28:15.742Z |
5478359 | 5478359 | 20241104035541_2HrbR | FR0012 | 2024-11-05T14:18:15.533Z | 2024-11-12T14:28:15.013Z |
5478279 | 5478279 | 20241104034544_Qn3p0 | FR0012 | 2024-11-05T14:18:08.810Z | 2024-11-12T14:28:14.784Z |
5478101 | 5478101 | 20241104032133_FD029 | FR0012 | 2024-11-05T14:17:55.853Z | 2024-11-12T14:28:14.208Z |
5477982 | 5477982 | 20241104030425_fpJP8 | FR0012 | 2024-11-05T14:17:42.495Z | 2024-11-12T14:28:13.703Z |
5477698 | 5477698 | 20241104022220_jCEw5 | FR0012 | 2024-11-05T14:17:15.706Z | 2024-11-12T14:28:12.457Z |
5477660 | 5477660 | 20241104021759_2x6uM | FR0012 | 2024-11-05T14:17:13.562Z | 2024-11-12T14:28:12.384Z |
5477330 | 5477330 | 20241104013824_qDNV0 | FR0012 | 2024-11-05T14:16:43.991Z | 2024-11-12T14:28:10.699Z |
5477307 | 5477307 | 20241104013438_UMB1S | FR0012 | 2024-11-05T14:16:42.057Z | 2024-11-12T14:28:10.549Z |
5477295 | 5477295 | 20241104013357_qCn6B | FR0012 | 2024-11-05T14:16:40.689Z | 2024-11-12T14:28:10.525Z |
5477153 | 5477153 | 20241104010856_KYJwe | FR0012 | 2024-11-05T14:16:27.629Z | 2024-11-12T14:28:09.874Z |
5477116 | 5477116 | 20241104010254_a03EN | FR0012 | 2024-11-05T14:16:24.058Z | 2024-11-12T14:28:09.718Z |
5477003 | 5477003 | 20241104005055_yUbhx | FR0012 | 2024-11-05T14:16:16.718Z | 2024-11-12T14:28:08.058Z |
5476858 | 5476858 | 20241104003556_0Nn38 | FR0012 | 2024-11-05T14:16:08.162Z | 2024-11-12T14:28:07.734Z |
5476800 | 5476800 | 20241104002357_KUKEZ | FR0012 | 2024-11-05T14:16:05.319Z | 2024-11-12T14:28:07.441Z |
5476125 | 5476125 | 20241103223020_nbkoj | FR0012 | 2024-11-05T14:14:46.853Z | 2024-11-12T14:28:03.093Z |
5476056 | 5476056 | 20241103221351_zoVK2 | FR0012 | 2024-11-05T14:14:41.833Z | 2024-11-12T14:28:02.515Z |
5475970 | 5475970 | 20241103220245_Ot4Os | FR0012 | 2024-11-05T14:14:36.454Z | 2024-11-12T14:28:01.936Z |
5475810 | 5475810 | 20241103212925_8SQu4 | FR0012 | 2024-11-05T14:14:14.939Z | 2024-11-12T14:28:01.117Z |
5475595 | 5475595 | 20241103204701_N7u9C | FR0012 | 2024-11-05T14:13:51.857Z | 2024-11-12T14:28:00.048Z |
5475522 | 5475522 | 20241103202327_VFCqR | FR0012 | 2024-11-05T14:13:45.730Z | 2024-11-12T14:27:59.581Z |
5475351 | 5475351 | 20241103195215_K7e0w | FR0012 | 2024-11-05T14:13:17.139Z | 2024-11-12T14:27:57.999Z |
5475251 | 5475251 | 20241103193522_yWJrW | FR0012 | 2024-11-05T14:12:53.969Z | 2024-11-12T14:27:57.845Z |
5475177 | 5475177 | 20241103192321_i0uKG | FR0012 | 2024-11-05T14:12:39.143Z | 2024-11-12T14:27:57.443Z |
5474655 | 5474655 | 20241103175459_bK35E | FR0012 | 2024-11-05T14:11:30.192Z | 2024-11-12T14:27:53.754Z |
5454719 | 5454719 | 20241031050033_GXEK5 | FR0012 | 2024-11-02T12:23:18.643Z | 2024-11-08T14:23:24.861Z |
5454515 | 5454515 | 20241031043303_Zvvn7 | FR0012 | 2024-11-02T12:23:09.384Z | 2024-11-08T14:23:23.445Z |
5454053 | 5454053 | 20241031033636_DOiIL | FR0012 | 2024-11-02T12:22:49.716Z | 2024-11-08T14:23:20.127Z |
5443661 | 5443661 | 20241031000105_N2S9A | FR0012 | 2024-11-01T12:20:45.176Z | 2024-11-08T14:23:11.952Z |
5443523 | 5443523 | 20241030233520_Euf70 | FR0012 | 2024-11-01T12:20:37.034Z | 2024-11-08T14:23:11.537Z |
5440493 | 5440493 | 20241030222003_vVS61 | FR0012 | 2024-11-01T12:15:33.259Z | 2024-11-08T14:23:09.598Z |
5440236 | 5440236 | 20241030214530_zFqew | FR0012 | 2024-11-01T12:15:03.788Z | 2024-11-08T14:23:08.108Z |
5440128 | 5440128 | 20241030212535_8d1N7 | FR0012 | 2024-11-01T12:14:53.365Z | 2024-11-08T14:23:07.558Z |
5439748 | 5439748 | 20241030202653_ByXdP | FR0012 | 2024-11-01T12:14:23.888Z | 2024-11-08T14:23:05.494Z |
5439490 | 5439490 | 20241030195948_KiaP3 | FR0012 | 2024-11-01T12:13:53.763Z | 2024-11-08T14:23:03.551Z |
5439058 | 5439058 | 20241030185042_BeASZ | FR0012 | 2024-11-01T12:13:03.468Z | 2024-11-08T14:23:02.085Z |
5429057 | 5429057 | 20241028184053_o7uqb | FR0012 | 2024-10-31T12:15:55.942Z | 2024-11-06T14:27:14.958Z |
5419567 | 5419567 | 20241028001844_jnJrp | FR0012 | 2024-10-30T12:17:33.509Z | 2024-11-05T14:27:13.415Z |
5401851 | 5401851 | 20241026174806_0UJ02 | FR0012 | 2024-10-29T12:05:32.606Z | 2024-11-04T14:28:40.291Z |
5399973 | 5399973 | 20241026051835_XRKRR | FR0012 | 2024-10-28T12:20:17.793Z | 2024-11-03T14:27:40.926Z |
5399955 | 5399955 | 20241026051604_M5LGs | FR0012 | 2024-10-28T12:20:17.480Z | 2024-11-03T14:27:40.891Z |
5399915 | 5399915 | 20241026051211_2Quql | FR0012 | 2024-10-28T12:20:16.666Z | 2024-11-03T14:27:40.803Z |
5399906 | 5399906 | 20241026051116_oxaMT | FR0012 | 2024-10-28T12:20:15.797Z | 2024-11-03T14:27:40.709Z |
5399896 | 5399896 | 20241026051056_BzVOX | FR0012 | 2024-10-28T12:20:15.781Z | 2024-11-03T14:27:40.703Z |
5399842 | 5399842 | 20241026050614_1vucF | FR0012 | 2024-10-28T12:20:13.217Z | 2024-11-03T14:27:40.602Z |
5399746 | 5399746 | 20241026045908_9cAyX | FR0012 | 2024-10-28T12:20:09.808Z | 2024-11-03T14:27:40.411Z |
5399727 | 5399727 | 20241026045550_qwjQW | FR0012 | 2024-10-28T12:20:08.684Z | 2024-11-03T14:27:40.328Z |
5399661 | 5399661 | 20241026044612_ZnVMf | FR0012 | 2024-10-28T12:20:05.074Z | 2024-11-03T14:27:40.181Z |
5399398 | 5399398 | 20241026041503_zBNMk | FR0012 | 2024-10-28T12:19:57.947Z | 2024-11-03T14:27:39.600Z |
5399155 | 5399155 | 20241026035706_r7dDp | FR0012 | 2024-10-28T12:19:49.885Z | 2024-11-03T14:27:39.137Z |
5398975 | 5398975 | 20241026034254_gFyVO | FR0012 | 2024-10-28T12:19:43.179Z | 2024-11-03T14:27:38.798Z |
5398777 | 5398777 | 20241026032805_yJyYd | FR0012 | 2024-10-28T12:19:32.801Z | 2024-11-03T14:27:38.097Z |
5398154 | 5398154 | 20241026023031_oZKOt | FR0012 | 2024-10-28T12:19:03.086Z | 2024-11-03T14:27:35.593Z |
5398113 | 5398113 | 20241026022714_RmrUP | FR0012 | 2024-10-28T12:19:01.237Z | 2024-11-03T14:27:35.450Z |
5398090 | 5398090 | 20241026022533_Mnl9z | FR0012 | 2024-10-28T12:19:00.564Z | 2024-11-03T14:27:35.361Z |
5397932 | 5397932 | 20241026020745_clwPV | FR0012 | 2024-10-28T12:18:51.362Z | 2024-11-03T14:27:34.564Z |
5396973 | 5396973 | 20241026005209_fTPXh | FR0012 | 2024-10-28T12:18:01.305Z | 2024-11-03T14:27:31.599Z |
5396928 | 5396928 | 20241026004712_A13W4 | FR0012 | 2024-10-28T12:17:59.645Z | 2024-11-03T14:27:31.371Z |
5394916 | 5394916 | 20241025214315_iYFnu | FR0012 | 2024-10-28T12:15:41.947Z | 2024-11-03T14:27:23.439Z |
5394811 | 5394811 | 20241025212935_cCfFm | FR0012 | 2024-10-28T12:15:27.579Z | 2024-11-03T14:27:22.803Z |
5394728 | 5394728 | 20241025211622_Zn6rh | FR0012 | 2024-10-28T12:15:19.416Z | 2024-11-03T14:27:22.414Z |
5394638 | 5394638 | 20241025210041_mrmTh | FR0012 | 2024-10-28T12:15:08.095Z | 2024-11-03T14:27:21.938Z |
5394574 | 5394574 | 20241025205224_0Kcis | FR0012 | 2024-10-28T12:14:59.359Z | 2024-11-03T14:27:21.743Z |
5394200 | 5394200 | 20241025195157_p0bGE | FR0012 | 2024-10-28T12:14:10.240Z | 2024-11-03T14:27:20.275Z |
5393417 | 5393417 | 20241025173315_sfnHw | FR0012 | 2024-10-28T12:12:31.454Z | 2024-11-03T14:27:15.312Z |
5388425 | 5388425 | 20241025044921_7PXpv | FR0012 | 2024-10-27T12:22:13.499Z | 2024-11-02T12:28:34.158Z |
5388413 | 5388413 | 20241025044804_AJ68S | FR0012 | 2024-10-27T12:22:12.906Z | 2024-11-02T12:28:34.109Z |
5388381 | 5388381 | 20241025044233_efNMN | FR0012 | 2024-10-27T12:22:11.226Z | 2024-11-02T12:28:34.043Z |
5388304 | 5388304 | 20241025042820_58lRC | FR0012 | 2024-10-27T12:22:09.084Z | 2024-11-02T12:28:33.921Z |
5388295 | 5388295 | 20241025042708_Ix8HN | FR0012 | 2024-10-27T12:22:08.370Z | 2024-11-02T12:28:33.916Z |
5386968 | 5386968 | 20241025014512_pQ8eH | FR0012 | 2024-10-27T12:20:44.048Z | 2024-11-02T12:28:31.760Z |
5386645 | 5386645 | 20241025010825_2kMy7 | FR0012 | 2024-10-27T12:20:13.225Z | 2024-11-02T12:28:31.409Z |
5386574 | 5386574 | 20241025010312_gqURG | FR0012 | 2024-10-27T12:20:10.698Z | 2024-11-02T12:28:31.355Z |
5386368 | 5386368 | 20241025003027_NETi3 | FR0012 | 2024-10-27T12:20:01.867Z | 2024-11-02T12:28:31.121Z |
5386357 | 5386357 | 20241025002948_sPVe8 | FR0012 | 2024-10-27T12:20:01.290Z | 2024-11-02T12:28:31.110Z |
5386283 | 5386283 | 20241025002204_e4IvP | FR0012 | 2024-10-27T12:19:58.620Z | 2024-11-02T12:28:30.926Z |
5385931 | 5385931 | 20241024234453_H9inr | FR0012 | 2024-10-27T12:19:38.160Z | 2024-11-02T12:28:30.500Z |
5385702 | 5385702 | 20241024231956_375X3 | FR0012 | 2024-10-27T12:19:18.046Z | 2024-11-02T12:28:30.085Z |
5385458 | 5385458 | 20241024224929_mwkbc | FR0012 | 2024-10-27T12:18:57.935Z | 2024-11-02T12:28:29.849Z |
5385416 | 5385416 | 20241024224012_V52V3 | FR0012 | 2024-10-27T12:18:53.283Z | 2024-11-02T12:28:29.720Z |
5385124 | 5385124 | 20241024215504_zrT4L | FR0012 | 2024-10-27T12:18:26.304Z | 2024-11-02T12:28:29.162Z |
5384695 | 5384695 | 20241024203956_h389W | FR0012 | 2024-10-27T12:17:31.322Z | 2024-11-02T12:28:27.638Z |
5384693 | 5384693 | 20241024203921_2XkSl | FR0012 | 2024-10-27T12:17:29.802Z | 2024-11-02T12:28:27.629Z |
5383650 | 5383650 | 20241024184248_akdis | FR0012 | 2024-10-27T12:15:56.966Z | 2024-11-02T12:28:26.115Z |
5383640 | 5383640 | 20241024184144_ASHbs | FR0012 | 2024-10-27T12:15:55.185Z | 2024-11-02T12:28:26.105Z |
5377899 | 5377899 | 20241024051657_e7vQi | FR0012 | 2024-10-26T12:22:49.362Z | 2024-11-01T12:27:03.157Z |
5377490 | 5377490 | 20241024045410_qvXQA | FR0012 | 2024-10-26T12:22:38.679Z | 2024-11-01T12:27:02.459Z |
5377480 | 5377480 | 20241024045329_HlbH3 | FR0012 | 2024-10-26T12:22:38.186Z | 2024-11-01T12:27:02.453Z |
5377449 | 5377449 | 20241024045100_t3ZdS | FR0012 | 2024-10-26T12:22:37.393Z | 2024-11-01T12:27:02.442Z |
5377364 | 5377364 | 20241024044646_0Yn9O | FR0012 | 2024-10-26T12:22:34.852Z | 2024-11-01T12:27:02.389Z |
5377342 | 5377342 | 20241024044553_ZKQRI | FR0012 | 2024-10-26T12:22:34.626Z | 2024-11-01T12:27:02.384Z |
5377252 | 5377252 | 20241024044128_1OymX | FR0012 | 2024-10-26T12:22:31.947Z | 2024-11-01T12:27:02.337Z |
5377111 | 5377111 | 20241024043347_r0fRb | FR0012 | 2024-10-26T12:22:26.655Z | 2024-11-01T12:27:02.179Z |
5377083 | 5377083 | 20241024043210_Vzx0g | FR0012 | 2024-10-26T12:22:25.807Z | 2024-11-01T12:27:02.173Z |
5376825 | 5376825 | 20241024041830_z7l7h | FR0012 | 2024-10-26T12:22:14.239Z | 2024-11-01T12:27:01.878Z |
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);