participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,360 rows where station_code = "CL0003" 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 |
|---|---|---|---|---|---|
| 9813819 | 9813819 | 20260428052938_LnldR | CL0003 | 2026-04-29T12:16:15.736Z | 2026-04-29T12:24:07.790Z |
| 9813760 | 9813760 | 20260428043127_ty9gJ | CL0003 | 2026-04-29T12:16:04.099Z | 2026-04-29T12:24:07.748Z |
| 9808772 | 9808772 | 20260427100131_xtbjO | CL0003 | 2026-04-28T12:21:12.091Z | 2026-04-29T12:31:46.997Z |
| 9808770 | 9808770 | 20260427100115_3hMCG | CL0003 | 2026-04-28T12:21:11.727Z | 2026-04-29T12:31:46.858Z |
| 9808645 | 9808645 | 20260427092736_TXDKn | CL0003 | 2026-04-28T12:20:47.278Z | 2026-04-29T12:31:27.038Z |
| 9808183 | 9808183 | 20260427080423_KJEZS | CL0003 | 2026-04-28T12:19:15.482Z | 2026-04-29T12:30:41.792Z |
| 9808095 | 9808095 | 20260427074826_IECDk | CL0003 | 2026-04-28T12:18:53.997Z | 2026-04-29T12:30:35.933Z |
| 9807829 | 9807829 | 20260427070124_T3xei | CL0003 | 2026-04-28T12:17:56.209Z | 2026-04-29T12:30:09.571Z |
| 9807765 | 9807765 | 20260427064212_sL7Rr | CL0003 | 2026-04-28T12:17:30.168Z | 2026-04-29T12:30:05.769Z |
| 9807614 | 9807614 | 20260427053412_G5CD7 | CL0003 | 2026-04-28T12:16:54.688Z | 2026-04-29T12:29:52.684Z |
| 9807567 | 9807567 | 20260427050251_1NSMF | CL0003 | 2026-04-28T12:16:44.004Z | 2026-04-29T12:29:47.709Z |
| 9807553 | 9807553 | 20260427045326_2Pfzt | CL0003 | 2026-04-28T12:16:41.019Z | 2026-04-29T12:29:47.060Z |
| 9807492 | 9807492 | 20260427035412_CT15T | CL0003 | 2026-04-28T12:16:17.278Z | 2026-04-29T12:29:42.750Z |
| 9807386 | 9807386 | 20260427032034_33243 | CL0003 | 2026-04-28T12:16:04.281Z | 2026-04-29T12:29:38.569Z |
| 9807036 | 9807036 | 20260427022445_PUZOp | CL0003 | 2026-04-28T12:14:41.661Z | 2026-04-29T12:29:15.477Z |
| 9806280 | 9806280 | 20260427003647_a3rRt | CL0003 | 2026-04-28T12:11:09.112Z | 2026-04-29T12:28:22.123Z |
| 9801337 | 9801337 | 20260426093544_FRas2 | CL0003 | 2026-04-27T12:32:42.306Z | 2026-04-29T12:42:13.878Z |
| 9801254 | 9801254 | 20260426091602_Z2284 | CL0003 | 2026-04-27T12:32:21.461Z | 2026-04-29T12:42:08.597Z |
| 9801177 | 9801177 | 20260426084032_uq3qd | CL0003 | 2026-04-27T12:32:07.174Z | 2026-04-29T12:42:05.073Z |
| 9801164 | 9801164 | 20260426083753_Qp3QC | CL0003 | 2026-04-27T12:32:05.124Z | 2026-04-29T12:42:04.479Z |
| 9801090 | 9801090 | 20260426081653_d5Kt2 | CL0003 | 2026-04-27T12:31:49.969Z | 2026-04-29T12:42:01.901Z |
| 9801051 | 9801051 | 20260426075913_h3LIg | CL0003 | 2026-04-27T12:31:37.236Z | 2026-04-29T12:42:00.284Z |
| 9801010 | 9801010 | 20260426074210_slqZy | CL0003 | 2026-04-27T12:31:31.362Z | 2026-04-29T12:41:58.358Z |
| 9800793 | 9800793 | 20260426053933_T42ar | CL0003 | 2026-04-27T12:30:55.127Z | 2026-04-29T12:41:43.595Z |
| 9800782 | 9800782 | 20260426042137_qmYmq | CL0003 | 2026-04-27T12:30:52.826Z | 2026-04-29T12:41:43.010Z |
| 9800772 | 9800772 | 20260426040503_PYCcK | CL0003 | 2026-04-27T12:30:45.242Z | 2026-04-29T12:41:42.506Z |
| 9800747 | 9800747 | 20260426033256_ld0W6 | CL0003 | 2026-04-27T12:30:35.275Z | 2026-04-29T12:41:41.079Z |
| 9788463 | 9788463 | 20260425101134_m2tEv | CL0003 | 2026-04-26T12:24:24.645Z | 2026-04-29T12:51:14.268Z |
| 9788416 | 9788416 | 20260425092829_elMDF | CL0003 | 2026-04-26T12:24:18.012Z | 2026-04-29T12:51:01.708Z |
| 9788337 | 9788337 | 20260425083319_UvEFf | CL0003 | 2026-04-26T12:24:13.517Z | 2026-04-29T12:50:53.492Z |
| 9788300 | 9788300 | 20260425081416_87drg | CL0003 | 2026-04-26T12:24:10.681Z | 2026-04-29T12:50:51.670Z |
| 9788269 | 9788269 | 20260425074936_i36Oz | CL0003 | 2026-04-26T12:24:08.047Z | 2026-04-29T12:50:48.637Z |
| 9788170 | 9788170 | 20260425065435_7y9Sv | CL0003 | 2026-04-26T12:23:59.962Z | 2026-04-29T12:50:29.399Z |
| 9788103 | 9788103 | 20260425055914_t7beZ | CL0003 | 2026-04-26T12:23:51.306Z | 2026-04-29T12:50:26.496Z |
| 9788091 | 9788091 | 20260425055156_hn7Ii | CL0003 | 2026-04-26T12:23:41.087Z | 2026-04-29T12:50:25.982Z |
| 9788089 | 9788089 | 20260425055129_M0twA | CL0003 | 2026-04-26T12:23:40.170Z | 2026-04-29T12:50:25.811Z |
| 9788083 | 9788083 | 20260425054547_trzKB | CL0003 | 2026-04-26T12:23:37.824Z | 2026-04-29T12:50:25.549Z |
| 9787935 | 9787935 | 20260425032550_dNHtc | CL0003 | 2026-04-26T12:23:19.469Z | 2026-04-29T12:50:19.311Z |
| 9787886 | 9787886 | 20260425031431_gVfg8 | CL0003 | 2026-04-26T12:23:16.878Z | 2026-04-29T12:50:18.190Z |
| 9787146 | 9787146 | 20260425021744_32Oy0 | CL0003 | 2026-04-26T12:22:00.258Z | 2026-04-29T12:49:48.798Z |
| 9786862 | 9786862 | 20260425015906_kQVZ7 | CL0003 | 2026-04-26T12:21:39.312Z | 2026-04-29T12:49:39.034Z |
| 9785201 | 9785201 | 20260425000552_W5lQj | CL0003 | 2026-04-26T12:18:39.353Z | 2026-04-29T12:48:32.734Z |
| 9775225 | 9775225 | 20260423100235_WbwaQ | CL0003 | 2026-04-25T12:56:21.385Z | 2026-04-29T13:09:50.604Z |
| 9775093 | 9775093 | 20260423094724_DUD27 | CL0003 | 2026-04-25T12:55:48.018Z | 2026-04-29T13:09:48.683Z |
| 9774861 | 9774861 | 20260423092515_Kt8lD | CL0003 | 2026-04-25T12:55:34.829Z | 2026-04-29T13:09:46.268Z |
| 9774666 | 9774666 | 20260423090428_FqLEh | CL0003 | 2026-04-25T12:55:07.313Z | 2026-04-29T13:09:43.415Z |
| 9773531 | 9773531 | 20260423070757_OYk6E | CL0003 | 2026-04-25T12:52:30.773Z | 2026-04-29T13:08:23.278Z |
| 9773444 | 9773444 | 20260423065426_EUKmt | CL0003 | 2026-04-25T12:52:19.617Z | 2026-04-29T13:08:20.180Z |
| 9773185 | 9773185 | 20260423061702_WBneG | CL0003 | 2026-04-25T12:51:36.813Z | 2026-04-29T13:08:16.094Z |
| 9773142 | 9773142 | 20260423060918_49ztH | CL0003 | 2026-04-25T12:51:30.974Z | 2026-04-29T13:08:15.442Z |
| 9772849 | 9772849 | 20260423045158_b1KlK | CL0003 | 2026-04-25T12:50:42.156Z | 2026-04-29T13:08:11.370Z |
| 9772662 | 9772662 | 20260423032814_26AG7 | CL0003 | 2026-04-25T12:50:02.882Z | 2026-04-29T13:08:07.068Z |
| 9772660 | 9772660 | 20260423032646_jdVvq | CL0003 | 2026-04-25T12:50:02.197Z | 2026-04-29T13:08:06.761Z |
| 9772566 | 9772566 | 20260423023402_zgezG | CL0003 | 2026-04-25T12:49:22.054Z | 2026-04-29T13:07:15.488Z |
| 9772461 | 9772461 | 20260423011658_pd2iY | CL0003 | 2026-04-25T12:47:24.322Z | 2026-04-29T13:06:02.580Z |
| 9772439 | 9772439 | 20260423010016_to6Nu | CL0003 | 2026-04-25T12:46:52.545Z | 2026-04-29T13:05:53.912Z |
| 9771283 | 9771283 | 20260424073655_QjDx3 | CL0003 | 2026-04-25T12:34:42.735Z | 2026-04-29T12:58:52.960Z |
| 9771279 | 9771279 | 20260424073504_EsEJI | CL0003 | 2026-04-25T12:34:41.976Z | 2026-04-29T12:58:52.768Z |
| 9771177 | 9771177 | 20260424071442_M67BD | CL0003 | 2026-04-25T12:34:16.825Z | 2026-04-29T12:58:36.155Z |
| 9771052 | 9771052 | 20260424064942_Z0qiT | CL0003 | 2026-04-25T12:34:03.245Z | 2026-04-29T12:58:29.665Z |
| 9771048 | 9771048 | 20260424064933_IVjTr | CL0003 | 2026-04-25T12:33:53.707Z | 2026-04-29T12:58:29.626Z |
| 9771021 | 9771021 | 20260424064216_D2O9s | CL0003 | 2026-04-25T12:33:49.719Z | 2026-04-29T12:58:29.122Z |
| 9770991 | 9770991 | 20260424063332_0ihy0 | CL0003 | 2026-04-25T12:33:44.371Z | 2026-04-29T12:58:28.546Z |
| 9770811 | 9770811 | 20260424054342_lnQyI | CL0003 | 2026-04-25T12:33:12.149Z | 2026-04-29T12:58:23.655Z |
| 9770705 | 9770705 | 20260424044706_0xciM | CL0003 | 2026-04-25T12:32:46.966Z | 2026-04-29T12:58:21.298Z |
| 9770260 | 9770260 | 20260424030520_FQg90 | CL0003 | 2026-04-25T12:31:39.332Z | 2026-04-29T12:58:13.275Z |
| 9769707 | 9769707 | 20260424023240_sowNN | CL0003 | 2026-04-25T12:30:25.588Z | 2026-04-29T12:57:46.538Z |
| 9741238 | 9741238 | 20260422101351_vjlr4 | CL0003 | 2026-04-23T12:28:06.310Z | 2026-04-29T13:16:57.443Z |
| 9740835 | 9740835 | 20260422090427_1nIVa | CL0003 | 2026-04-23T12:27:20.129Z | 2026-04-29T13:16:29.086Z |
| 9740819 | 9740819 | 20260422090029_bzRaz | CL0003 | 2026-04-23T12:27:18.368Z | 2026-04-29T13:16:25.981Z |
| 9740736 | 9740736 | 20260422084846_xwQO8 | CL0003 | 2026-04-23T12:26:55.700Z | 2026-04-29T13:16:21.662Z |
| 9740689 | 9740689 | 20260422084040_tnSjm | CL0003 | 2026-04-23T12:26:48.771Z | 2026-04-29T13:16:12.089Z |
| 9740667 | 9740667 | 20260422083213_oBAKO | CL0003 | 2026-04-23T12:26:46.989Z | 2026-04-29T13:16:08.515Z |
| 9740598 | 9740598 | 20260422082144_oKVkQ | CL0003 | 2026-04-23T12:26:40.990Z | 2026-04-29T13:15:58.198Z |
| 9740472 | 9740472 | 20260422075813_hMbhu | CL0003 | 2026-04-23T12:26:30.299Z | 2026-04-29T13:15:42.554Z |
| 9740072 | 9740072 | 20260422055405_AjMKG | CL0003 | 2026-04-23T12:25:17.167Z | 2026-04-29T13:15:27.236Z |
| 9740046 | 9740046 | 20260422054747_Q9aga | CL0003 | 2026-04-23T12:25:14.730Z | 2026-04-29T13:15:25.949Z |
| 9739767 | 9739767 | 20260422034113_vOctQ | CL0003 | 2026-04-23T12:24:29.168Z | 2026-04-29T13:15:21.349Z |
| 9739726 | 9739726 | 20260422033358_Ne5wN | CL0003 | 2026-04-23T12:24:26.390Z | 2026-04-29T13:15:20.886Z |
| 9730116 | 9730116 | 20260421093932_0311j | CL0003 | 2026-04-22T12:29:48.663Z | 2026-04-29T13:22:37.457Z |
| 9729974 | 9729974 | 20260421090313_2h2iO | CL0003 | 2026-04-22T12:29:28.906Z | 2026-04-29T13:22:35.649Z |
| 9729766 | 9729766 | 20260421082903_S9Q7X | CL0003 | 2026-04-22T12:28:47.182Z | 2026-04-29T13:22:30.365Z |
| 9729476 | 9729476 | 20260421072402_JgdMj | CL0003 | 2026-04-22T12:27:56.118Z | 2026-04-29T13:22:26.106Z |
| 9729358 | 9729358 | 20260421065401_h1akL | CL0003 | 2026-04-22T12:27:27.458Z | 2026-04-29T13:22:23.755Z |
| 9729321 | 9729321 | 20260421064649_9I5uD | CL0003 | 2026-04-22T12:27:25.511Z | 2026-04-29T13:22:23.531Z |
| 9729281 | 9729281 | 20260421063503_Eo2Q0 | CL0003 | 2026-04-22T12:27:21.483Z | 2026-04-29T13:22:22.865Z |
| 9729266 | 9729266 | 20260421063118_FOKP7 | CL0003 | 2026-04-22T12:27:19.693Z | 2026-04-29T13:22:22.655Z |
| 9729222 | 9729222 | 20260421062158_xzmqb | CL0003 | 2026-04-22T12:27:04.198Z | 2026-04-29T13:22:22.160Z |
| 9728927 | 9728927 | 20260421042005_sgJ5k | CL0003 | 2026-04-22T12:25:56.392Z | 2026-04-29T13:21:40.038Z |
| 9727557 | 9727557 | 20260421015832_K2yOC | CL0003 | 2026-04-22T12:22:28.817Z | 2026-04-29T13:21:08.042Z |
| 9726655 | 9726655 | 20260421005417_32UVA | CL0003 | 2026-04-22T12:20:18.378Z | 2026-04-29T13:20:29.234Z |
| 9721548 | 9721548 | 20260420090050_QdaME | CL0003 | 2026-04-21T12:31:01.438Z | 2026-04-28T13:39:45.047Z |
| 9721494 | 9721494 | 20260420083840_sm5W4 | CL0003 | 2026-04-21T12:30:53.918Z | 2026-04-28T13:39:37.821Z |
| 9721487 | 9721487 | 20260420083001_3wMlp | CL0003 | 2026-04-21T12:30:52.822Z | 2026-04-28T13:39:37.640Z |
| 9721480 | 9721480 | 20260420082702_HFdJo | CL0003 | 2026-04-21T12:30:51.823Z | 2026-04-28T13:39:37.480Z |
| 9721441 | 9721441 | 20260420080557_U3RMU | CL0003 | 2026-04-21T12:30:35.103Z | 2026-04-28T13:39:36.731Z |
| 9721428 | 9721428 | 20260420080123_jEpoy | CL0003 | 2026-04-21T12:30:33.326Z | 2026-04-28T13:39:36.563Z |
| 9721365 | 9721365 | 20260420071251_Iit90 | CL0003 | 2026-04-21T12:30:22.289Z | 2026-04-28T13:39:35.260Z |
| 9721360 | 9721360 | 20260420071229_73Dda | CL0003 | 2026-04-21T12:30:21.795Z | 2026-04-28T13:39:35.140Z |
| 9721312 | 9721312 | 20260420064047_nhXGY | CL0003 | 2026-04-21T12:30:15.646Z | 2026-04-28T13:39:34.189Z |
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);