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

1,084 rows where station_code = "BE001A" 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
8687117 8687117 20251204044101_1MG5t BE001A 2025-12-05T14:13:55.506Z 2025-12-05T14:14:35.624Z
8687109 8687109 20251204043613_J78XV BE001A 2025-12-05T14:13:54.665Z 2025-12-05T14:14:35.621Z
8687097 8687097 20251204035011_vUmVP BE001A 2025-12-05T14:13:52.772Z 2025-12-05T14:14:35.618Z
8687093 8687093 20251204033839_3ycFm BE001A 2025-12-05T14:13:52.078Z 2025-12-05T14:14:35.615Z
8653482 8653482 20251130021818_26sLn BE001A 2025-12-01T14:23:34.024Z 2025-12-05T14:43:32.502Z
8645611 8645611 20251128230446_8l5Af BE001A 2025-11-30T14:24:16.459Z 2025-12-05T14:50:57.285Z
8645463 8645463 20251128221904_sZ9Vh BE001A 2025-11-30T14:23:46.354Z 2025-12-05T14:50:39.519Z
8623529 8623529 20251127005848_zrHrX BE001A 2025-11-28T14:22:06.194Z 2025-12-05T15:03:58.554Z
8623525 8623525 20251127005847_H51rk BE001A 2025-11-28T14:22:06.065Z 2025-12-05T15:03:58.531Z
8623383 8623383 20251127001936_Xh5S3 BE001A 2025-11-28T14:21:37.181Z 2025-12-05T15:03:45.654Z
8622024 8622024 20251126173224_fyezz BE001A 2025-11-28T14:17:29.176Z 2025-12-05T15:02:50.807Z
8621974 8621974 20251126172051_1n4TP BE001A 2025-11-28T14:17:11.601Z 2025-12-05T15:02:50.141Z
8608153 8608153 20251125215218_222eh BE001A 2025-11-27T14:15:27.716Z 2025-12-04T15:07:41.661Z
8608080 8608080 20251125214812_g5Rj5 BE001A 2025-11-27T14:15:16.035Z 2025-12-04T15:07:40.947Z
8607954 8607954 20251125214011_b6Hov BE001A 2025-11-27T14:14:59.630Z 2025-12-04T15:07:39.518Z
8607356 8607356 20251125204344_QS1hV BE001A 2025-11-27T14:13:27.611Z 2025-12-04T15:07:01.130Z
8607181 8607181 20251125202430_Be7Oa BE001A 2025-11-27T14:12:40.605Z 2025-12-04T15:06:56.125Z
8600166 8600166 20251125024628_CIRzQ BE001A 2025-11-26T14:22:05.759Z 2025-12-02T15:08:34.976Z
8600158 8600158 20251125024627_n1g4k BE001A 2025-11-26T14:22:05.557Z 2025-12-02T15:08:34.966Z
8591642 8591642 20251124043949_8JWuz BE001A 2025-11-25T14:24:41.926Z 2025-12-02T15:12:59.778Z
8591635 8591635 20251124043815_Deave BE001A 2025-11-25T14:24:40.925Z 2025-12-02T15:12:59.744Z
8591237 8591237 20251124035421_EtRj2 BE001A 2025-11-25T14:23:46.673Z 2025-12-02T15:12:57.526Z
8590480 8590480 20251124024509_Z33TS BE001A 2025-11-25T14:22:06.369Z 2025-12-02T15:12:48.650Z
8590333 8590333 20251124023527_3N2BI BE001A 2025-11-25T14:21:43.830Z 2025-12-02T15:12:46.929Z
8590094 8590094 20251124022151_hgbvm BE001A 2025-11-25T14:21:22.508Z 2025-12-02T15:12:42.240Z
8580708 8580708 20251121230736_0hFPm BE001A 2025-11-24T14:22:37.000Z 2025-11-30T15:05:29.949Z
8571791 8571791 20251121220834_UuMQg BE001A 2025-11-23T14:37:43.998Z 2025-11-30T15:05:18.940Z
8571306 8571306 20251121201139_hXMLU BE001A 2025-11-23T14:36:09.657Z 2025-11-30T15:04:53.562Z
8571035 8571035 20251121184004_YQ22t BE001A 2025-11-23T14:35:54.520Z 2025-11-30T15:04:24.037Z
8570866 8570866 20251121174149_f2pEo BE001A 2025-11-23T14:35:03.608Z 2025-11-30T15:03:56.939Z
8450742 8450742 20251113051400_2RFh9 BE001A 2025-11-14T14:24:08.796Z 2025-11-21T15:12:50.631Z
8450714 8450714 20251113050904_TYJzZ BE001A 2025-11-14T14:24:06.282Z 2025-11-21T15:12:48.054Z
8450689 8450689 20251113050647_XLBzh BE001A 2025-11-14T14:24:04.508Z 2025-11-21T15:12:47.773Z
8450043 8450043 20251113033927_WWDoi BE001A 2025-11-14T14:22:25.978Z 2025-11-21T15:12:27.400Z
8450038 8450038 20251113033818_pr77S BE001A 2025-11-14T14:22:25.415Z 2025-11-21T15:12:27.358Z
8449578 8449578 20251113022457_OntxI BE001A 2025-11-14T14:20:55.685Z 2025-11-21T15:12:09.069Z
8449475 8449475 20251113021303_vSDlV BE001A 2025-11-14T14:20:28.956Z 2025-11-21T15:12:04.707Z
8449448 8449448 20251113020945_RzaZ8 BE001A 2025-11-14T14:20:26.016Z 2025-11-21T15:12:03.356Z
8449388 8449388 20251113020119_Dh8O2 BE001A 2025-11-14T14:20:20.070Z 2025-11-21T15:11:59.229Z
8449037 8449037 20251113010741_UewAK BE001A 2025-11-14T14:19:16.670Z 2025-11-21T15:11:46.189Z
8448879 8448879 20251113003817_3xfwO BE001A 2025-11-14T14:18:49.374Z 2025-11-21T15:11:40.426Z
8448673 8448673 20251112235625_XRoqr BE001A 2025-11-14T14:18:06.848Z 2025-11-21T15:11:36.493Z
8448670 8448670 20251112235521_plILc BE001A 2025-11-14T14:18:06.589Z 2025-11-21T15:11:36.324Z
8448636 8448636 20251112235017_LEvv6 BE001A 2025-11-14T14:18:03.826Z 2025-11-21T15:11:35.773Z
8442447 8442447 20251110232817_2ZHOP BE001A 2025-11-13T14:44:58.297Z 2025-11-19T15:16:00.724Z
8439277 8439277 20251112033203_UBxql BE001A 2025-11-13T14:26:01.736Z 2025-11-20T15:25:14.061Z
8439241 8439241 20251112032913_ObY2t BE001A 2025-11-13T14:25:58.516Z 2025-11-20T15:25:13.521Z
8438119 8438119 20251112012607_m7hoQ BE001A 2025-11-13T14:22:55.072Z 2025-11-20T15:24:15.247Z
8436017 8436017 20251111204118_BO99s BE001A 2025-11-13T14:16:59.632Z 2025-11-20T15:22:38.966Z
8435743 8435743 20251111200744_9PWri BE001A 2025-11-13T14:16:17.882Z 2025-11-20T15:22:31.490Z
8434850 8434850 20251111184947_3ar5l BE001A 2025-11-13T14:13:48.652Z 2025-11-20T15:21:52.382Z
8434400 8434400 20251111181128_LZR3y BE001A 2025-11-13T14:12:40.265Z 2025-11-20T15:21:38.752Z
8427508 8427508 20251111044839_ircOd BE001A 2025-11-12T14:28:20.085Z 2025-11-19T15:17:54.655Z
8427280 8427280 20251111042338_Uut9x BE001A 2025-11-12T14:27:36.620Z 2025-11-19T15:17:49.528Z
8427266 8427266 20251111042250_G92je BE001A 2025-11-12T14:27:32.661Z 2025-11-19T15:17:48.780Z
8427219 8427219 20251111041546_DU7mU BE001A 2025-11-12T14:27:28.620Z 2025-11-19T15:17:48.075Z
8427036 8427036 20251111040148_ulhDB BE001A 2025-11-12T14:27:07.432Z 2025-11-19T15:17:41.531Z
8427026 8427026 20251111040059_gHKQg BE001A 2025-11-12T14:27:06.333Z 2025-11-19T15:17:40.869Z
8426745 8426745 20251111033827_M9QI6 BE001A 2025-11-12T14:26:17.865Z 2025-11-19T15:17:25.443Z
8426697 8426697 20251111033440_JiKJS BE001A 2025-11-12T14:26:02.287Z 2025-11-19T15:17:24.628Z
8423814 8423814 20251110233408_dsK2e BE001A 2025-11-12T14:19:04.893Z 2025-11-19T15:16:03.385Z
8413296 8413296 20251109225716_IeMWd BE001A 2025-11-11T14:16:47.680Z 2025-11-18T15:20:20.082Z
8413253 8413253 20251109224228_ws67m BE001A 2025-11-11T14:16:40.733Z 2025-11-18T15:20:19.811Z
8412915 8412915 20251109211839_EJ7cR BE001A 2025-11-11T14:15:32.414Z 2025-11-18T15:20:16.484Z
8412784 8412784 20251109205819_y0gCh BE001A 2025-11-11T14:15:07.788Z 2025-11-18T15:20:15.310Z
8412359 8412359 20251109201235_42KRq BE001A 2025-11-11T14:13:44.098Z 2025-11-18T15:20:10.190Z
8411655 8411655 20251109191044_LQhhz BE001A 2025-11-11T14:11:37.050Z 2025-11-18T15:19:49.605Z
8397776 8397776 20251108023735_eZamD BE001A 2025-11-09T14:13:13.826Z 2025-11-16T15:04:27.420Z
8392250 8392250 20251107050324_WuQzw BE001A 2025-11-08T14:17:38.677Z 2025-11-15T15:00:43.492Z
8392187 8392187 20251107045335_vCIzD BE001A 2025-11-08T14:17:28.288Z 2025-11-15T15:00:43.122Z
8392162 8392162 20251107044853_wmNzX BE001A 2025-11-08T14:17:14.514Z 2025-11-15T15:00:42.772Z
8392044 8392044 20251107042509_vWhZH BE001A 2025-11-08T14:16:58.233Z 2025-11-15T15:00:41.502Z
8391876 8391876 20251107035634_tH6Xm BE001A 2025-11-08T14:16:18.577Z 2025-11-15T15:00:39.723Z
8391841 8391841 20251107035405_UHwr3 BE001A 2025-11-08T14:16:13.455Z 2025-11-15T15:00:38.892Z
8391762 8391762 20251107034559_tTmMH BE001A 2025-11-08T14:15:56.654Z 2025-11-15T15:00:37.185Z
8391619 8391619 20251107032120_XO829 BE001A 2025-11-08T14:15:24.081Z 2025-11-15T15:00:33.708Z
8391514 8391514 20251107030123_lxec2 BE001A 2025-11-08T14:15:09.289Z 2025-11-15T15:00:32.450Z
8391476 8391476 20251107025616_6xjAH BE001A 2025-11-08T14:14:52.867Z 2025-11-15T15:00:29.669Z
8391446 8391446 20251107025137_JtK1K BE001A 2025-11-08T14:14:47.649Z 2025-11-15T15:00:29.154Z
8391431 8391431 20251107024845_b0Bug BE001A 2025-11-08T14:14:44.275Z 2025-11-15T15:00:29.111Z
8391414 8391414 20251107024747_OEcvs BE001A 2025-11-08T14:14:43.543Z 2025-11-15T15:00:29.056Z
8391383 8391383 20251107024251_NuTJp BE001A 2025-11-08T14:14:39.528Z 2025-11-15T15:00:28.558Z
8391353 8391353 20251107024128_0bT7d BE001A 2025-11-08T14:14:36.349Z 2025-11-15T15:00:28.097Z
8391295 8391295 20251107023207_dg3UC BE001A 2025-11-08T14:14:27.855Z 2025-11-15T15:00:25.896Z
8391068 8391068 20251107020353_BgRGB BE001A 2025-11-08T14:13:27.940Z 2025-11-15T15:00:18.551Z
8391022 8391022 20251107015731_xLJ2U BE001A 2025-11-08T14:13:19.372Z 2025-11-15T15:00:17.608Z
8390789 8390789 20251107012237_mzMXd BE001A 2025-11-08T14:12:19.117Z 2025-11-15T15:00:10.992Z
8390754 8390754 20251107011707_y2aGh BE001A 2025-11-08T14:12:09.100Z 2025-11-15T15:00:10.071Z
8390621 8390621 20251107005724_zldLR BE001A 2025-11-08T14:11:40.338Z 2025-11-15T15:00:07.553Z
8390561 8390561 20251107005116_L1e2u BE001A 2025-11-08T14:11:28.685Z 2025-11-15T15:00:04.605Z
8390452 8390452 20251107003339_iL57I BE001A 2025-11-08T14:10:57.722Z 2025-11-15T15:00:02.553Z
8386124 8386124 20251106024107_uUrVw BE001A 2025-11-07T14:09:42.047Z 2025-11-14T15:08:36.037Z
8386030 8386030 20251106021909_aKph0 BE001A 2025-11-07T14:09:20.607Z 2025-11-14T15:08:32.878Z
8386027 8386027 20251106021838_n9v2Q BE001A 2025-11-07T14:09:19.912Z 2025-11-14T15:08:32.575Z
8385995 8385995 20251106021201_NtiY1 BE001A 2025-11-07T14:09:09.389Z 2025-11-14T15:08:31.413Z
8380142 8380142 20251105005250_hxaoC BE001A 2025-11-06T14:10:36.346Z 2025-11-13T15:14:42.238Z
8379978 8379978 20251105001338_S52ol BE001A 2025-11-06T14:09:59.111Z 2025-11-13T15:14:34.257Z
8379937 8379937 20251105000537_dTmaO BE001A 2025-11-06T14:09:43.844Z 2025-11-13T15:14:33.769Z
8379911 8379911 20251105000028_ZxIRW BE001A 2025-11-06T14:09:38.850Z 2025-11-13T15:14:33.333Z
8379873 8379873 20251104235546_0lIQl BE001A 2025-11-06T14:09:32.003Z 2025-11-13T15:14:32.851Z

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