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,022 rows where station_code = "BE0009" 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
9271874 9271874 20260127212449_H81Jq BE0009 2026-01-29T14:24:42.203Z 2026-01-29T14:30:25.217Z
9262586 9262586 20260125203033_wUkGe BE0009 2026-01-27T14:13:52.080Z 2026-01-29T14:38:21.717Z
9260352 9260352 20260125035409_wxmCF BE0009 2026-01-26T14:21:22.286Z 2026-01-29T14:44:07.415Z
9260330 9260330 20260125034643_IQZtV BE0009 2026-01-26T14:21:18.847Z 2026-01-29T14:44:06.172Z
9260243 9260243 20260125031511_tdxNk BE0009 2026-01-26T14:20:55.952Z 2026-01-29T14:44:01.943Z
9259897 9259897 20260125010538_DxENJ BE0009 2026-01-26T14:19:13.706Z 2026-01-29T14:43:34.169Z
9259855 9259855 20260125005007_dcHWb BE0009 2026-01-26T14:18:55.182Z 2026-01-29T14:43:25.787Z
9259774 9259774 20260125000414_LpjAR BE0009 2026-01-26T14:18:33.515Z 2026-01-29T14:43:18.637Z
9259713 9259713 20260124233654_lNIVC BE0009 2026-01-26T14:18:11.685Z 2026-01-29T14:43:14.743Z
9259585 9259585 20260124214645_AWhT8 BE0009 2026-01-26T14:17:32.112Z 2026-01-29T14:43:07.611Z
9259422 9259422 20260124204509_x2Hqx BE0009 2026-01-26T14:16:58.160Z 2026-01-29T14:42:54.169Z
9258914 9258914 20260124175822_CzaMo BE0009 2026-01-26T14:15:01.074Z 2026-01-29T14:42:19.197Z
9258851 9258851 20260124173731_UK1TX BE0009 2026-01-26T14:14:48.835Z 2026-01-29T14:42:15.131Z
9255874 9255874 20260124051121_G7x4s BE0009 2026-01-25T14:15:01.838Z 2026-01-29T14:48:02.760Z
9255731 9255731 20260124044055_ZJ4uV BE0009 2026-01-25T14:14:30.115Z 2026-01-29T14:47:54.125Z
9255685 9255685 20260124042945_GwEjq BE0009 2026-01-25T14:14:19.888Z 2026-01-29T14:47:51.077Z
9255529 9255529 20260124040406_GTaDO BE0009 2026-01-25T14:13:51.830Z 2026-01-29T14:47:36.454Z
9255519 9255519 20260124040036_lOVlq BE0009 2026-01-25T14:13:45.883Z 2026-01-29T14:47:35.710Z
9255454 9255454 20260124034159_SAmsY BE0009 2026-01-25T14:13:30.562Z 2026-01-29T14:47:31.794Z
9255445 9255445 20260124033648_xkX8Y BE0009 2026-01-25T14:13:29.345Z 2026-01-29T14:47:31.400Z
9255440 9255440 20260124033600_0HU8T BE0009 2026-01-25T14:13:28.180Z 2026-01-29T14:47:31.084Z
9255417 9255417 20260124032758_n6uTw BE0009 2026-01-25T14:13:19.184Z 2026-01-29T14:47:29.487Z
9255410 9255410 20260124032426_dcZXS BE0009 2026-01-25T14:13:16.707Z 2026-01-29T14:47:28.954Z
9255289 9255289 20260124023723_Xzvlg BE0009 2026-01-25T14:12:42.677Z 2026-01-29T14:47:21.229Z
9254793 9254793 20260123212411_Sidw2 BE0009 2026-01-25T14:10:46.515Z 2026-01-29T14:46:43.041Z
9254698 9254698 20260123204742_iiDmm BE0009 2026-01-25T14:10:24.231Z 2026-01-29T14:46:36.465Z
9254687 9254687 20260123204534_w6ky9 BE0009 2026-01-25T14:10:22.387Z 2026-01-29T14:46:35.904Z
9254620 9254620 20260123203101_rmhbu BE0009 2026-01-25T14:10:05.216Z 2026-01-29T14:46:32.784Z
9252363 9252363 20260123022814_z6d1v BE0009 2026-01-24T14:15:16.096Z 2026-01-29T14:52:46.957Z
9252336 9252336 20260123022216_8lOcw BE0009 2026-01-24T14:15:11.564Z 2026-01-29T14:52:45.875Z
9252313 9252313 20260123021333_yfzty BE0009 2026-01-24T14:15:05.754Z 2026-01-29T14:52:44.853Z
9252217 9252217 20260123014818_MAkdM BE0009 2026-01-24T14:14:46.768Z 2026-01-29T14:52:40.372Z
9252200 9252200 20260123014012_rT3u2 BE0009 2026-01-24T14:14:43.224Z 2026-01-29T14:52:39.080Z
9252189 9252189 20260123014011_12Xx4 BE0009 2026-01-24T14:14:42.719Z 2026-01-29T14:52:38.895Z
9252182 9252182 20260123013439_RLHKU BE0009 2026-01-24T14:14:40.918Z 2026-01-29T14:52:38.462Z
9252127 9252127 20260123010656_4brFN BE0009 2026-01-24T14:14:25.284Z 2026-01-29T14:52:34.999Z
9252014 9252014 20260123003012_RDG2G BE0009 2026-01-24T14:14:04.764Z 2026-01-29T14:52:24.247Z
9249660 9249660 20260122061505_nemHp BE0009 2026-01-23T14:15:51.425Z 2026-01-29T14:58:48.379Z
9249090 9249090 20260122033349_wTULI BE0009 2026-01-23T14:14:34.142Z 2026-01-29T14:58:12.353Z
9248295 9248295 20260121224851_D9Jyi BE0009 2026-01-23T14:12:25.963Z 2026-01-29T14:57:12.816Z
9237786 9237786 20260120060458_ALM6t BE0009 2026-01-21T14:27:38.638Z 2026-01-28T15:01:42.230Z
9235084 9235084 20260120002509_r3Mgr BE0009 2026-01-21T14:17:27.521Z 2026-01-28T14:58:30.128Z
9230955 9230955 20260119053255_3SfaR BE0009 2026-01-20T14:30:36.416Z 2026-01-27T15:05:49.837Z
9230854 9230854 20260119051859_Xdlpo BE0009 2026-01-20T14:30:06.498Z 2026-01-27T15:05:33.063Z
9228389 9228389 20260118220523_ramFw BE0009 2026-01-20T14:17:33.784Z 2026-01-27T15:01:58.368Z
9223816 9223816 20260118022614_4UVyg BE0009 2026-01-19T14:21:16.195Z 2026-01-26T15:02:37.046Z
9223622 9223622 20260118014731_LGjpq BE0009 2026-01-19T14:20:18.185Z 2026-01-26T15:02:29.792Z
9223467 9223467 20260118005031_rUGf8 BE0009 2026-01-19T14:19:28.150Z 2026-01-26T15:02:08.044Z
9223291 9223291 20260118000704_GdiJD BE0009 2026-01-19T14:18:35.540Z 2026-01-26T15:02:01.212Z
9222741 9222741 20260117203633_Ym5WM BE0009 2026-01-19T14:16:05.200Z 2026-01-26T15:01:19.319Z
9195437 9195437 20260113012544_RD0g6 BE0009 2026-01-14T14:13:17.752Z 2026-01-21T15:04:40.513Z
9195346 9195346 20260113011021_vdour BE0009 2026-01-14T14:13:01.308Z 2026-01-21T15:04:39.362Z
9195244 9195244 20260113004621_5tSVr BE0009 2026-01-14T14:12:35.399Z 2026-01-21T15:04:37.978Z
9194862 9194862 20260112230638_t2Bwe BE0009 2026-01-14T14:11:03.750Z 2026-01-21T15:04:33.360Z
9194842 9194842 20260112230519_H1xpu BE0009 2026-01-14T14:10:54.959Z 2026-01-21T15:04:29.177Z
9182330 9182330 20260111050216_WdWyK BE0009 2026-01-12T14:14:10.798Z 2026-01-19T15:18:26.512Z
9166916 9166916 20260107210011_5PVR6 BE0009 2026-01-09T14:05:28.467Z 2026-01-16T15:10:30.157Z
9160049 9160049 20260106043515_y1ekK BE0009 2026-01-07T14:11:11.616Z 2026-01-13T15:08:58.048Z
9159777 9159777 20260106034345_vjWdv BE0009 2026-01-07T14:10:22.122Z 2026-01-13T15:08:44.240Z
9159384 9159384 20260106023120_9ZUvv BE0009 2026-01-07T14:09:11.685Z 2026-01-13T15:08:23.469Z
9158715 9158715 20260106000920_2zIdN BE0009 2026-01-07T14:07:03.259Z 2026-01-13T15:07:43.520Z
9158412 9158412 20260105222250_9XduB BE0009 2026-01-07T14:05:59.952Z 2026-01-13T15:07:20.985Z
9150344 9150344 20260105015338_ghouL BE0009 2026-01-06T14:09:41.412Z 2026-01-13T15:13:19.617Z
9150190 9150190 20260105012806_1OA5O BE0009 2026-01-06T14:09:01.022Z 2026-01-13T15:13:10.125Z
9150082 9150082 20260105005843_5cKjO BE0009 2026-01-06T14:08:29.571Z 2026-01-13T15:13:03.442Z
9149691 9149691 20260104225753_cmFlP BE0009 2026-01-06T14:06:41.050Z 2026-01-13T15:12:33.972Z
9149299 9149299 20260104200145_lDJRb BE0009 2026-01-06T14:04:53.296Z 2026-01-13T15:11:56.083Z
9149286 9149286 20260104195819_jlvIl BE0009 2026-01-06T14:04:50.419Z 2026-01-13T15:11:55.396Z
9149112 9149112 20260104184941_eCPJd BE0009 2026-01-06T14:03:50.133Z 2026-01-13T15:11:42.852Z
9149083 9149083 20260104184134_LWdFI BE0009 2026-01-06T14:03:42.116Z 2026-01-13T15:11:41.236Z
9149052 9149052 20260104183707_2jHWu BE0009 2026-01-06T14:03:37.004Z 2026-01-13T15:11:39.948Z
9148969 9148969 20260104181833_m98OB BE0009 2026-01-06T14:03:16.458Z 2026-01-13T15:11:33.514Z
9145345 9145345 20260104031441_gc2Yu BE0009 2026-01-05T14:20:27.910Z 2026-01-12T15:07:46.914Z
9145100 9145100 20260104030501_324xi BE0009 2026-01-05T14:20:11.909Z 2026-01-12T15:07:41.640Z
9144855 9144855 20260104025651_62Lmh BE0009 2026-01-05T14:19:38.729Z 2026-01-12T15:07:18.628Z
9144383 9144383 20260104024228_5bxPT BE0009 2026-01-05T14:18:59.545Z 2026-01-12T15:07:05.683Z
9143947 9143947 20260104022941_8WTx9 BE0009 2026-01-05T14:18:27.466Z 2026-01-12T15:06:55.620Z
9143800 9143800 20260104022406_bGul3 BE0009 2026-01-05T14:18:06.737Z 2026-01-12T15:06:33.907Z
9143154 9143154 20260104015741_sWAmv BE0009 2026-01-05T14:17:04.584Z 2026-01-12T15:06:15.419Z
9142283 9142283 20260104012932_o9cop BE0009 2026-01-05T14:15:47.431Z 2026-01-12T15:05:39.136Z
9142007 9142007 20260104011750_gBC7r BE0009 2026-01-05T14:15:27.768Z 2026-01-12T15:05:17.830Z
9141947 9141947 20260104011540_byufk BE0009 2026-01-05T14:15:24.004Z 2026-01-12T15:05:16.033Z
9141471 9141471 20260104005646_3bWOK BE0009 2026-01-05T14:14:42.119Z 2026-01-12T15:05:02.242Z
9140922 9140922 20260104003511_Xhf4t BE0009 2026-01-05T14:13:47.403Z 2026-01-12T15:04:34.132Z
9138227 9138227 20260103221136_yisjh BE0009 2026-01-05T14:09:42.168Z 2026-01-12T15:02:43.756Z
9138162 9138162 20260103220510_XN15e BE0009 2026-01-05T14:09:27.572Z 2026-01-12T15:02:41.718Z
9138005 9138005 20260103215423_gnuxZ BE0009 2026-01-05T14:09:17.503Z 2026-01-12T15:02:27.730Z
9137443 9137443 20260103211322_Qiwzp BE0009 2026-01-05T14:08:30.768Z 2026-01-12T15:02:11.400Z
9130070 9130070 20260103015855_el752 BE0009 2026-01-04T14:08:12.161Z 2026-01-10T14:58:37.102Z
9130065 9130065 20260103015853_wyY7Q BE0009 2026-01-04T14:08:08.901Z 2026-01-10T14:58:36.228Z
9129854 9129854 20260103010755_mOFiT BE0009 2026-01-04T14:06:49.788Z 2026-01-10T14:58:20.355Z
9129751 9129751 20260103002751_KyYl0 BE0009 2026-01-04T14:06:12.463Z 2026-01-10T14:58:11.002Z
9129679 9129679 20260103000249_DrFXh BE0009 2026-01-04T14:05:28.765Z 2026-01-10T14:58:05.231Z
9129632 9129632 20260102233042_h7Ac8 BE0009 2026-01-04T14:05:09.714Z 2026-01-10T14:57:58.852Z
9123928 9123928 20251231040832_ALRp1 BE0009 2026-01-02T14:38:28.163Z 2026-01-08T15:09:39.652Z
9123536 9123536 20251231015340_7wuqm BE0009 2026-01-02T14:30:20.475Z 2026-01-08T15:07:10.990Z
9123530 9123530 20251231015340_R2uhg BE0009 2026-01-02T14:30:19.594Z 2026-01-08T15:07:10.730Z
9121590 9121590 20260101002030_3f3nn BE0009 2026-01-02T14:08:12.498Z 2026-01-09T14:52:21.439Z
9121588 9121588 20260101001546_Sk7YH BE0009 2026-01-02T14:08:11.236Z 2026-01-09T14:52:21.208Z
9119679 9119679 20251230183918_BhZLZ BE0009 2026-01-01T14:56:48.537Z 2026-01-07T15:13:01.012Z

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