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
9611440 9611440 20260405020211_rwpgH BE0005 2026-04-06T12:14:36.130Z 2026-04-06T12:16:14.800Z
9611271 9611271 20260405010905_CrTp9 BE0005 2026-04-06T12:13:48.716Z 2026-04-06T12:16:14.767Z
9611242 9611242 20260405005906_DHWmO BE0005 2026-04-06T12:13:37.718Z 2026-04-06T12:16:14.761Z
9610817 9610817 20260404220902_xSs4p BE0005 2026-04-06T12:11:30.002Z 2026-04-06T12:16:14.668Z
9610675 9610675 20260404211120_okYae BE0005 2026-04-06T12:10:41.034Z 2026-04-06T12:16:14.633Z
9604887 9604887 20260402013832_dQNtg BE0005 2026-04-03T12:12:03.161Z 2026-04-06T12:26:29.819Z
9604842 9604842 20260402011729_Fl7t2 BE0005 2026-04-03T12:11:53.624Z 2026-04-06T12:26:27.154Z
9604726 9604726 20260402000855_qBVj2 BE0005 2026-04-03T12:11:21.958Z 2026-04-06T12:26:14.276Z
9604670 9604670 20260401232507_TjB3L BE0005 2026-04-03T12:11:05.707Z 2026-04-06T12:26:10.629Z
9604666 9604666 20260401232215_eFRDM BE0005 2026-04-03T12:11:05.173Z 2026-04-06T12:26:10.428Z
9604592 9604592 20260401214918_S6SSQ BE0005 2026-04-03T12:10:48.085Z 2026-04-06T12:26:05.539Z
9604586 9604586 20260401213647_xhiEO BE0005 2026-04-03T12:10:46.971Z 2026-04-06T12:26:05.252Z
9604574 9604574 20260401210705_KCghz BE0005 2026-04-03T12:10:33.571Z 2026-04-06T12:26:02.745Z
9604562 9604562 20260401210512_ijVOF BE0005 2026-04-03T12:10:28.699Z 2026-04-06T12:26:02.137Z
9600473 9600473 20260330223855_OJbhg BE0005 2026-04-01T12:10:52.826Z 2026-04-06T12:33:27.666Z
9600415 9600415 20260330212612_LkFqR BE0005 2026-04-01T12:10:40.517Z 2026-04-06T12:33:24.277Z
9594553 9594553 20260328225806_nMT3f BE0005 2026-03-30T12:09:49.268Z 2026-04-06T12:39:57.020Z
9594248 9594248 20260328203944_C06JJ BE0005 2026-03-30T12:09:05.289Z 2026-04-06T12:39:44.805Z
9594184 9594184 20260328195223_zRZoH BE0005 2026-03-30T12:08:55.100Z 2026-04-06T12:39:41.432Z
9585656 9585656 20260327020309_styAQ BE0005 2026-03-28T12:00:57.047Z 2026-04-05T12:32:33.620Z
9579872 9579872 20260324231156_yiWxr BE0005 2026-03-26T12:14:37.287Z 2026-04-02T12:37:33.516Z
9579635 9579635 20260324220156_APKlA BE0005 2026-03-26T12:14:06.582Z 2026-04-02T12:37:18.574Z
9579517 9579517 20260324211203_Uio9d BE0005 2026-03-26T12:13:52.378Z 2026-04-02T12:37:13.494Z
9576164 9576164 20260325012738_rIsHq BE0005 2026-03-26T12:01:28.708Z 2026-04-03T12:35:46.972Z
9575991 9575991 20260325005527_7U1E7 BE0005 2026-03-26T12:00:53.747Z 2026-04-03T12:35:40.031Z
9575952 9575952 20260325005032_BQ0x8 BE0005 2026-03-26T12:00:49.106Z 2026-04-03T12:35:30.948Z
9575609 9575609 20260323234154_K3LtU BE0005 2026-03-25T12:21:30.726Z 2026-03-31T12:29:03.024Z
9575378 9575378 20260323213504_X1IHx BE0005 2026-03-25T12:20:58.087Z 2026-03-31T12:28:56.286Z
9571094 9571094 20260322234503_KNmgJ BE0005 2026-03-24T12:24:20.262Z 2026-03-30T12:30:55.149Z
9570827 9570827 20260322225746_oM2f7 BE0005 2026-03-24T12:23:52.645Z 2026-03-30T12:30:50.026Z
9570749 9570749 20260322224005_SH1IN BE0005 2026-03-24T12:23:46.479Z 2026-03-30T12:30:48.739Z
9570497 9570497 20260322214059_BhieV BE0005 2026-03-24T12:23:22.138Z 2026-03-30T12:30:44.339Z
9570434 9570434 20260322212141_IzCbf BE0005 2026-03-24T12:23:17.039Z 2026-03-30T12:30:43.080Z
9570170 9570170 20260322193612_XInEJ BE0005 2026-03-24T12:22:44.980Z 2026-03-30T12:30:29.024Z
9562985 9562985 20260323042217_p4GV4 BE0005 2026-03-24T12:04:39.450Z 2026-03-31T12:26:31.619Z
9562952 9562952 20260323040702_Qd8Ls BE0005 2026-03-24T12:04:34.192Z 2026-03-31T12:26:30.765Z
9562924 9562924 20260323035034_tApwR BE0005 2026-03-24T12:04:28.907Z 2026-03-31T12:26:29.558Z
9562801 9562801 20260323031643_8ND4G BE0005 2026-03-24T12:04:07.027Z 2026-03-31T12:26:26.385Z
9562773 9562773 20260323031314_Hm4W7 BE0005 2026-03-24T12:04:01.059Z 2026-03-31T12:26:25.702Z
9562726 9562726 20260323030603_GItpj BE0005 2026-03-24T12:03:52.527Z 2026-03-31T12:26:24.209Z
9562603 9562603 20260323024617_i93BF BE0005 2026-03-24T12:03:32.867Z 2026-03-31T12:26:15.499Z
9562538 9562538 20260323023120_3xYL4 BE0005 2026-03-24T12:03:21.766Z 2026-03-31T12:26:13.661Z
9562395 9562395 20260323021646_fOCzZ BE0005 2026-03-24T12:02:59.096Z 2026-03-31T12:26:09.291Z
9562316 9562316 20260323020759_L2HQk BE0005 2026-03-24T12:02:49.019Z 2026-03-31T12:26:07.631Z
9561836 9561836 20260323004928_eIDRF BE0005 2026-03-24T12:01:26.715Z 2026-03-31T12:25:54.831Z
9561422 9561422 20260321233147_yNAPw BE0005 2026-03-23T12:12:18.790Z 2026-03-29T12:21:07.141Z
9561210 9561210 20260321230906_ybUYw BE0005 2026-03-23T12:12:13.918Z 2026-03-29T12:21:05.724Z
9561103 9561103 20260321230118_YmuKo BE0005 2026-03-23T12:12:11.765Z 2026-03-29T12:21:05.202Z
9560901 9560901 20260321223402_3m9HC BE0005 2026-03-23T12:12:06.900Z 2026-03-29T12:21:03.834Z
9560632 9560632 20260321215302_AO5mQ BE0005 2026-03-23T12:11:59.881Z 2026-03-29T12:21:01.853Z
9560369 9560369 20260321210633_xQoHV BE0005 2026-03-23T12:11:44.417Z 2026-03-29T12:20:59.650Z
9560270 9560270 20260321205521_vAIvy BE0005 2026-03-23T12:11:40.962Z 2026-03-29T12:20:58.859Z
9560195 9560195 20260321204652_YRSEA BE0005 2026-03-23T12:11:40.181Z 2026-03-29T12:20:58.556Z
9559926 9559926 20260321201124_ltnjI BE0005 2026-03-23T12:11:34.033Z 2026-03-29T12:20:56.674Z
9559736 9559736 20260321193656_bB0gT BE0005 2026-03-23T12:11:28.587Z 2026-03-29T12:20:48.523Z
9554868 9554868 20260322033957_UjP5j BE0005 2026-03-23T12:02:53.942Z 2026-03-30T12:28:10.652Z
9554431 9554431 20260322030711_QLUy9 BE0005 2026-03-23T12:02:31.812Z 2026-03-30T12:28:03.741Z
9553064 9553064 20260322010853_PBRag BE0005 2026-03-23T12:01:11.431Z 2026-03-30T12:27:34.310Z
9552992 9552992 20260322010154_kP6qq BE0005 2026-03-23T12:01:08.019Z 2026-03-30T12:27:33.498Z
9552671 9552671 20260322002943_UQ9MV BE0005 2026-03-23T12:00:41.869Z 2026-03-24T12:24:26.877Z
9552163 9552163 20260320230937_uRfYL BE0005 2026-03-22T12:27:30.535Z 2026-03-28T12:37:07.541Z
9552052 9552052 20260320224456_xD1W8 BE0005 2026-03-22T12:27:24.787Z 2026-03-28T12:37:06.143Z
9551956 9551956 20260320222318_vWgTh BE0005 2026-03-22T12:27:19.395Z 2026-03-28T12:37:04.913Z
9551476 9551476 20260320195534_WU4dM BE0005 2026-03-22T12:26:42.864Z 2026-03-28T12:36:55.063Z
9542986 9542986 20260321021303_bC7sF BE0005 2026-03-22T12:02:16.891Z 2026-03-29T12:19:00.990Z
9542901 9542901 20260321014744_I12Rv BE0005 2026-03-22T12:01:57.751Z 2026-03-29T12:18:59.760Z
9542754 9542754 20260321011807_pAvv0 BE0005 2026-03-22T12:01:31.674Z 2026-03-29T12:18:57.953Z
9542501 9542501 20260320235355_rOJxw BE0005 2026-03-22T12:00:29.008Z 2026-03-29T12:18:44.765Z
9542437 9542437 20260320233735_Hnd5x BE0005 2026-03-22T12:00:15.557Z 2026-03-29T12:18:44.016Z
9541397 9541397 20260319203126_63oWd BE0005 2026-03-21T12:28:53.845Z 2026-03-27T12:42:37.237Z
9541365 9541365 20260319202258_h2oEo BE0005 2026-03-21T12:28:51.860Z 2026-03-27T12:42:36.941Z
9541034 9541034 20260319190827_6c6i4 BE0005 2026-03-21T12:28:25.270Z 2026-03-27T12:42:33.319Z
9534758 9534758 20260320041836_sNwG5 BE0005 2026-03-21T12:08:48.752Z 2026-03-28T12:34:21.715Z
9534527 9534527 20260320035740_X4r1K BE0005 2026-03-21T12:08:12.939Z 2026-03-28T12:34:19.125Z
9534459 9534459 20260320035120_ZIbZU BE0005 2026-03-21T12:08:03.879Z 2026-03-28T12:34:18.545Z
9534085 9534085 20260320032223_Nv3Fs BE0005 2026-03-21T12:07:07.523Z 2026-03-28T12:34:11.728Z
9534078 9534078 20260320032146_epK6D BE0005 2026-03-21T12:07:07.051Z 2026-03-28T12:34:10.908Z
9533889 9533889 20260320030702_AZQUp BE0005 2026-03-21T12:06:33.500Z 2026-03-28T12:34:01.903Z
9533864 9533864 20260320030653_ySzvf BE0005 2026-03-21T12:06:31.060Z 2026-03-28T12:34:01.736Z
9533559 9533559 20260320024303_0uMOi BE0005 2026-03-21T12:05:44.481Z 2026-03-28T12:33:56.126Z
9533283 9533283 20260320022149_92mWz BE0005 2026-03-21T12:05:03.890Z 2026-03-28T12:33:51.510Z
9533257 9533257 20260320021911_P3JZD BE0005 2026-03-21T12:04:57.781Z 2026-03-28T12:33:51.132Z
9533229 9533229 20260320021724_N3SaY BE0005 2026-03-21T12:04:52.712Z 2026-03-28T12:33:50.786Z
9533124 9533124 20260320020328_HOExB BE0005 2026-03-21T12:04:31.954Z 2026-03-28T12:33:49.111Z
9532382 9532382 20260320004954_cucGR BE0005 2026-03-21T12:02:32.749Z 2026-03-28T12:33:29.084Z
9532151 9532151 20260320002340_dhJM9 BE0005 2026-03-21T12:01:51.544Z 2026-03-28T12:33:24.979Z
9531692 9531692 20260319233633_0OhXo BE0005 2026-03-21T12:00:29.859Z 2026-03-28T12:33:20.260Z
9531358 9531358 20260318230035_pSKYb BE0005 2026-03-20T12:25:08.223Z 2026-03-26T12:39:19.039Z
9531088 9531088 20260318222529_5T8K8 BE0005 2026-03-20T12:24:57.228Z 2026-03-26T12:39:17.393Z
9530873 9530873 20260318215652_2BFpM BE0005 2026-03-20T12:24:50.510Z 2026-03-26T12:39:16.351Z
9530529 9530529 20260318210455_vK0dU BE0005 2026-03-20T12:24:28.081Z 2026-03-26T12:39:13.382Z
9530168 9530168 20260318202000_xT7c9 BE0005 2026-03-20T12:24:04.872Z 2026-03-26T12:39:10.060Z
9529937 9529937 20260318194353_Ussq1 BE0005 2026-03-20T12:23:50.560Z 2026-03-26T12:39:07.657Z
9529786 9529786 20260318193048_dwWkk BE0005 2026-03-20T12:23:39.052Z 2026-03-26T12:39:06.564Z
9521716 9521716 20260319043613_0FKxV BE0005 2026-03-20T12:08:26.397Z 2026-03-27T12:41:04.962Z
9521489 9521489 20260319042114_TZwOX BE0005 2026-03-20T12:08:07.995Z 2026-03-27T12:40:55.231Z
9520764 9520764 20260319033518_m5z7a BE0005 2026-03-20T12:06:56.342Z 2026-03-27T12:40:47.186Z
9519698 9519698 20260319023021_28usz BE0005 2026-03-20T12:04:56.950Z 2026-03-27T12:40:34.558Z
9519263 9519263 20260319015737_A3ES1 BE0005 2026-03-20T12:04:13.213Z 2026-03-27T12:40:19.707Z
9519242 9519242 20260319015705_UQWP3 BE0005 2026-03-20T12:04:10.082Z 2026-03-27T12:40:19.496Z

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