participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,925 rows where station_code = "FR000G" 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 |
---|---|---|---|---|---|
4978450 | 4978450 | 20240811235058_EATQ0 | FR000G | 2024-09-06T12:12:34.209Z | 2024-09-06T12:12:34.209Z |
4978107 | 4978107 | 20240811234805_EnvL8 | FR000G | 2024-09-06T12:12:29.689Z | 2024-09-06T12:12:29.689Z |
4976539 | 4976539 | 20240811233130_3I4EA | FR000G | 2024-09-06T12:11:36.018Z | 2024-09-06T12:11:36.018Z |
4975243 | 4975243 | 20240811231615_SM7fj | FR000G | 2024-09-05T12:11:41.780Z | 2024-09-06T12:10:38.609Z |
4973220 | 4973220 | 20240811225454_Bmfrp | FR000G | 2024-09-05T12:10:44.580Z | 2024-09-06T12:09:48.954Z |
4972813 | 4972813 | 20240811225057_5xw3f | FR000G | 2024-09-05T12:10:35.357Z | 2024-09-06T12:09:30.205Z |
4972737 | 4972737 | 20240811224954_I5Vzw | FR000G | 2024-09-05T12:10:33.005Z | 2024-09-06T12:09:26.681Z |
4972197 | 4972197 | 20240811224401_nCODo | FR000G | 2024-09-05T12:10:19.107Z | 2024-09-06T12:09:06.322Z |
4971982 | 4971982 | 20240811224211_EfLUH | FR000G | 2024-09-05T12:10:11.746Z | 2024-09-06T12:09:03.327Z |
4971303 | 4971303 | 20240811223401_n8146 | FR000G | 2024-09-05T12:09:42.785Z | 2024-09-06T12:08:51.968Z |
4971025 | 4971025 | 20240811223116_qlMOZ | FR000G | 2024-09-05T12:09:36.159Z | 2024-09-06T12:08:47.996Z |
4970225 | 4970225 | 20240811222239_OA8Wb | FR000G | 2024-09-05T12:09:22.107Z | 2024-09-06T12:08:31.119Z |
4969238 | 4969238 | 20240811220822_zqdn6 | FR000G | 2024-09-05T12:08:38.191Z | 2024-09-06T12:07:46.098Z |
4954695 | 4954695 | 20240811030853_f9OLN | FR000G | 2024-09-03T12:18:19.246Z | 2024-09-06T12:29:06.886Z |
4954360 | 4954360 | 20240811025903_f6zML | FR000G | 2024-09-03T12:18:12.515Z | 2024-09-06T12:28:58.172Z |
4954329 | 4954329 | 20240811025735_3zbpW | FR000G | 2024-09-03T12:18:11.743Z | 2024-09-06T12:28:57.090Z |
4954195 | 4954195 | 20240811025412_7ZCr3 | FR000G | 2024-09-03T12:18:09.389Z | 2024-09-06T12:28:52.869Z |
4954058 | 4954058 | 20240811025022_VtMdA | FR000G | 2024-09-03T12:18:06.666Z | 2024-09-06T12:28:47.907Z |
4953613 | 4953613 | 20240811024157_jKw5D | FR000G | 2024-09-03T12:17:51.487Z | 2024-09-06T12:28:32.783Z |
4953498 | 4953498 | 20240811023933_89ZgP | FR000G | 2024-09-03T12:17:44.052Z | 2024-09-06T12:28:28.091Z |
4953461 | 4953461 | 20240811023849_M5jl4 | FR000G | 2024-09-03T12:17:42.200Z | 2024-09-06T12:28:27.189Z |
4953381 | 4953381 | 20240811023730_sZcJ3 | FR000G | 2024-09-03T12:17:38.842Z | 2024-09-06T12:28:25.256Z |
4952978 | 4952978 | 20240811023011_qaju6 | FR000G | 2024-09-03T12:17:10.717Z | 2024-09-06T12:28:13.968Z |
4952972 | 4952972 | 20240811022955_WT8Id | FR000G | 2024-09-03T12:17:10.596Z | 2024-09-06T12:28:13.936Z |
4952937 | 4952937 | 20240811022925_YiKLo | FR000G | 2024-09-03T12:17:09.832Z | 2024-09-06T12:28:13.176Z |
4952793 | 4952793 | 20240811022708_id22p | FR000G | 2024-09-03T12:17:05.829Z | 2024-09-06T12:28:09.546Z |
4952321 | 4952321 | 20240811021929_EMzxe | FR000G | 2024-09-03T12:16:54.994Z | 2024-09-06T12:27:56.326Z |
4952112 | 4952112 | 20240811021622_J3d7x | FR000G | 2024-09-03T12:16:48.169Z | 2024-09-06T12:27:52.815Z |
4950864 | 4950864 | 20240811021310_JD9wf | FR000G | 2024-09-02T12:16:38.009Z | 2024-09-06T12:27:50.705Z |
4950789 | 4950789 | 20240811021154_q28ZG | FR000G | 2024-09-02T12:16:36.047Z | 2024-09-06T12:27:49.834Z |
4950738 | 4950738 | 20240811021055_ADT5q | FR000G | 2024-09-02T12:16:34.708Z | 2024-09-06T12:27:47.492Z |
4950393 | 4950393 | 20240811020618_WK8A4 | FR000G | 2024-09-02T12:16:27.565Z | 2024-09-06T12:27:44.186Z |
4950264 | 4950264 | 20240811020421_dq9tl | FR000G | 2024-09-02T12:16:19.182Z | 2024-09-06T12:27:42.724Z |
4950244 | 4950244 | 20240811020344_hJcQD | FR000G | 2024-09-02T12:16:17.480Z | 2024-09-06T12:27:42.434Z |
4950171 | 4950171 | 20240811020207_mhZl3 | FR000G | 2024-09-02T12:16:10.818Z | 2024-09-06T12:27:41.514Z |
4949746 | 4949746 | 20240811015454_KDWG7 | FR000G | 2024-09-02T12:15:53.713Z | 2024-09-06T12:27:37.213Z |
4949495 | 4949495 | 20240811015056_7oyhg | FR000G | 2024-09-02T12:15:47.566Z | 2024-09-06T12:27:34.056Z |
4948983 | 4948983 | 20240811014338_eq24e | FR000G | 2024-09-02T12:15:28.039Z | 2024-09-06T12:27:28.748Z |
4948524 | 4948524 | 20240811013500_mdrRX | FR000G | 2024-09-02T12:15:03.717Z | 2024-09-06T12:27:18.505Z |
4948267 | 4948267 | 20240811013140_S0cby | FR000G | 2024-09-02T12:14:58.260Z | 2024-09-06T12:27:12.307Z |
4947765 | 4947765 | 20240811012404_30Dlf | FR000G | 2024-09-02T12:14:46.825Z | 2024-09-06T12:27:01.267Z |
4947574 | 4947574 | 20240811012057_R2IBj | FR000G | 2024-09-02T12:14:38.126Z | 2024-09-06T12:26:54.951Z |
4947229 | 4947229 | 20240811011505_Ovame | FR000G | 2024-09-02T12:14:20.343Z | 2024-09-06T12:26:47.427Z |
4946947 | 4946947 | 20240811011054_J1BAF | FR000G | 2024-09-02T12:14:12.542Z | 2024-09-06T12:26:41.052Z |
4946459 | 4946459 | 20240811010120_V5wsf | FR000G | 2024-09-02T12:13:55.638Z | 2024-09-06T12:26:23.205Z |
4946304 | 4946304 | 20240811005916_2lF4X | FR000G | 2024-09-02T12:13:47.680Z | 2024-09-06T12:26:20.293Z |
4946115 | 4946115 | 20240811005714_DATAS | FR000G | 2024-09-02T12:13:35.944Z | 2024-09-06T12:26:15.196Z |
4946082 | 4946082 | 20240811005622_J1f2p | FR000G | 2024-09-02T12:13:34.819Z | 2024-09-06T12:26:13.711Z |
4945909 | 4945909 | 20240811005335_49wLl | FR000G | 2024-09-02T12:13:28.240Z | 2024-09-06T12:26:08.780Z |
4945746 | 4945746 | 20240811005107_ZTRoR | FR000G | 2024-09-02T12:13:24.675Z | 2024-09-06T12:26:03.734Z |
4945578 | 4945578 | 20240811004814_aXN3K | FR000G | 2024-09-02T12:13:20.484Z | 2024-09-06T12:25:59.324Z |
4945517 | 4945517 | 20240811004717_6CtOx | FR000G | 2024-09-02T12:13:19.259Z | 2024-09-06T12:25:57.479Z |
4945353 | 4945353 | 20240811004447_sbqku | FR000G | 2024-09-02T12:13:15.761Z | 2024-09-06T12:25:53.878Z |
4945116 | 4945116 | 20240811004115_LdayK | FR000G | 2024-09-02T12:13:09.992Z | 2024-09-06T12:25:47.171Z |
4945017 | 4945017 | 20240811003944_daAH2 | FR000G | 2024-09-02T12:13:05.068Z | 2024-09-06T12:25:44.976Z |
4944748 | 4944748 | 20240811003517_dZJmx | FR000G | 2024-09-02T12:12:44.997Z | 2024-09-06T12:25:35.849Z |
4944093 | 4944093 | 20240811002243_AVt8A | FR000G | 2024-09-02T12:12:21.060Z | 2024-09-06T12:25:12.324Z |
4943880 | 4943880 | 20240811001844_m7tWl | FR000G | 2024-09-02T12:12:12.779Z | 2024-09-06T12:25:05.547Z |
4943856 | 4943856 | 20240811001812_RUffI | FR000G | 2024-09-02T12:12:11.351Z | 2024-09-06T12:25:04.757Z |
4943724 | 4943724 | 20240811001556_raMZy | FR000G | 2024-09-02T12:12:05.362Z | 2024-09-06T12:25:01.790Z |
4943615 | 4943615 | 20240811001440_B1L0g | FR000G | 2024-09-02T12:12:01.689Z | 2024-09-06T12:24:59.930Z |
4943491 | 4943491 | 20240811001255_0ctcM | FR000G | 2024-09-02T12:11:54.641Z | 2024-09-06T12:24:53.562Z |
4943414 | 4943414 | 20240811001121_hTRwx | FR000G | 2024-09-02T12:11:50.207Z | 2024-09-06T12:24:48.755Z |
4943141 | 4943141 | 20240811000644_XyZO5 | FR000G | 2024-09-02T12:11:43.122Z | 2024-09-06T12:24:39.485Z |
4942794 | 4942794 | 20240810235717_YFDBm | FR000G | 2024-09-02T12:11:33.612Z | 2024-09-06T12:24:30.274Z |
4942740 | 4942740 | 20240810235620_Zuy3A | FR000G | 2024-09-02T12:11:32.212Z | 2024-09-06T12:24:28.824Z |
4942413 | 4942413 | 20240810235149_DkeBp | FR000G | 2024-09-02T12:11:11.867Z | 2024-09-06T12:24:16.097Z |
4942409 | 4942409 | 20240810235143_g3RVg | FR000G | 2024-09-02T12:11:11.722Z | 2024-09-06T12:24:15.972Z |
4941219 | 4941219 | 20240810232906_I0ZQu | FR000G | 2024-09-02T12:10:22.874Z | 2024-09-06T12:23:45.141Z |
4941063 | 4941063 | 20240810232523_8QCF9 | FR000G | 2024-09-02T12:10:09.839Z | 2024-09-06T12:23:42.516Z |
4940881 | 4940881 | 20240810232052_g2Zin | FR000G | 2024-09-01T12:10:45.038Z | 2024-09-06T12:23:40.551Z |
4940278 | 4940278 | 20240810230854_oMuVX | FR000G | 2024-09-01T12:10:23.099Z | 2024-09-06T12:23:33.454Z |
4940245 | 4940245 | 20240810230758_Gm5lf | FR000G | 2024-09-01T12:10:21.827Z | 2024-09-06T12:23:32.874Z |
4940208 | 4940208 | 20240810230644_XtIJx | FR000G | 2024-09-01T12:10:20.497Z | 2024-09-06T12:23:32.313Z |
4940178 | 4940178 | 20240810230605_Eo9dh | FR000G | 2024-09-01T12:10:19.519Z | 2024-09-06T12:23:31.874Z |
4939867 | 4939867 | 20240810225905_j5krZ | FR000G | 2024-09-01T12:10:11.541Z | 2024-09-06T12:23:28.517Z |
4939741 | 4939741 | 20240810225455_rKOts | FR000G | 2024-09-01T12:10:04.954Z | 2024-09-06T12:23:26.757Z |
4939714 | 4939714 | 20240810225422_3IH3D | FR000G | 2024-09-01T12:10:03.324Z | 2024-09-06T12:23:26.293Z |
4939704 | 4939704 | 20240810225415_4QyIk | FR000G | 2024-09-01T12:10:03.064Z | 2024-09-06T12:23:26.237Z |
4939661 | 4939661 | 20240810225253_HN5C3 | FR000G | 2024-09-01T12:09:57.886Z | 2024-09-06T12:23:25.724Z |
4939591 | 4939591 | 20240810225053_uVuWx | FR000G | 2024-09-01T12:09:55.844Z | 2024-09-06T12:23:24.975Z |
4939583 | 4939583 | 20240810225048_XJEVI | FR000G | 2024-09-01T12:09:55.536Z | 2024-09-06T12:23:24.911Z |
4939535 | 4939535 | 20240810224927_Dm2Qv | FR000G | 2024-09-01T12:09:53.198Z | 2024-09-06T12:23:24.139Z |
4939315 | 4939315 | 20240810224240_BXA8q | FR000G | 2024-09-01T12:09:44.598Z | 2024-09-06T12:23:21.186Z |
4939223 | 4939223 | 20240810224100_93X2x | FR000G | 2024-09-01T12:09:41.787Z | 2024-09-06T12:23:18.829Z |
4939048 | 4939048 | 20240810223555_h3CjS | FR000G | 2024-09-01T12:09:35.575Z | 2024-09-06T12:23:11.799Z |
4938766 | 4938766 | 20240810222833_RFO1m | FR000G | 2024-09-01T12:09:20.065Z | 2024-09-06T12:23:02.687Z |
4938279 | 4938279 | 20240810221523_FGEvY | FR000G | 2024-09-01T12:09:02.207Z | 2024-09-06T12:22:48.920Z |
4938209 | 4938209 | 20240810221233_QYFah | FR000G | 2024-09-01T12:08:59.823Z | 2024-09-06T12:22:45.770Z |
4938010 | 4938010 | 20240810220845_xsFx6 | FR000G | 2024-09-01T12:08:48.667Z | 2024-09-06T12:22:40.468Z |
4937979 | 4937979 | 20240810220735_yzZFp | FR000G | 2024-09-01T12:08:47.167Z | 2024-09-06T12:22:39.246Z |
4937947 | 4937947 | 20240810220622_LEEe8 | FR000G | 2024-09-01T12:08:46.038Z | 2024-09-06T12:22:37.899Z |
4937866 | 4937866 | 20240810220328_5w3ec | FR000G | 2024-09-01T12:08:40.621Z | 2024-09-06T12:22:35.274Z |
4937453 | 4937453 | 20240810215024_jCiW6 | FR000G | 2024-09-01T12:08:17.396Z | 2024-09-06T12:22:15.706Z |
4937379 | 4937379 | 20240810214750_ilTla | FR000G | 2024-09-01T12:08:13.851Z | 2024-09-06T12:22:10.763Z |
4937283 | 4937283 | 20240810214511_HbUBa | FR000G | 2024-09-01T12:08:08.518Z | 2024-09-06T12:22:06.834Z |
4937067 | 4937067 | 20240810213846_V3zsv | FR000G | 2024-09-01T12:08:01.476Z | 2024-09-06T12:21:57.836Z |
4936832 | 4936832 | 20240810213220_pCGki | FR000G | 2024-09-01T12:07:47.962Z | 2024-09-06T12:21:48.332Z |
4936781 | 4936781 | 20240810213008_3i9hp | FR000G | 2024-09-01T12:07:46.088Z | 2024-09-06T12:21:46.415Z |
4936632 | 4936632 | 20240810212433_zRtKk | FR000G | 2024-09-01T12:07:38.763Z | 2024-09-06T12:21:42.414Z |
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);