participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "FR000Y" 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 |
|---|---|---|---|---|---|
| 9611696 | 9611696 | 20260405031553_TjdEb | FR000Y | 2026-04-06T12:15:46.476Z | 2026-04-06T12:16:14.850Z |
| 9611141 | 9611141 | 20260405003029_tYpMM | FR000Y | 2026-04-06T12:13:10.251Z | 2026-04-06T12:16:14.741Z |
| 9611134 | 9611134 | 20260405002813_f7hRs | FR000Y | 2026-04-06T12:13:09.098Z | 2026-04-06T12:16:14.740Z |
| 9611119 | 9611119 | 20260405002050_uftEj | FR000Y | 2026-04-06T12:13:03.192Z | 2026-04-06T12:16:14.736Z |
| 9610868 | 9610868 | 20260404223615_TZi1N | FR000Y | 2026-04-06T12:11:45.221Z | 2026-04-06T12:16:14.680Z |
| 9610782 | 9610782 | 20260404214457_L4T8E | FR000Y | 2026-04-06T12:11:22.531Z | 2026-04-06T12:16:14.660Z |
| 9610700 | 9610700 | 20260404211524_ceoNQ | FR000Y | 2026-04-06T12:10:48.135Z | 2026-04-06T12:16:14.639Z |
| 9610695 | 9610695 | 20260404211524_koLUO | FR000Y | 2026-04-06T12:10:47.616Z | 2026-04-06T12:16:14.638Z |
| 9610638 | 9610638 | 20260404205804_O21dY | FR000Y | 2026-04-06T12:10:32.824Z | 2026-04-06T12:16:14.624Z |
| 9609164 | 9609164 | 20260405034847_V0lGs | FR000Y | 2026-04-06T12:00:29.523Z | 2026-04-06T12:00:29.523Z |
| 9606924 | 9606924 | 20260403001645_xjklx | FR000Y | 2026-04-04T12:12:18.886Z | 2026-04-06T12:23:56.688Z |
| 9606914 | 9606914 | 20260402235518_U4iRO | FR000Y | 2026-04-04T12:12:15.997Z | 2026-04-06T12:23:55.950Z |
| 9606878 | 9606878 | 20260402225520_Al2Vw | FR000Y | 2026-04-04T12:12:08.679Z | 2026-04-06T12:23:53.777Z |
| 9606853 | 9606853 | 20260402222604_6nuiK | FR000Y | 2026-04-04T12:11:59.354Z | 2026-04-06T12:23:52.106Z |
| 9606837 | 9606837 | 20260402220512_P3N8Z | FR000Y | 2026-04-04T12:11:53.589Z | 2026-04-06T12:23:47.885Z |
| 9605008 | 9605008 | 20260403032130_vvXg2 | FR000Y | 2026-04-04T12:00:16.448Z | 2026-04-06T12:16:17.761Z |
| 9604999 | 9604999 | 20260403030842_Ks2yD | FR000Y | 2026-04-04T12:00:13.620Z | 2026-04-06T12:16:16.935Z |
| 9604827 | 9604827 | 20260402010820_bpVlL | FR000Y | 2026-04-03T12:11:50.050Z | 2026-04-06T12:26:21.325Z |
| 9604795 | 9604795 | 20260402004220_lq9Fv | FR000Y | 2026-04-03T12:11:33.667Z | 2026-04-06T12:26:19.505Z |
| 9604777 | 9604777 | 20260402003336_F20pd | FR000Y | 2026-04-03T12:11:30.939Z | 2026-04-06T12:26:18.481Z |
| 9604753 | 9604753 | 20260402002240_s6L0D | FR000Y | 2026-04-03T12:11:26.464Z | 2026-04-06T12:26:17.064Z |
| 9604621 | 9604621 | 20260401222655_QazKb | FR000Y | 2026-04-03T12:10:53.729Z | 2026-04-06T12:26:07.407Z |
| 9604525 | 9604525 | 20260401194225_doBT5 | FR000Y | 2026-04-03T12:10:06.292Z | 2026-04-06T12:25:51.324Z |
| 9602775 | 9602775 | 20260402031518_dO3bc | FR000Y | 2026-04-03T12:00:33.303Z | 2026-04-06T12:21:11.224Z |
| 9598721 | 9598721 | 20260331033622_BVGeJ | FR000Y | 2026-04-01T12:00:43.830Z | 2026-04-06T12:26:53.219Z |
| 9595402 | 9595402 | 20260330035247_e5DSZ | FR000Y | 2026-03-31T12:01:17.817Z | 2026-04-06T12:30:01.308Z |
| 9594855 | 9594855 | 20260329004437_qoZJd | FR000Y | 2026-03-30T12:10:26.691Z | 2026-04-06T12:40:18.347Z |
| 9594519 | 9594519 | 20260328224709_ZXPCr | FR000Y | 2026-03-30T12:09:44.207Z | 2026-04-06T12:39:55.449Z |
| 9594339 | 9594339 | 20260328213442_qDDU9 | FR000Y | 2026-03-30T12:09:20.347Z | 2026-04-06T12:39:48.557Z |
| 9594159 | 9594159 | 20260328190934_IAIUq | FR000Y | 2026-03-30T12:08:50.974Z | 2026-04-06T12:39:39.536Z |
| 9592462 | 9592462 | 20260329021216_v64kh | FR000Y | 2026-03-30T12:01:01.952Z | 2026-04-06T12:34:11.220Z |
| 9592404 | 9592404 | 20260329020307_HgLdJ | FR000Y | 2026-03-30T12:00:53.703Z | 2026-04-06T12:34:09.252Z |
| 9592334 | 9592334 | 20260329015337_2dK6C | FR000Y | 2026-03-30T12:00:43.043Z | 2026-04-06T12:34:01.245Z |
| 9592306 | 9592306 | 20260329014735_BuPpW | FR000Y | 2026-03-30T12:00:37.186Z | 2026-04-06T12:33:59.571Z |
| 9592256 | 9592256 | 20260329013138_SAhe3 | FR000Y | 2026-03-30T12:00:29.170Z | 2026-04-06T12:33:55.405Z |
| 9592208 | 9592208 | 20260329012411_k1Kw7 | FR000Y | 2026-03-30T12:00:23.494Z | 2026-04-06T12:33:53.920Z |
| 9588611 | 9588611 | 20260327000637_IgQZA | FR000Y | 2026-03-28T12:11:28.048Z | 2026-04-04T12:42:21.770Z |
| 9588603 | 9588603 | 20260327000503_oYueR | FR000Y | 2026-03-28T12:11:26.990Z | 2026-04-04T12:42:21.282Z |
| 9588525 | 9588525 | 20260326233632_RJGUW | FR000Y | 2026-03-28T12:11:19.439Z | 2026-04-04T12:42:17.787Z |
| 9588462 | 9588462 | 20260326231114_ud3Tk | FR000Y | 2026-03-28T12:11:12.629Z | 2026-04-04T12:42:09.395Z |
| 9588282 | 9588282 | 20260326203938_iSyEW | FR000Y | 2026-03-28T12:10:46.316Z | 2026-04-04T12:41:54.521Z |
| 9586155 | 9586155 | 20260327041615_OSo4F | FR000Y | 2026-03-28T12:02:22.269Z | 2026-04-05T12:33:03.849Z |
| 9586073 | 9586073 | 20260327034819_rd6oM | FR000Y | 2026-03-28T12:02:07.265Z | 2026-04-05T12:32:59.803Z |
| 9585803 | 9585803 | 20260327023911_fmOGK | FR000Y | 2026-03-28T12:01:24.027Z | 2026-04-05T12:32:46.558Z |
| 9585662 | 9585662 | 20260327020347_WpWCd | FR000Y | 2026-03-28T12:00:57.617Z | 2026-04-05T12:32:33.748Z |
| 9585095 | 9585095 | 20260325232537_HbvJb | FR000Y | 2026-03-27T12:16:43.498Z | 2026-04-03T12:39:49.360Z |
| 9584931 | 9584931 | 20260325224808_gymL8 | FR000Y | 2026-03-27T12:16:24.253Z | 2026-04-03T12:39:44.710Z |
| 9584905 | 9584905 | 20260325223638_ornQ2 | FR000Y | 2026-03-27T12:16:20.569Z | 2026-04-03T12:39:43.753Z |
| 9584755 | 9584755 | 20260325220026_pbWTp | FR000Y | 2026-03-27T12:16:04.323Z | 2026-04-03T12:39:39.708Z |
| 9580166 | 9580166 | 20260323033209_t2xsl | FR000Y | 2026-03-26T12:16:24.533Z | 2026-03-31T12:26:28.361Z |
| 9580161 | 9580161 | 20260323003516_Kpj5j | FR000Y | 2026-03-26T12:15:37.029Z | 2026-03-31T12:25:52.009Z |
| 9580159 | 9580159 | 20260323002912_293ib | FR000Y | 2026-03-26T12:15:35.705Z | 2026-03-31T12:25:51.274Z |
| 9580143 | 9580143 | 20260325001142_rqXDE | FR000Y | 2026-03-26T12:15:09.899Z | 2026-04-02T12:37:43.645Z |
| 9579955 | 9579955 | 20260324233356_FfIxE | FR000Y | 2026-03-26T12:14:45.256Z | 2026-04-02T12:37:36.194Z |
| 9579874 | 9579874 | 20260324231156_yiWxr | FR000Y | 2026-03-26T12:14:37.287Z | 2026-04-02T12:37:33.516Z |
| 9579866 | 9579866 | 20260324231109_Y6Za6 | FR000Y | 2026-03-26T12:14:36.289Z | 2026-04-02T12:37:33.154Z |
| 9579813 | 9579813 | 20260324230133_Dy1dF | FR000Y | 2026-03-26T12:14:31.252Z | 2026-04-02T12:37:31.489Z |
| 9579632 | 9579632 | 20260324220103_vpYV0 | FR000Y | 2026-03-26T12:14:06.387Z | 2026-04-02T12:37:18.504Z |
| 9579555 | 9579555 | 20260324212327_k73F1 | FR000Y | 2026-03-26T12:13:56.170Z | 2026-04-02T12:37:15.832Z |
| 9579502 | 9579502 | 20260324210257_bIQGe | FR000Y | 2026-03-26T12:13:49.763Z | 2026-04-02T12:37:12.852Z |
| 9579436 | 9579436 | 20260324202848_EGBRA | FR000Y | 2026-03-26T12:13:40.620Z | 2026-04-02T12:37:09.796Z |
| 9576069 | 9576069 | 20260325010944_5pREt | FR000Y | 2026-03-26T12:01:12.018Z | 2026-04-03T12:35:43.313Z |
| 9575915 | 9575915 | 20260325003929_ekn5R | FR000Y | 2026-03-26T12:00:38.946Z | 2026-04-03T12:35:29.051Z |
| 9575561 | 9575561 | 20260323231926_DpbCr | FR000Y | 2026-03-25T12:21:24.203Z | 2026-03-31T12:29:01.855Z |
| 9575471 | 9575471 | 20260323223939_dUcjj | FR000Y | 2026-03-25T12:21:13.015Z | 2026-03-31T12:28:58.450Z |
| 9575438 | 9575438 | 20260323220742_2oopQ | FR000Y | 2026-03-25T12:21:05.471Z | 2026-03-31T12:28:57.603Z |
| 9575437 | 9575437 | 20260323220741_93zCz | FR000Y | 2026-03-25T12:21:05.235Z | 2026-03-31T12:28:57.483Z |
| 9571319 | 9571319 | 20260324011110_SCNfC | FR000Y | 2026-03-25T12:01:00.026Z | 2026-04-02T12:34:19.802Z |
| 9571139 | 9571139 | 20260324000336_QwntD | FR000Y | 2026-03-25T12:00:10.553Z | 2026-04-02T12:34:09.632Z |
| 9571099 | 9571099 | 20260322234503_KNmgJ | FR000Y | 2026-03-24T12:24:20.262Z | 2026-03-30T12:30:55.149Z |
| 9570929 | 9570929 | 20260322231249_K3UKf | FR000Y | 2026-03-24T12:24:02.286Z | 2026-03-30T12:30:52.150Z |
| 9570783 | 9570783 | 20260322224504_QKzKY | FR000Y | 2026-03-24T12:23:48.566Z | 2026-03-30T12:30:49.286Z |
| 9570701 | 9570701 | 20260322223213_PSoDo | FR000Y | 2026-03-24T12:23:39.145Z | 2026-03-30T12:30:48.032Z |
| 9570588 | 9570588 | 20260322221013_uieox | FR000Y | 2026-03-24T12:23:30.263Z | 2026-03-30T12:30:46.077Z |
| 9570573 | 9570573 | 20260322220414_GrUiP | FR000Y | 2026-03-24T12:23:28.986Z | 2026-03-30T12:30:45.722Z |
| 9570549 | 9570549 | 20260322215957_gQ0J0 | FR000Y | 2026-03-24T12:23:26.930Z | 2026-03-30T12:30:45.232Z |
| 9570410 | 9570410 | 20260322211507_SKdZL | FR000Y | 2026-03-24T12:23:10.345Z | 2026-03-30T12:30:42.152Z |
| 9570320 | 9570320 | 20260322203344_L5gzY | FR000Y | 2026-03-24T12:22:59.870Z | 2026-03-30T12:30:39.861Z |
| 9570293 | 9570293 | 20260322202108_0G7bB | FR000Y | 2026-03-24T12:22:56.274Z | 2026-03-30T12:30:38.860Z |
| 9570288 | 9570288 | 20260322202108_V8JWs | FR000Y | 2026-03-24T12:22:55.658Z | 2026-03-30T12:30:38.638Z |
| 9570184 | 9570184 | 20260322193948_9syVV | FR000Y | 2026-03-24T12:22:46.162Z | 2026-03-30T12:30:29.187Z |
| 9562984 | 9562984 | 20260323042208_5MrOy | FR000Y | 2026-03-24T12:04:38.956Z | 2026-03-31T12:26:31.523Z |
| 9562880 | 9562880 | 20260323033209_C2uvt | FR000Y | 2026-03-24T12:04:19.641Z | 2026-03-25T12:21:37.350Z |
| 9562797 | 9562797 | 20260323031552_kvH4g | FR000Y | 2026-03-24T12:04:04.440Z | 2026-03-31T12:26:26.244Z |
| 9562635 | 9562635 | 20260323025145_02exI | FR000Y | 2026-03-24T12:03:36.707Z | 2026-03-31T12:26:16.178Z |
| 9562632 | 9562632 | 20260323025141_wL4Xq | FR000Y | 2026-03-24T12:03:36.195Z | 2026-03-31T12:26:16.102Z |
| 9562572 | 9562572 | 20260323023831_7PDzt | FR000Y | 2026-03-24T12:03:27.936Z | 2026-03-31T12:26:14.662Z |
| 9562520 | 9562520 | 20260323022815_cWGuA | FR000Y | 2026-03-24T12:03:18.668Z | 2026-03-31T12:26:13.378Z |
| 9562403 | 9562403 | 20260323021658_VEy7W | FR000Y | 2026-03-24T12:02:59.745Z | 2026-03-31T12:26:09.370Z |
| 9562390 | 9562390 | 20260323021640_xfeUC | FR000Y | 2026-03-24T12:02:58.072Z | 2026-03-31T12:26:09.156Z |
| 9562297 | 9562297 | 20260323020502_5okeO | FR000Y | 2026-03-24T12:02:45.736Z | 2026-03-31T12:26:06.957Z |
| 9562144 | 9562144 | 20260323013703_o9Tca | FR000Y | 2026-03-24T12:02:18.111Z | 2026-03-31T12:26:02.351Z |
| 9562124 | 9562124 | 20260323013544_8cTCY | FR000Y | 2026-03-24T12:02:12.818Z | 2026-03-31T12:26:01.779Z |
| 9562107 | 9562107 | 20260323013306_sJCs1 | FR000Y | 2026-03-24T12:02:08.413Z | 2026-03-31T12:26:01.298Z |
| 9562034 | 9562034 | 20260323011910_xFRig | FR000Y | 2026-03-24T12:01:58.632Z | 2026-03-31T12:25:59.917Z |
| 9561988 | 9561988 | 20260323010922_D8NUz | FR000Y | 2026-03-24T12:01:46.738Z | 2026-03-31T12:25:58.412Z |
| 9561940 | 9561940 | 20260323005945_C2XHR | FR000Y | 2026-03-24T12:01:39.537Z | 2026-03-31T12:25:57.131Z |
| 9561910 | 9561910 | 20260323005355_mZ9pt | FR000Y | 2026-03-24T12:01:34.696Z | 2026-03-31T12:25:56.203Z |
| 9561905 | 9561905 | 20260323005354_CXBRn | FR000Y | 2026-03-24T12:01:34.158Z | 2026-03-31T12:25:56.105Z |
| 9561773 | 9561773 | 20260323004106_EHRe0 | FR000Y | 2026-03-24T12:01:15.886Z | 2026-03-31T12:25:53.392Z |
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);