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

7,875 rows where station_code = "BE000E" 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
9272020 9272020 20260127225910_r0vdt BE000E 2026-01-29T14:25:18.782Z 2026-01-29T14:30:25.265Z
9271923 9271923 20260127215905_DIWtU BE000E 2026-01-29T14:24:56.001Z 2026-01-29T14:30:25.230Z
9262763 9262763 20260126022322_EVcAv BE000E 2026-01-27T14:15:10.068Z 2026-01-29T14:38:41.873Z
9262678 9262678 20260126005755_TOWGq BE000E 2026-01-27T14:14:42.919Z 2026-01-29T14:38:33.958Z
9262645 9262645 20260125232153_SyJiQ BE000E 2026-01-27T14:14:34.569Z 2026-01-29T14:38:31.309Z
9262618 9262618 20260125214452_eh7Jd BE000E 2026-01-27T14:14:20.830Z 2026-01-29T14:38:28.646Z
9262608 9262608 20260125211747_HnlmJ BE000E 2026-01-27T14:14:09.018Z 2026-01-29T14:38:26.695Z
9260516 9260516 20260125050252_fbV0x BE000E 2026-01-26T14:22:03.472Z 2026-01-29T14:44:19.583Z
9260510 9260510 20260125045904_sZnWz BE000E 2026-01-26T14:22:02.087Z 2026-01-29T14:44:19.125Z
9260499 9260499 20260125045401_JnRAw BE000E 2026-01-26T14:22:00.398Z 2026-01-29T14:44:18.521Z
9260451 9260451 20260125043452_UNANJ BE000E 2026-01-26T14:21:52.059Z 2026-01-29T14:44:13.916Z
9260438 9260438 20260125042715_6pgKe BE000E 2026-01-26T14:21:49.699Z 2026-01-29T14:44:13.178Z
9260416 9260416 20260125041759_mZx5N BE000E 2026-01-26T14:21:42.840Z 2026-01-29T14:44:11.502Z
9260401 9260401 20260125041526_vEK4a BE000E 2026-01-26T14:21:35.020Z 2026-01-29T14:44:10.651Z
9260375 9260375 20260125040531_SZAG7 BE000E 2026-01-26T14:21:26.995Z 2026-01-29T14:44:08.985Z
9260364 9260364 20260125035947_f6YK2 BE000E 2026-01-26T14:21:24.672Z 2026-01-29T14:44:08.209Z
9260317 9260317 20260125033847_n07ag BE000E 2026-01-26T14:21:16.456Z 2026-01-29T14:44:05.512Z
9260226 9260226 20260125031127_fPA65 BE000E 2026-01-26T14:20:51.794Z 2026-01-29T14:44:00.791Z
9260155 9260155 20260125024744_AjfF8 BE000E 2026-01-26T14:20:27.084Z 2026-01-29T14:43:51.539Z
9260106 9260106 20260125023740_Md5IJ BE000E 2026-01-26T14:20:18.107Z 2026-01-29T14:43:48.936Z
9260091 9260091 20260125023216_zuI7Y BE000E 2026-01-26T14:20:14.791Z 2026-01-29T14:43:46.142Z
9260049 9260049 20260125021623_L2E5P BE000E 2026-01-26T14:19:57.484Z 2026-01-29T14:43:43.573Z
9259929 9259929 20260125011400_cGYLA BE000E 2026-01-26T14:19:22.657Z 2026-01-29T14:43:35.750Z
9259876 9259876 20260125005623_FQMjA BE000E 2026-01-26T14:19:07.939Z 2026-01-29T14:43:32.706Z
9259823 9259823 20260125002939_11PkL BE000E 2026-01-26T14:18:43.623Z 2026-01-29T14:43:23.676Z
9259818 9259818 20260125002811_RdNzl BE000E 2026-01-26T14:18:42.666Z 2026-01-29T14:43:23.338Z
9259806 9259806 20260125002611_j3Nn6 BE000E 2026-01-26T14:18:39.413Z 2026-01-29T14:43:22.534Z
9259746 9259746 20260124235349_6PNRJ BE000E 2026-01-26T14:18:26.774Z 2026-01-29T14:43:16.833Z
9259733 9259733 20260124234444_aewq7 BE000E 2026-01-26T14:18:19.056Z 2026-01-29T14:43:16.027Z
9259701 9259701 20260124232621_BHXyW BE000E 2026-01-26T14:18:09.115Z 2026-01-29T14:43:14.003Z
9259659 9259659 20260124225938_9lcI7 BE000E 2026-01-26T14:18:00.465Z 2026-01-29T14:43:11.702Z
9259637 9259637 20260124224700_5WDPd BE000E 2026-01-26T14:17:47.497Z 2026-01-29T14:43:10.587Z
9259547 9259547 20260124212305_9GbYO BE000E 2026-01-26T14:17:26.019Z 2026-01-29T14:43:05.417Z
9259515 9259515 20260124211423_qLVXW BE000E 2026-01-26T14:17:21.760Z 2026-01-29T14:43:01.608Z
9259410 9259410 20260124204235_X3sh5 BE000E 2026-01-26T14:16:56.518Z 2026-01-29T14:42:53.675Z
9259327 9259327 20260124202452_MB0JF BE000E 2026-01-26T14:16:32.308Z 2026-01-29T14:42:48.138Z
9259253 9259253 20260124200120_brphq BE000E 2026-01-26T14:16:21.832Z 2026-01-29T14:42:45.005Z
9259204 9259204 20260124193815_d2uSQ BE000E 2026-01-26T14:16:06.345Z 2026-01-29T14:42:42.459Z
9259179 9259179 20260124192501_M2WFy BE000E 2026-01-26T14:16:01.420Z 2026-01-29T14:42:40.974Z
9259010 9259010 20260124182227_LgoCR BE000E 2026-01-26T14:15:25.002Z 2026-01-29T14:42:25.695Z
9256229 9256229 20260124062456_G2GEa BE000E 2026-01-25T14:16:15.963Z 2026-01-29T14:48:30.139Z
9255984 9255984 20260124053502_cRSRO BE000E 2026-01-25T14:15:28.667Z 2026-01-29T14:48:16.635Z
9255915 9255915 20260124051927_yXicn BE000E 2026-01-25T14:15:09.069Z 2026-01-29T14:48:08.044Z
9255890 9255890 20260124051253_cbWn1 BE000E 2026-01-25T14:15:04.056Z 2026-01-29T14:48:03.923Z
9255838 9255838 20260124050716_6fvCg BE000E 2026-01-25T14:14:57.118Z 2026-01-29T14:48:01.139Z
9252601 9252601 20260123044051_a2zFZ BE000E 2026-01-24T14:16:25.339Z 2026-01-29T14:53:10.915Z
9252592 9252592 20260123043242_n4Gea BE000E 2026-01-24T14:16:19.818Z 2026-01-29T14:53:10.403Z
9252352 9252352 20260123022601_lnvsV BE000E 2026-01-24T14:15:14.383Z 2026-01-29T14:52:46.521Z
9252324 9252324 20260123021751_hLh5L BE000E 2026-01-24T14:15:09.048Z 2026-01-29T14:52:45.340Z
9252020 9252020 20260123003542_mqDic BE000E 2026-01-24T14:14:05.817Z 2026-01-29T14:52:24.588Z
9251972 9251972 20260123001140_0X0ZR BE000E 2026-01-24T14:13:51.354Z 2026-01-29T14:52:19.538Z
9251874 9251874 20260122234256_xTsfS BE000E 2026-01-24T14:13:28.107Z 2026-01-29T14:52:14.652Z
9249651 9249651 20260122061057_fVcWr BE000E 2026-01-23T14:15:50.642Z 2026-01-29T14:58:48.000Z
9249604 9249604 20260122060322_p2A3X BE000E 2026-01-23T14:15:46.428Z 2026-01-29T14:58:46.441Z
9249558 9249558 20260122054837_bCcoP BE000E 2026-01-23T14:15:42.471Z 2026-01-29T14:58:44.705Z
9249526 9249526 20260122053800_ybcPu BE000E 2026-01-23T14:15:38.837Z 2026-01-29T14:58:43.224Z
9249316 9249316 20260122044550_B9Pjt BE000E 2026-01-23T14:15:09.952Z 2026-01-29T14:58:25.564Z
9248530 9248530 20260122003025_2RnoW BE000E 2026-01-23T14:13:01.621Z 2026-01-29T14:57:25.264Z
9248425 9248425 20260121234256_hYHKZ BE000E 2026-01-23T14:12:46.440Z 2026-01-29T14:57:18.309Z
9248363 9248363 20260121231309_AnQ2L BE000E 2026-01-23T14:12:39.100Z 2026-01-29T14:57:15.753Z
9248271 9248271 20260121224336_krURc BE000E 2026-01-23T14:12:23.075Z 2026-01-29T14:57:11.321Z
9248170 9248170 20260121220236_ZHSh9 BE000E 2026-01-23T14:12:11.152Z 2026-01-29T14:57:06.798Z
9237901 9237901 20260120062135_Xmh2i BE000E 2026-01-21T14:28:01.426Z 2026-01-28T15:01:58.097Z
9237530 9237530 20260120053156_z23C1 BE000E 2026-01-21T14:26:52.761Z 2026-01-28T15:01:29.777Z
9236252 9236252 20260120025158_gdO3V BE000E 2026-01-21T14:22:11.227Z 2026-01-28T14:59:52.088Z
9236220 9236220 20260120024901_XZz07 BE000E 2026-01-21T14:22:00.498Z 2026-01-28T14:59:50.785Z
9235743 9235743 20260120015617_zU4XT BE000E 2026-01-21T14:20:07.920Z 2026-01-28T14:59:18.648Z
9235735 9235735 20260120015515_c07Wg BE000E 2026-01-21T14:20:06.918Z 2026-01-28T14:59:18.282Z
9235610 9235610 20260120013802_2E8Ss BE000E 2026-01-21T14:19:35.269Z 2026-01-28T14:59:12.335Z
9235601 9235601 20260120013753_Mz8Sm BE000E 2026-01-21T14:19:34.342Z 2026-01-28T14:59:11.914Z
9234878 9234878 20260119234519_QIOhG BE000E 2026-01-21T14:16:33.690Z 2026-01-28T14:58:18.548Z
9234758 9234758 20260119231809_Bnt6H BE000E 2026-01-21T14:16:00.562Z 2026-01-28T14:58:04.867Z
9234585 9234585 20260119223117_Ct7Ch BE000E 2026-01-21T14:15:12.690Z 2026-01-28T14:57:55.343Z
9234575 9234575 20260119222843_X3zSJ BE000E 2026-01-21T14:15:10.663Z 2026-01-28T14:57:54.706Z
9234303 9234303 20260119203949_R0KwJ BE000E 2026-01-21T14:13:33.734Z 2026-01-28T14:57:27.757Z
9234137 9234137 20260119194610_E1OPh BE000E 2026-01-21T14:12:30.918Z 2026-01-28T14:57:16.913Z
9228936 9228936 20260119002244_1IhkH BE000E 2026-01-20T14:20:14.088Z 2026-01-27T15:02:43.960Z
9228909 9228909 20260119001733_haUEz BE000E 2026-01-20T14:20:07.327Z 2026-01-27T15:02:42.425Z
9228892 9228892 20260119001539_tXnw0 BE000E 2026-01-20T14:20:03.278Z 2026-01-27T15:02:41.544Z
9228615 9228615 20260118231037_v5mHK BE000E 2026-01-20T14:18:38.273Z 2026-01-27T15:02:10.975Z
9228598 9228598 20260118230627_YNwNk BE000E 2026-01-20T14:18:34.289Z 2026-01-27T15:02:10.258Z
9228485 9228485 20260118223301_p3zak BE000E 2026-01-20T14:18:00.822Z 2026-01-27T15:02:03.883Z
9228151 9228151 20260118200746_Rve9S BE000E 2026-01-20T14:16:18.169Z 2026-01-27T15:01:29.892Z
9227765 9227765 20260118173534_kUlke BE000E 2026-01-20T14:13:55.220Z 2026-01-27T15:00:52.114Z
9224705 9224705 20260118054605_M3B2I BE000E 2026-01-19T14:25:39.198Z 2026-01-26T15:03:46.215Z
9224662 9224662 20260118053449_X7ybJ BE000E 2026-01-19T14:25:24.509Z 2026-01-26T15:03:44.699Z
9224633 9224633 20260118052509_D3fnD BE000E 2026-01-19T14:25:15.116Z 2026-01-26T15:03:43.050Z
9224603 9224603 20260118051913_fOuOd BE000E 2026-01-19T14:25:09.727Z 2026-01-26T15:03:34.045Z
9223378 9223378 20260118002754_ePZNl BE000E 2026-01-19T14:18:58.202Z 2026-01-26T15:02:04.514Z
9223269 9223269 20260118000253_Dr8Ew BE000E 2026-01-19T14:18:27.665Z 2026-01-26T15:02:00.467Z
9223193 9223193 20260117234134_nNU5I BE000E 2026-01-19T14:18:07.514Z 2026-01-26T15:01:57.388Z
9213351 9213351 20260116031635_Q7KjS BE000E 2026-01-17T14:16:35.416Z 2026-01-24T15:12:10.424Z
9207395 9207395 20260115012327_ERfd2 BE000E 2026-01-16T14:08:35.872Z 2026-01-22T15:03:20.758Z
9171637 9171637 20260109001240_R9hbD BE000E 2026-01-10T14:08:37.013Z 2026-01-17T15:24:12.921Z
9161999 9161999 20260106182033_BXGtU BE000E 2026-01-08T14:01:41.772Z 2026-01-13T15:01:15.827Z
9161960 9161960 20260106172813_LS2KY BE000E 2026-01-08T14:01:16.787Z 2026-01-13T15:01:09.142Z
9159580 9159580 20260106030925_UbY27 BE000E 2026-01-07T14:09:49.145Z 2026-01-13T15:08:31.911Z
9158575 9158575 20260105232540_M1tqR BE000E 2026-01-07T14:06:35.593Z 2026-01-13T15:07:30.647Z
9155791 9155791 20260104062313_wOkj0 BE000E 2026-01-06T14:38:01.420Z 2026-01-12T15:11:27.880Z
9155739 9155739 20260104061917_bONLm BE000E 2026-01-06T14:37:58.135Z 2026-01-12T15:11:26.045Z

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