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,860 rows where station_code = "BE0011" 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
9262892 9262892 20260126042337_bla0O BE0011 2026-01-27T14:16:01.486Z 2026-01-29T14:38:59.533Z
9262890 9262890 20260126042111_vnPzF BE0011 2026-01-27T14:16:00.836Z 2026-01-29T14:38:59.293Z
9262883 9262883 20260126041709_abNhU BE0011 2026-01-27T14:15:58.662Z 2026-01-29T14:38:58.677Z
9262853 9262853 20260126034856_y1aDs BE0011 2026-01-27T14:15:40.904Z 2026-01-29T14:38:52.706Z
9262774 9262774 20260126023243_lZ1o5 BE0011 2026-01-27T14:15:14.689Z 2026-01-29T14:38:46.587Z
9260286 9260286 20260125032522_16d2l BE0011 2026-01-26T14:21:04.554Z 2026-01-29T14:44:03.995Z
9260239 9260239 20260125031331_6vB1v BE0011 2026-01-26T14:20:54.826Z 2026-01-29T14:44:01.613Z
9260230 9260230 20260125031129_xmxhZ BE0011 2026-01-26T14:20:52.421Z 2026-01-29T14:44:01.022Z
9260201 9260201 20260125030702_aGg6M BE0011 2026-01-26T14:20:46.792Z 2026-01-29T14:43:59.190Z
9260199 9260199 20260125030532_dhVa3 BE0011 2026-01-26T14:20:46.167Z 2026-01-29T14:43:59.041Z
9260117 9260117 20260125023831_YEHOR BE0011 2026-01-26T14:20:20.071Z 2026-01-29T14:43:49.567Z
9260103 9260103 20260125023740_IqGfn BE0011 2026-01-26T14:20:17.745Z 2026-01-29T14:43:48.766Z
9259821 9259821 20260125002811_Ryxdg BE0011 2026-01-26T14:18:43.112Z 2026-01-29T14:43:23.513Z
9259708 9259708 20260124233018_RmxlR BE0011 2026-01-26T14:18:10.836Z 2026-01-29T14:43:14.378Z
9259673 9259673 20260124230704_0wDeK BE0011 2026-01-26T14:18:03.572Z 2026-01-29T14:43:12.499Z
9259549 9259549 20260124212305_9GbYO BE0011 2026-01-26T14:17:26.019Z 2026-01-29T14:43:05.417Z
9259512 9259512 20260124211423_9gb3C BE0011 2026-01-26T14:17:21.176Z 2026-01-29T14:42:58.030Z
9259201 9259201 20260124193812_XeCfv BE0011 2026-01-26T14:16:05.554Z 2026-01-29T14:42:42.270Z
9259022 9259022 20260124182351_doipk BE0011 2026-01-26T14:15:27.265Z 2026-01-29T14:42:26.513Z
9256208 9256208 20260124062024_a25Qt BE0011 2026-01-25T14:16:13.124Z 2026-01-29T14:48:28.845Z
9256050 9256050 20260124054750_LEQj5 BE0011 2026-01-25T14:15:39.239Z 2026-01-29T14:48:20.469Z
9255986 9255986 20260124053502_cRSRO BE0011 2026-01-25T14:15:28.667Z 2026-01-29T14:48:16.635Z
9255917 9255917 20260124051927_yXicn BE0011 2026-01-25T14:15:09.069Z 2026-01-29T14:48:08.044Z
9255847 9255847 20260124050908_awYX5 BE0011 2026-01-25T14:14:58.697Z 2026-01-29T14:48:01.515Z
9255840 9255840 20260124050716_6fvCg BE0011 2026-01-25T14:14:57.140Z 2026-01-29T14:48:01.139Z
9255786 9255786 20260124045547_KLDIl BE0011 2026-01-25T14:14:42.424Z 2026-01-29T14:47:57.448Z
9255747 9255747 20260124044407_mtIOV BE0011 2026-01-25T14:14:33.025Z 2026-01-29T14:47:55.054Z
9255644 9255644 20260124042329_mYRIt BE0011 2026-01-25T14:14:10.105Z 2026-01-29T14:47:49.243Z
9255640 9255640 20260124042259_waz8y BE0011 2026-01-25T14:14:09.610Z 2026-01-29T14:47:48.920Z
9255542 9255542 20260124040651_5Otp3 BE0011 2026-01-25T14:13:54.343Z 2026-01-29T14:47:39.143Z
9255536 9255536 20260124040649_IB6Za BE0011 2026-01-25T14:13:53.151Z 2026-01-29T14:47:38.722Z
9255513 9255513 20260124035644_WrQ3e BE0011 2026-01-25T14:13:44.108Z 2026-01-29T14:47:35.438Z
9255429 9255429 20260124032954_Qes2S BE0011 2026-01-25T14:13:25.103Z 2026-01-29T14:47:30.261Z
9255343 9255343 20260124025720_bJ5Cu BE0011 2026-01-25T14:12:59.810Z 2026-01-29T14:47:25.126Z
9255339 9255339 20260124025703_u3TAK BE0011 2026-01-25T14:12:58.529Z 2026-01-29T14:47:24.665Z
9255312 9255312 20260124024423_bmYU5 BE0011 2026-01-25T14:12:52.438Z 2026-01-29T14:47:23.108Z
9255257 9255257 20260124021239_F3MKv BE0011 2026-01-25T14:12:33.995Z 2026-01-29T14:47:12.675Z
9255150 9255150 20260124012020_Liouy BE0011 2026-01-25T14:12:03.608Z 2026-01-29T14:47:04.851Z
9252378 9252378 20260123024130_3bT1R BE0011 2026-01-24T14:15:18.420Z 2026-01-29T14:52:47.739Z
9252326 9252326 20260123021751_hLh5L BE0011 2026-01-24T14:15:09.048Z 2026-01-29T14:52:45.340Z
9252251 9252251 20260123015803_oPoUG BE0011 2026-01-24T14:14:51.507Z 2026-01-29T14:52:42.066Z
9252180 9252180 20260123013404_QO9c7 BE0011 2026-01-24T14:14:40.362Z 2026-01-29T14:52:38.279Z
9252125 9252125 20260123010647_gh2F2 BE0011 2026-01-24T14:14:24.612Z 2026-01-29T14:52:34.877Z
9252052 9252052 20260123004830_YsNhP BE0011 2026-01-24T14:14:13.032Z 2026-01-29T14:52:26.095Z
9251906 9251906 20260122235154_Fq8bN BE0011 2026-01-24T14:13:38.007Z 2026-01-29T14:52:16.636Z
9251851 9251851 20260122232620_z85Ck BE0011 2026-01-24T14:13:24.054Z 2026-01-29T14:52:13.235Z
9251780 9251780 20260122224013_Hu3U6 BE0011 2026-01-24T14:13:12.794Z 2026-01-29T14:52:09.519Z
9251675 9251675 20260122215435_qMcrg BE0011 2026-01-24T14:12:50.024Z 2026-01-29T14:51:58.388Z
9249614 9249614 20260122060405_uli71 BE0011 2026-01-23T14:15:47.634Z 2026-01-29T14:58:46.839Z
9249568 9249568 20260122055018_bf9qB BE0011 2026-01-23T14:15:43.417Z 2026-01-29T14:58:45.091Z
9249560 9249560 20260122054837_bCcoP BE0011 2026-01-23T14:15:42.471Z 2026-01-29T14:58:44.705Z
9249493 9249493 20260122053115_wgzKS BE0011 2026-01-23T14:15:35.929Z 2026-01-29T14:58:41.795Z
9249475 9249475 20260122052739_AZ3ht BE0011 2026-01-23T14:15:28.513Z 2026-01-29T14:58:40.969Z
9249103 9249103 20260122033648_xIOMH BE0011 2026-01-23T14:14:35.146Z 2026-01-29T14:58:12.696Z
9249054 9249054 20260122032251_3HZmI BE0011 2026-01-23T14:14:30.813Z 2026-01-29T14:58:10.867Z
9249028 9249028 20260122031207_lJ0n4 BE0011 2026-01-23T14:14:27.205Z 2026-01-29T14:58:09.754Z
9249026 9249026 20260122031149_VnFaS BE0011 2026-01-23T14:14:26.929Z 2026-01-29T14:58:09.638Z
9248397 9248397 20260121233208_3iaAi BE0011 2026-01-23T14:12:43.084Z 2026-01-29T14:57:17.102Z
9247437 9247437 20260121183007_VJZ5q BE0011 2026-01-23T14:10:03.657Z 2026-01-29T14:56:08.495Z
9236594 9236594 20260120033715_S9FA6 BE0011 2026-01-21T14:23:28.927Z 2026-01-28T15:00:23.496Z
9236476 9236476 20260120032400_aVqpM BE0011 2026-01-21T14:22:56.277Z 2026-01-28T15:00:03.685Z
9235161 9235161 20260120003918_1Ximr BE0011 2026-01-21T14:17:47.684Z 2026-01-28T14:58:33.676Z
9235055 9235055 20260120001940_SFDO1 BE0011 2026-01-21T14:17:19.461Z 2026-01-28T14:58:27.082Z
9234296 9234296 20260119203834_rv5me BE0011 2026-01-21T14:13:32.790Z 2026-01-28T14:57:27.515Z
9234198 9234198 20260119200344_3hESt BE0011 2026-01-21T14:12:57.340Z 2026-01-28T14:57:21.076Z
9228272 9228272 20260118210622_rB1hI BE0011 2026-01-20T14:16:59.145Z 2026-01-27T15:01:40.387Z
9228206 9228206 20260118203952_3rN2G BE0011 2026-01-20T14:16:39.335Z 2026-01-27T15:01:33.921Z
9224150 9224150 20260118033738_6jgQJ BE0011 2026-01-19T14:23:05.837Z 2026-01-26T15:03:06.749Z
9224126 9224126 20260118033010_BQZyH BE0011 2026-01-19T14:23:00.571Z 2026-01-26T15:03:05.807Z
9224080 9224080 20260118032053_uODHV BE0011 2026-01-19T14:22:40.044Z 2026-01-26T15:02:50.385Z
9224020 9224020 20260118030937_abm2G BE0011 2026-01-19T14:22:25.552Z 2026-01-26T15:02:48.044Z
9223904 9223904 20260118024735_q2ReI BE0011 2026-01-19T14:21:46.863Z 2026-01-26T15:02:40.992Z
9223900 9223900 20260118024635_w642H BE0011 2026-01-19T14:21:45.785Z 2026-01-26T15:02:40.825Z
9223662 9223662 20260118015851_sHK4m BE0011 2026-01-19T14:20:33.793Z 2026-01-26T15:02:31.399Z
9223603 9223603 20260118013918_O5uJM BE0011 2026-01-19T14:20:08.857Z 2026-01-26T15:02:28.922Z
9223381 9223381 20260118002754_ePZNl BE0011 2026-01-19T14:18:58.202Z 2026-01-26T15:02:04.514Z
9223271 9223271 20260118000255_d7BUH BE0011 2026-01-19T14:18:28.239Z 2026-01-26T15:02:00.563Z
9223247 9223247 20260117235456_jh0cu BE0011 2026-01-19T14:18:22.607Z 2026-01-26T15:01:59.552Z
9195575 9195575 20260113015001_nEZ2b BE0011 2026-01-14T14:13:52.236Z 2026-01-21T15:04:42.438Z
9195158 9195158 20260113003121_JmAa7 BE0011 2026-01-14T14:12:15.562Z 2026-01-21T15:04:37.143Z
9160246 9160246 20260106051327_o2vO3 BE0011 2026-01-07T14:11:59.702Z 2026-01-13T15:09:16.372Z
9155422 9155422 20260104055516_XWAJ4 BE0011 2026-01-06T14:37:21.652Z 2026-01-12T15:11:00.487Z
9154736 9154736 20260104051145_QxHYa BE0011 2026-01-06T14:36:07.554Z 2026-01-12T15:10:18.288Z
9154218 9154218 20260104044554_mjccz BE0011 2026-01-06T14:35:04.218Z 2026-01-12T15:09:41.610Z
9154195 9154195 20260104044213_BI2A2 BE0011 2026-01-06T14:35:00.446Z 2026-01-12T15:09:39.974Z
9153805 9153805 20260104041502_Ps7oZ BE0011 2026-01-06T14:34:09.294Z 2026-01-12T15:09:05.753Z
9149370 9149370 20260104202523_e6G7D BE0011 2026-01-06T14:05:09.286Z 2026-01-13T15:12:06.859Z
9149188 9149188 20260104191715_KX23l BE0011 2026-01-06T14:04:14.411Z 2026-01-13T15:11:47.645Z
9146231 9146231 20260104034116_p6yYW BE0011 2026-01-05T14:21:54.555Z 2026-01-12T15:08:23.337Z
9146180 9146180 20260104033827_qREGN BE0011 2026-01-05T14:21:50.780Z 2026-01-12T15:08:21.675Z
9145895 9145895 20260104033044_isTF3 BE0011 2026-01-05T14:21:24.534Z 2026-01-12T15:08:15.168Z
9145554 9145554 20260104031939_xZ54G BE0011 2026-01-05T14:20:50.638Z 2026-01-12T15:07:52.403Z
9144901 9144901 20260104025815_zFYWh BE0011 2026-01-05T14:19:40.961Z 2026-01-05T14:30:34.004Z
9129909 9129909 20260103012516_4hQjX BE0011 2026-01-04T14:07:08.729Z 2026-01-10T14:58:24.537Z
9129876 9129876 20260103011634_7rvA1 BE0011 2026-01-04T14:06:58.283Z 2026-01-10T14:58:21.701Z
9106831 9106831 20251228224339_iaYRp BE0011 2025-12-31T14:31:43.792Z 2026-01-06T15:14:43.772Z
9099744 9099744 20251225055720_p33uF BE0011 2025-12-30T15:31:11.585Z 2026-01-02T15:45:37.904Z
9099728 9099728 20251225053840_ZBhPH BE0011 2025-12-30T15:31:01.297Z 2026-01-02T15:45:32.542Z
9099655 9099655 20251225043225_MjEZj BE0011 2025-12-30T15:29:53.781Z 2026-01-02T15:44:51.245Z
9099644 9099644 20251225042414_eGW8a BE0011 2025-12-30T15:29:42.788Z 2026-01-02T15:44:48.650Z

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