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

4,671 rows where station_code = "BE000W" 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
8666441 8666441 20251201054059_hOYk9 BE000W 2025-12-02T14:26:13.306Z 2025-12-05T14:36:58.548Z
8666312 8666312 20251201051106_3N4mL BE000W 2025-12-02T14:25:45.670Z 2025-12-05T14:36:53.980Z
8666271 8666271 20251201050614_IgdvS BE000W 2025-12-02T14:25:41.704Z 2025-12-05T14:36:52.778Z
8666218 8666218 20251201045345_kppVY BE000W 2025-12-02T14:25:37.045Z 2025-12-05T14:36:39.454Z
8666080 8666080 20251201043043_f0OAZ BE000W 2025-12-02T14:25:12.262Z 2025-12-05T14:36:31.621Z
8666041 8666041 20251201042656_P3i0Z BE000W 2025-12-02T14:25:07.943Z 2025-12-05T14:36:27.940Z
8666027 8666027 20251201042504_n5Fkj BE000W 2025-12-02T14:25:07.028Z 2025-12-05T14:36:27.650Z
8665846 8665846 20251201040240_NsN4z BE000W 2025-12-02T14:24:34.763Z 2025-12-05T14:36:21.364Z
8665841 8665841 20251201040239_3D9tP BE000W 2025-12-02T14:24:34.458Z 2025-12-05T14:36:21.272Z
8665721 8665721 20251201035153_EA0V6 BE000W 2025-12-02T14:24:22.288Z 2025-12-05T14:36:17.320Z
8665695 8665695 20251201035042_uw1ax BE000W 2025-12-02T14:24:20.401Z 2025-12-05T14:36:16.283Z
8665641 8665641 20251201034535_mKeNL BE000W 2025-12-02T14:24:15.609Z 2025-12-05T14:36:14.814Z
8665632 8665632 20251201034450_mFbFf BE000W 2025-12-02T14:24:14.400Z 2025-12-05T14:36:14.547Z
8665448 8665448 20251201032120_k8MoS BE000W 2025-12-02T14:23:42.604Z 2025-12-05T14:36:07.864Z
8665070 8665070 20251201022455_BKtLt BE000W 2025-12-02T14:22:45.103Z 2025-12-05T14:35:41.534Z
8665014 8665014 20251201021703_MbBkU BE000W 2025-12-02T14:22:36.882Z 2025-12-05T14:35:39.315Z
8664779 8664779 20251201013645_5wXjm BE000W 2025-12-02T14:22:03.697Z 2025-12-05T14:35:17.661Z
8664731 8664731 20251201013155_Rf68B BE000W 2025-12-02T14:21:59.659Z 2025-12-05T14:35:16.372Z
8664715 8664715 20251201013025_wj6pG BE000W 2025-12-02T14:21:57.545Z 2025-12-05T14:35:15.831Z
8664660 8664660 20251201011912_bVezI BE000W 2025-12-02T14:21:45.159Z 2025-12-05T14:35:11.992Z
8664610 8664610 20251201011111_POMSz BE000W 2025-12-02T14:21:37.589Z 2025-12-05T14:35:10.287Z
8664595 8664595 20251201010803_l07c4 BE000W 2025-12-02T14:21:35.812Z 2025-12-05T14:35:09.727Z
8664567 8664567 20251201005748_SOPKM BE000W 2025-12-02T14:21:22.663Z 2025-12-05T14:35:08.825Z
8664477 8664477 20251201003919_9B8C3 BE000W 2025-12-02T14:21:10.231Z 2025-12-05T14:35:05.667Z
8664437 8664437 20251201002706_bhFcx BE000W 2025-12-02T14:21:04.523Z 2025-12-05T14:35:04.116Z
8664422 8664422 20251201002505_aNUPT BE000W 2025-12-02T14:21:02.693Z 2025-12-05T14:35:03.663Z
8664347 8664347 20251201000603_ZN92a BE000W 2025-12-02T14:20:45.599Z 2025-12-05T14:35:01.374Z
8664329 8664329 20251201000344_G5UER BE000W 2025-12-02T14:20:43.509Z 2025-12-05T14:35:00.829Z
8664312 8664312 20251201000153_3U5MD BE000W 2025-12-02T14:20:41.570Z 2025-12-05T14:35:00.372Z
8664288 8664288 20251130235905_3IXSh BE000W 2025-12-02T14:20:39.477Z 2025-12-05T14:34:59.740Z
8664273 8664273 20251130235513_9OdPo BE000W 2025-12-02T14:20:37.502Z 2025-12-05T14:34:59.208Z
8664201 8664201 20251130233846_SuHmJ BE000W 2025-12-02T14:20:18.832Z 2025-12-05T14:34:56.415Z
8664164 8664164 20251130232927_DqFut BE000W 2025-12-02T14:20:13.602Z 2025-12-05T14:34:55.226Z
8664069 8664069 20251130231357_LekrV BE000W 2025-12-02T14:20:03.074Z 2025-12-05T14:34:43.888Z
8646472 8646472 20251129020945_2vLE2 BE000W 2025-11-30T14:26:02.894Z 2025-12-05T14:51:42.865Z
8646126 8646126 20251129010955_KQvU7 BE000W 2025-11-30T14:25:14.652Z 2025-12-05T14:51:33.725Z
8646080 8646080 20251129010132_qkjWB BE000W 2025-11-30T14:25:09.823Z 2025-12-05T14:51:32.561Z
8646073 8646073 20251129005807_B0rl3 BE000W 2025-11-30T14:25:08.834Z 2025-12-05T14:51:32.356Z
8646052 8646052 20251129005613_tknqD BE000W 2025-11-30T14:25:06.900Z 2025-12-05T14:51:31.795Z
8646039 8646039 20251129005419_Ctrem BE000W 2025-11-30T14:25:05.967Z 2025-12-05T14:51:31.582Z
8645975 8645975 20251129003940_MmjNA BE000W 2025-11-30T14:25:01.132Z 2025-12-05T14:51:30.348Z
8645906 8645906 20251129002305_V6Fiv BE000W 2025-11-30T14:24:53.503Z 2025-12-05T14:51:28.006Z
8645897 8645897 20251129002015_87GdO BE000W 2025-11-30T14:24:52.486Z 2025-12-05T14:51:27.817Z
8645845 8645845 20251129000326_AAPWp BE000W 2025-11-30T14:24:37.370Z 2025-12-05T14:51:23.703Z
8645723 8645723 20251128233738_MXG3V BE000W 2025-11-30T14:24:26.776Z 2025-12-05T14:51:09.962Z
8645644 8645644 20251128231645_irvHI BE000W 2025-11-30T14:24:20.206Z 2025-12-05T14:51:01.802Z
8645565 8645565 20251128225149_v6maV BE000W 2025-11-30T14:24:12.218Z 2025-12-05T14:50:51.409Z
8645500 8645500 20251128222803_jJ0ot BE000W 2025-11-30T14:23:51.120Z 2025-12-05T14:50:44.294Z
8645138 8645138 20251128204222_J4xZ6 BE000W 2025-11-30T14:23:09.426Z 2025-12-05T14:50:32.301Z
8644921 8644921 20251128201513_ZK0PM BE000W 2025-11-30T14:22:52.548Z 2025-12-05T14:50:29.393Z
8624104 8624104 20251127030846_0z7fU BE000W 2025-11-28T14:23:47.059Z 2025-12-05T15:04:44.277Z
8623895 8623895 20251127022249_c7GVn BE000W 2025-11-28T14:23:03.955Z 2025-12-05T15:04:25.486Z
8623498 8623498 20251127005422_YKLJm BE000W 2025-11-28T14:22:02.742Z 2025-12-05T15:03:57.765Z
8623372 8623372 20251127001633_VcAAz BE000W 2025-11-28T14:21:36.102Z 2025-12-05T15:03:45.178Z
8622877 8622877 20251126215606_Zkomu BE000W 2025-11-28T14:20:14.329Z 2025-12-05T15:03:17.240Z
8622782 8622782 20251126212212_AeoiM BE000W 2025-11-28T14:19:52.926Z 2025-12-05T15:03:08.806Z
8622617 8622617 20251126201610_NHAyu BE000W 2025-11-28T14:19:33.991Z 2025-12-05T15:03:04.128Z
8622549 8622549 20251126195325_syU4p BE000W 2025-11-28T14:19:09.886Z 2025-12-05T15:03:03.299Z
8622388 8622388 20251126190136_E3UvH BE000W 2025-11-28T14:18:45.658Z 2025-12-05T15:02:56.228Z
8622057 8622057 20251126174102_vRWN9 BE000W 2025-11-28T14:17:34.707Z 2025-12-05T15:02:51.279Z
8595570 8595570 20251124165956_Lm9xC BE000W 2025-11-26T14:11:39.517Z 2025-12-02T15:06:01.759Z
8581619 8581619 20251123011441_KJuDA BE000W 2025-11-24T14:32:12.676Z 2025-12-01T15:21:08.050Z
8581545 8581545 20251123005148_O6FwQ BE000W 2025-11-24T14:31:47.149Z 2025-12-01T15:20:56.597Z
8581483 8581483 20251123000902_aoTP8 BE000W 2025-11-24T14:31:40.180Z 2025-12-01T15:20:38.776Z
8581463 8581463 20251123000132_FzKKc BE000W 2025-11-24T14:31:36.473Z 2025-12-01T15:20:34.765Z
8581399 8581399 20251122234141_ckLZm BE000W 2025-11-24T14:31:31.710Z 2025-12-01T15:20:19.186Z
8581372 8581372 20251122232702_C36ku BE000W 2025-11-24T14:31:29.509Z 2025-12-01T15:20:17.470Z
8581345 8581345 20251122231341_nF5jg BE000W 2025-11-24T14:31:27.667Z 2025-12-01T15:20:14.382Z
8581322 8581322 20251122230527_2fcUs BE000W 2025-11-24T14:31:25.660Z 2025-12-01T15:20:13.658Z
8581284 8581284 20251122225436_OG51D BE000W 2025-11-24T14:31:23.811Z 2025-12-01T15:20:11.430Z
8581282 8581282 20251122225416_zdXQb BE000W 2025-11-24T14:31:23.768Z 2025-12-01T15:20:11.416Z
8581274 8581274 20251122224935_HAHDI BE000W 2025-11-24T14:31:23.591Z 2025-12-01T15:20:08.064Z
8581268 8581268 20251122224311_DEqeo BE000W 2025-11-24T14:31:22.941Z 2025-12-01T15:20:07.500Z
8581250 8581250 20251122222917_ZCu6U BE000W 2025-11-24T14:31:21.929Z 2025-12-01T15:20:04.947Z
8581243 8581243 20251122222750_mNVIh BE000W 2025-11-24T14:31:21.585Z 2025-12-01T15:20:04.641Z
8581225 8581225 20251122165354_BarCf BE000W 2025-11-24T14:29:43.992Z 2025-12-01T15:18:41.924Z
8580709 8580709 20251122000654_JQQbl BE000W 2025-11-24T14:23:01.113Z 2025-11-30T15:05:41.990Z
8579065 8579065 20251122221535_a3S92 BE000W 2025-11-24T14:13:26.966Z 2025-12-01T15:20:00.721Z
8578976 8578976 20251122220002_X3KVj BE000W 2025-11-24T14:13:13.009Z 2025-12-01T15:19:57.679Z
8578948 8578948 20251122215545_XQbft BE000W 2025-11-24T14:13:10.020Z 2025-12-01T15:19:57.087Z
8578737 8578737 20251122212127_ZP02r BE000W 2025-11-24T14:12:35.844Z 2025-12-01T15:19:51.107Z
8578734 8578734 20251122212126_APMVg BE000W 2025-11-24T14:12:35.600Z 2025-12-01T15:19:51.105Z
8578259 8578259 20251122201615_j0LJe BE000W 2025-11-24T14:11:14.228Z 2025-12-01T15:19:27.572Z
8577991 8577991 20251122192346_yhFMi BE000W 2025-11-24T14:10:27.470Z 2025-12-01T15:19:05.695Z
8577907 8577907 20251122190950_DUf6L BE000W 2025-11-24T14:10:08.798Z 2025-12-01T15:19:01.966Z
8577889 8577889 20251122190746_GLnt5 BE000W 2025-11-24T14:10:06.022Z 2025-12-01T15:19:01.260Z
8577711 8577711 20251122184953_kcfhZ BE000W 2025-11-24T14:09:29.918Z 2025-12-01T15:18:56.760Z
8577700 8577700 20251122184811_UXjOj BE000W 2025-11-24T14:09:28.320Z 2025-12-01T15:18:56.667Z
8577689 8577689 20251122184648_PI2oO BE000W 2025-11-24T14:09:26.687Z 2025-12-01T15:18:56.496Z
8577654 8577654 20251122184349_OnsEO BE000W 2025-11-24T14:09:18.276Z 2025-12-01T15:18:55.873Z
8577365 8577365 20251122175939_T2RUV BE000W 2025-11-24T14:08:28.943Z 2025-12-01T15:18:48.350Z
8577292 8577292 20251122175227_Nm3Dq BE000W 2025-11-24T14:08:12.547Z 2025-12-01T15:18:46.792Z
8577201 8577201 20251122173208_qCFhA BE000W 2025-11-24T14:07:56.508Z 2025-12-01T15:18:44.711Z
8577136 8577136 20251122172403_fDe2i BE000W 2025-11-24T14:07:42.535Z 2025-12-01T15:18:43.991Z
8577062 8577062 20251122171402_l8Ikd BE000W 2025-11-24T14:07:26.443Z 2025-12-01T15:18:42.857Z
8574359 8574359 20251122055918_0Z4G0 BE000W 2025-11-23T14:43:09.643Z 2025-11-30T15:07:05.377Z
8574303 8574303 20251122054504_ka02Y BE000W 2025-11-23T14:43:05.060Z 2025-11-30T15:07:04.630Z
8574185 8574185 20251122052253_r1mEl BE000W 2025-11-23T14:42:45.312Z 2025-11-30T15:07:01.765Z
8574153 8574153 20251122051847_agaTa BE000W 2025-11-23T14:42:27.221Z 2025-11-30T15:07:00.456Z
8574128 8574128 20251122051448_cZPRG BE000W 2025-11-23T14:42:20.724Z 2025-11-30T15:06:59.603Z

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