home / gmn_data_store / participating_station

Menu
  • Dashboards

participating_station

Each row represents a station recording a meteor sighting.

Data license: CC BY 4.0 license · Data source: Global Meteor Network

>10,000 rows count all where station_code = "BE0005" sorted by created_at descending

✎ View and edit SQL

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
9259790 9259790 20260125001432_B3MSt BE0005 2026-01-26T14:18:36.663Z 2026-01-29T14:43:19.476Z
9259751 9259751 20260124235616_EjwrF BE0005 2026-01-26T14:18:28.013Z 2026-01-29T14:43:17.247Z
9259725 9259725 20260124234256_dC3BV BE0005 2026-01-26T14:18:17.368Z 2026-01-29T14:43:15.561Z
9255678 9255678 20260124042944_NsbL4 BE0005 2026-01-25T14:14:16.956Z 2026-01-29T14:47:50.851Z
9255636 9255636 20260124042259_waz8y BE0005 2026-01-25T14:14:09.610Z 2026-01-29T14:47:48.920Z
9255626 9255626 20260124042240_OAv2G BE0005 2026-01-25T14:14:08.478Z 2026-01-29T14:47:48.387Z
9255607 9255607 20260124041934_lP5px BE0005 2026-01-25T14:14:06.308Z 2026-01-29T14:47:42.683Z
9255572 9255572 20260124041525_cuoME BE0005 2026-01-25T14:14:00.632Z 2026-01-29T14:47:40.859Z
9255558 9255558 20260124041246_45PQl BE0005 2026-01-25T14:13:57.947Z 2026-01-29T14:47:40.314Z
9255503 9255503 20260124035249_WaIk2 BE0005 2026-01-25T14:13:42.850Z 2026-01-29T14:47:35.006Z
9249601 9249601 20260122060322_p2A3X BE0005 2026-01-23T14:15:46.428Z 2026-01-29T14:58:46.441Z
9249487 9249487 20260122053048_oQzdr BE0005 2026-01-23T14:15:35.603Z 2026-01-29T14:58:41.688Z
9249420 9249420 20260122051503_Mi2RW BE0005 2026-01-23T14:15:21.235Z 2026-01-29T14:58:30.110Z
9249314 9249314 20260122044550_B9Pjt BE0005 2026-01-23T14:15:09.952Z 2026-01-29T14:58:25.564Z
9249252 9249252 20260122042534_L34Qj BE0005 2026-01-23T14:15:03.717Z 2026-01-29T14:58:19.954Z
9249071 9249071 20260122032913_D5KLQ BE0005 2026-01-23T14:14:32.531Z 2026-01-29T14:58:11.553Z
9248988 9248988 20260122030511_e2oVd BE0005 2026-01-23T14:14:16.664Z 2026-01-29T14:58:07.586Z
9248942 9248942 20260122025209_ISJik BE0005 2026-01-23T14:14:09.108Z 2026-01-29T14:57:55.755Z
9248917 9248917 20260122024422_mOeM2 BE0005 2026-01-23T14:14:06.866Z 2026-01-29T14:57:54.791Z
9248836 9248836 20260122022325_2KAHe BE0005 2026-01-23T14:13:57.598Z 2026-01-29T14:57:49.029Z
9248778 9248778 20260122020940_GWMNA BE0005 2026-01-23T14:13:51.121Z 2026-01-29T14:57:46.442Z
9248704 9248704 20260122014906_0l4sK BE0005 2026-01-23T14:13:29.220Z 2026-01-29T14:57:42.160Z
9248679 9248679 20260122014218_iYHuJ BE0005 2026-01-23T14:13:24.865Z 2026-01-29T14:57:40.525Z
9248612 9248612 20260122011029_GR1CH BE0005 2026-01-23T14:13:16.346Z 2026-01-29T14:57:36.842Z
9248574 9248574 20260122004840_PkQIU BE0005 2026-01-23T14:13:11.240Z 2026-01-29T14:57:34.558Z
9248423 9248423 20260121234256_hYHKZ BE0005 2026-01-23T14:12:46.440Z 2026-01-29T14:57:18.309Z
9248371 9248371 20260121231610_WyehW BE0005 2026-01-23T14:12:39.786Z 2026-01-29T14:57:15.975Z
9248309 9248309 20260121225152_oakVe BE0005 2026-01-23T14:12:29.350Z 2026-01-29T14:57:13.407Z
9248169 9248169 20260121220236_ZHSh9 BE0005 2026-01-23T14:12:11.152Z 2026-01-29T14:57:06.798Z
9247640 9247640 20260121192212_NtkMD BE0005 2026-01-23T14:10:39.532Z 2026-01-29T14:56:21.341Z
9239041 9239041 20260118032054_gGQqQ BE0005 2026-01-21T14:44:16.040Z 2026-01-26T15:02:50.462Z
9224780 9224780 20260118060338_9V6CM BE0005 2026-01-19T14:26:02.449Z 2026-01-26T15:03:49.069Z
9224758 9224758 20260118060045_Dj6JH BE0005 2026-01-19T14:25:52.913Z 2026-01-26T15:03:48.288Z
9224590 9224590 20260118051542_xiuDM BE0005 2026-01-19T14:25:07.247Z 2026-01-26T15:03:25.589Z
9224580 9224580 20260118051437_RqPBV BE0005 2026-01-19T14:25:05.774Z 2026-01-26T15:03:24.615Z
9224153 9224153 20260118033807_AeQ89 BE0005 2026-01-19T14:23:06.965Z 2026-01-26T15:03:06.897Z
9224082 9224082 20260118032054_J2Zsv BE0005 2026-01-19T14:22:42.763Z 2026-01-20T14:42:26.260Z
9224037 9224037 20260118031301_EgDZZ BE0005 2026-01-19T14:22:29.797Z 2026-01-26T15:02:48.655Z
9223854 9223854 20260118023454_49gU0 BE0005 2026-01-19T14:21:29.198Z 2026-01-26T15:02:38.905Z
9223831 9223831 20260118022922_MPTQc BE0005 2026-01-19T14:21:19.630Z 2026-01-26T15:02:37.752Z
9223733 9223733 20260118021501_23XF6 BE0005 2026-01-19T14:20:47.826Z 2026-01-26T15:02:34.081Z
9223416 9223416 20260118003705_14Lx5 BE0005 2026-01-19T14:19:11.273Z 2026-01-26T15:02:06.107Z
9223296 9223296 20260118000831_QmczN BE0005 2026-01-19T14:18:36.624Z 2026-01-26T15:02:01.482Z
9223255 9223255 20260117235951_h3LaR BE0005 2026-01-19T14:18:24.837Z 2026-01-26T15:01:59.993Z
9222988 9222988 20260117220556_pL7Ux BE0005 2026-01-19T14:17:13.501Z 2026-01-26T15:01:31.139Z
9218817 9218817 20260117060244_x2whw BE0005 2026-01-18T14:13:49.088Z 2026-01-25T14:58:52.332Z
9149575 9149575 20260104220555_GWiVv BE0005 2026-01-06T14:06:09.858Z 2026-01-13T15:12:19.091Z
9149403 9149403 20260104205143_4BLOB BE0005 2026-01-06T14:05:20.982Z 2026-01-13T15:12:09.509Z
9149121 9149121 20260104184949_ordk3 BE0005 2026-01-06T14:03:51.739Z 2026-01-13T15:11:43.206Z
9149044 9149044 20260104183554_WH2t2 BE0005 2026-01-06T14:03:36.041Z 2026-01-13T15:11:39.725Z
9148807 9148807 20260104173221_qHePl BE0005 2026-01-06T14:02:26.486Z 2026-01-13T15:11:20.205Z
9129884 9129884 20260103011819_PyTWa BE0005 2026-01-04T14:07:01.183Z 2026-01-10T14:58:22.200Z
9124275 9124275 20251231054620_b8h0L BE0005 2026-01-02T14:44:05.243Z 2026-01-08T15:11:25.178Z
9124273 9124273 20251231054410_9T6QB BE0005 2026-01-02T14:44:03.549Z 2026-01-08T15:11:24.674Z
9124202 9124202 20251231052444_Wd5L5 BE0005 2026-01-02T14:43:04.970Z 2026-01-08T15:11:09.919Z
9124173 9124173 20251231051122_QDmbN BE0005 2026-01-02T14:42:23.986Z 2026-01-08T15:10:50.045Z
9123903 9123903 20251231040159_jhRsM BE0005 2026-01-02T14:38:00.025Z 2026-01-08T15:09:23.820Z
9123866 9123866 20251231035146_M30X2 BE0005 2026-01-02T14:37:14.795Z 2026-01-08T15:09:12.334Z
9119837 9119837 20251230191158_RbyrQ BE0005 2026-01-01T14:57:25.023Z 2026-01-07T15:13:22.806Z
9119747 9119747 20251230185211_ydK6g BE0005 2026-01-01T14:57:11.967Z 2026-01-07T15:13:15.121Z
9116131 9116131 20251231055138_vsUab BE0005 2026-01-01T14:27:20.408Z 2026-01-01T14:57:54.656Z
9115961 9115961 20251231053556_mtl2q BE0005 2026-01-01T14:26:51.532Z 2026-01-08T15:11:18.516Z
9115870 9115870 20251231053215_JLw2l BE0005 2026-01-01T14:26:42.999Z 2026-01-08T15:11:15.863Z
9115785 9115785 20251231052918_FHICK BE0005 2026-01-01T14:26:28.993Z 2026-01-08T15:11:12.120Z
9115728 9115728 20251231052444_QfEhQ BE0005 2026-01-01T14:26:17.273Z 2026-01-08T15:11:10.054Z
9115624 9115624 20251231051940_lllrQ BE0005 2026-01-01T14:25:57.511Z 2026-01-01T14:57:54.344Z
9115486 9115486 20251231051122_2pfKZ BE0005 2026-01-01T14:25:34.822Z 2026-01-08T15:10:49.868Z
9115407 9115407 20251231050525_jg22M BE0005 2026-01-01T14:25:20.049Z 2026-01-08T15:10:46.679Z
9114963 9114963 20251231043734_HYGCn BE0005 2026-01-01T14:23:54.835Z 2026-01-08T15:10:16.694Z
9114086 9114086 20251231040159_Hz717 BE0005 2026-01-01T14:21:22.186Z 2026-01-08T15:09:23.656Z
9113841 9113841 20251231035146_Pyp08 BE0005 2026-01-01T14:20:33.569Z 2026-01-08T15:09:12.203Z
9104461 9104461 20251230055606_YO9ho BE0005 2025-12-31T14:21:17.332Z 2026-01-07T15:09:43.587Z
9104450 9104450 20251230055417_ZqGkh BE0005 2025-12-31T14:21:15.725Z 2026-01-07T15:09:43.293Z
9104425 9104425 20251230055248_NMDGg BE0005 2025-12-31T14:21:10.090Z 2026-01-07T15:09:42.398Z
9104378 9104378 20251230054952_9fcvu BE0005 2025-12-31T14:21:04.646Z 2026-01-07T15:09:40.730Z
9099372 9099372 20251226210917_OSCkU BE0005 2025-12-30T15:23:28.660Z 2026-01-03T15:44:08.093Z
9098945 9098945 20251227203256_Ifjek BE0005 2025-12-30T15:11:17.743Z 2025-12-30T15:11:17.743Z
9098456 9098456 20251227190901_kpD2B BE0005 2025-12-30T15:10:30.788Z 2026-01-04T15:35:02.750Z
9098327 9098327 20251227184934_5Lfps BE0005 2025-12-30T15:10:05.890Z 2026-01-04T15:34:55.989Z
9098280 9098280 20251227184217_GZiKG BE0005 2025-12-30T15:10:03.251Z 2026-01-04T15:34:53.562Z
9097696 9097696 20251227172058_R0C2q BE0005 2025-12-30T15:09:13.490Z 2026-01-04T15:34:18.198Z
9093322 9093322 20251227053324_Wd9JO BE0005 2025-12-30T15:03:02.829Z 2025-12-30T15:03:02.829Z
9093304 9093304 20251227052644_foPge BE0005 2025-12-30T15:03:00.115Z 2026-01-04T15:29:59.905Z
9092836 9092836 20251227031140_NQdsl BE0005 2025-12-30T15:00:57.929Z 2026-01-04T15:27:47.004Z
9092286 9092286 20251227001107_0qYL8 BE0005 2025-12-30T14:57:56.571Z 2026-01-04T15:24:52.245Z
9092245 9092245 20251226235112_u2NJp BE0005 2025-12-30T14:57:37.220Z 2026-01-04T15:24:40.283Z
9091850 9091850 20251228200533_QtAi1 BE0005 2025-12-30T14:53:25.169Z 2026-01-05T15:14:43.123Z
9090836 9090836 20251228170402_0PyUj BE0005 2025-12-30T14:51:12.508Z 2025-12-31T14:56:31.415Z
9084458 9084458 20251228014529_x8XbL BE0005 2025-12-30T14:35:45.493Z 2026-01-05T15:08:43.529Z
9084142 9084142 20251228011235_Fdfsv BE0005 2025-12-30T14:34:54.494Z 2026-01-05T15:08:33.576Z
9083929 9083929 20251228005242_EAZ3n BE0005 2025-12-30T14:34:14.137Z 2026-01-05T15:08:21.406Z
9083889 9083889 20251228004825_4d235 BE0005 2025-12-30T14:34:07.464Z 2026-01-05T15:08:14.659Z
9083732 9083732 20251228002658_w2Qq0 BE0005 2025-12-30T14:33:34.751Z 2026-01-05T15:08:08.773Z
9083656 9083656 20251228001805_54Np1 BE0005 2025-12-30T14:33:23.859Z 2025-12-30T14:53:54.271Z
9083353 9083353 20251227234240_g22TD BE0005 2025-12-30T14:32:25.233Z 2026-01-05T15:07:45.758Z
9083216 9083216 20251227231848_eFwT2 BE0005 2025-12-30T14:31:58.882Z 2026-01-05T15:07:41.159Z
9083181 9083181 20251227231023_eV9C0 BE0005 2025-12-30T14:31:53.470Z 2026-01-05T15:07:40.032Z
9083030 9083030 20251227224142_JZyLM BE0005 2025-12-30T14:31:23.398Z 2026-01-05T15:07:35.082Z
9082835 9082835 20251227215150_30nrD BE0005 2025-12-30T14:30:46.808Z 2026-01-05T15:07:28.302Z
9081274 9081274 20251229061347_uPHnN BE0005 2025-12-30T14:24:24.129Z 2026-01-06T15:18:56.979Z

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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);
Powered by Datasette · Queries took 1.2ms · Data license: CC BY 4.0 license · Data source: Global Meteor Network