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 = "BE000C" 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
8665943 8665943 20251201041209_BxfXZ BE000C 2025-12-02T14:24:56.958Z 2025-12-06T14:42:07.361Z
8665903 8665903 20251201040827_nIWWs BE000C 2025-12-02T14:24:53.843Z 2025-12-06T14:42:06.608Z
8665894 8665894 20251201040629_Eprmf BE000C 2025-12-02T14:24:50.430Z 2025-12-06T14:42:06.205Z
8665876 8665876 20251201040430_araib BE000C 2025-12-02T14:24:37.985Z 2025-12-06T14:42:05.864Z
8665684 8665684 20251201035028_hHK13 BE000C 2025-12-02T14:24:19.618Z 2025-12-06T14:41:45.951Z
8665644 8665644 20251201034548_3OFoO BE000C 2025-12-02T14:24:15.776Z 2025-12-06T14:41:44.276Z
8665500 8665500 20251201032829_o5bgU BE000C 2025-12-02T14:23:47.264Z 2025-12-06T14:41:38.943Z
8665483 8665483 20251201032412_MF8Xn BE000C 2025-12-02T14:23:45.513Z 2025-12-06T14:41:38.397Z
8665467 8665467 20251201032303_MdVFe BE000C 2025-12-02T14:23:44.340Z 2025-12-06T14:41:38.173Z
8665460 8665460 20251201032202_m37R3 BE000C 2025-12-02T14:23:43.258Z 2025-12-06T14:41:37.943Z
8665380 8665380 20251201031414_ki4pK BE000C 2025-12-02T14:23:36.287Z 2025-12-06T14:41:36.545Z
8665271 8665271 20251201025822_nV0VC BE000C 2025-12-02T14:23:16.059Z 2025-12-06T14:41:31.568Z
8665261 8665261 20251201025703_WTQo6 BE000C 2025-12-02T14:23:14.126Z 2025-12-06T14:41:31.239Z
8665225 8665225 20251201024948_lR0e9 BE000C 2025-12-02T14:23:10.068Z 2025-12-06T14:41:30.018Z
8665203 8665203 20251201024704_Y8e38 BE000C 2025-12-02T14:23:07.862Z 2025-12-06T14:41:29.373Z
8665195 8665195 20251201024632_gjoHK BE000C 2025-12-02T14:23:06.829Z 2025-12-06T14:41:29.124Z
8665186 8665186 20251201024509_2FhdR BE000C 2025-12-02T14:23:05.918Z 2025-12-06T14:41:28.965Z
8665035 8665035 20251201021938_Ov222 BE000C 2025-12-02T14:22:39.027Z 2025-12-06T14:41:08.821Z
8664985 8664985 20251201021156_neZeG BE000C 2025-12-02T14:22:33.515Z 2025-12-06T14:41:04.622Z
8664966 8664966 20251201020840_zAwdc BE000C 2025-12-02T14:22:31.281Z 2025-12-06T14:41:03.996Z
8664933 8664933 20251201020606_9sZE2 BE000C 2025-12-02T14:22:28.885Z 2025-12-06T14:41:03.413Z
8664877 8664877 20251201015559_ckGUE BE000C 2025-12-02T14:22:15.944Z 2025-12-06T14:41:01.702Z
8664848 8664848 20251201015006_STH6N BE000C 2025-12-02T14:22:11.674Z 2025-12-06T14:41:00.989Z
8664405 8664405 20251201001841_zj9cf BE000C 2025-12-02T14:21:00.739Z 2025-12-06T14:40:46.074Z
8664400 8664400 20251201001648_5JuOJ BE000C 2025-12-02T14:20:59.760Z 2025-12-06T14:40:45.984Z
8664303 8664303 20251201000059_8BptF BE000C 2025-12-02T14:20:40.898Z 2025-12-06T14:40:43.836Z
8664298 8664298 20251201000018_jEkrI BE000C 2025-12-02T14:20:40.599Z 2025-12-06T14:40:43.776Z
8664233 8664233 20251130234928_0y1DT BE000C 2025-12-02T14:20:33.238Z 2025-12-06T14:40:42.094Z
8664125 8664125 20251130231905_2EW6V BE000C 2025-12-02T14:20:07.381Z 2025-12-06T14:40:36.191Z
8663988 8663988 20251130225429_B253Y BE000C 2025-12-02T14:19:45.643Z 2025-12-06T14:40:19.000Z
8663892 8663892 20251130223033_WemsU BE000C 2025-12-02T14:19:32.290Z 2025-12-06T14:40:14.553Z
8663840 8663840 20251130221744_gQ6tc BE000C 2025-12-02T14:19:23.889Z 2025-12-06T14:40:12.822Z
8663711 8663711 20251130212923_ZadJV BE000C 2025-12-02T14:18:56.219Z 2025-12-06T14:40:08.262Z
8663664 8663664 20251130212051_HBhpF BE000C 2025-12-02T14:18:49.637Z 2025-12-06T14:40:06.647Z
8663624 8663624 20251130211212_wX3Qy BE000C 2025-12-02T14:18:37.731Z 2025-12-06T14:40:05.323Z
8663617 8663617 20251130211021_TY0Re BE000C 2025-12-02T14:18:36.181Z 2025-12-06T14:40:05.049Z
8663552 8663552 20251130210234_WjCq7 BE000C 2025-12-02T14:18:27.545Z 2025-12-06T14:40:03.315Z
8623947 8623947 20251127023153_YN9ZH BE000C 2025-11-28T14:23:10.935Z 2025-12-05T15:04:28.084Z
8623887 8623887 20251127022156_JeGzO BE000C 2025-11-28T14:23:03.415Z 2025-12-05T15:04:24.193Z
8623814 8623814 20251127020923_6wc3C BE000C 2025-11-28T14:22:56.109Z 2025-12-05T15:04:18.266Z
8623796 8623796 20251127020514_9C1Ay BE000C 2025-11-28T14:22:54.392Z 2025-12-05T15:04:17.510Z
8623780 8623780 20251127020014_fgY8G BE000C 2025-11-28T14:22:51.994Z 2025-12-05T15:04:15.895Z
8623773 8623773 20251127015911_kOSy9 BE000C 2025-11-28T14:22:51.391Z 2025-12-05T15:04:15.714Z
8623589 8623589 20251127011635_T9vS4 BE000C 2025-11-28T14:22:13.373Z 2025-12-05T15:04:03.951Z
8623264 8623264 20251126233731_2YEGW BE000C 2025-11-28T14:21:25.312Z 2025-12-05T15:03:41.175Z
8623236 8623236 20251126232708_xA8z3 BE000C 2025-11-28T14:21:15.714Z 2025-12-05T15:03:39.955Z
8623223 8623223 20251126232313_G0KIT BE000C 2025-11-28T14:21:07.536Z 2025-12-05T15:03:38.659Z
8623215 8623215 20251126232204_6h0JG BE000C 2025-11-28T14:21:06.241Z 2025-12-05T15:03:38.371Z
8623007 8623007 20251126222736_aMz3Y BE000C 2025-11-28T14:20:28.535Z 2025-12-05T15:03:25.080Z
8622960 8622960 20251126221347_OTO3a BE000C 2025-11-28T14:20:23.336Z 2025-12-05T15:03:20.767Z
8622828 8622828 20251126214311_LhOEB BE000C 2025-11-28T14:20:08.686Z 2025-12-05T15:03:15.650Z
8622794 8622794 20251126212602_jQiNe BE000C 2025-11-28T14:19:53.980Z 2025-12-05T15:03:11.357Z
8622400 8622400 20251126190311_y7ktb BE000C 2025-11-28T14:18:47.380Z 2025-12-05T15:02:56.418Z
8622362 8622362 20251126185651_elyAy BE000C 2025-11-28T14:18:40.204Z 2025-12-05T15:02:55.976Z
8622223 8622223 20251126181921_StEi3 BE000C 2025-11-28T14:18:10.590Z 2025-12-05T15:02:53.863Z
8622216 8622216 20251126181555_XsO5C BE000C 2025-11-28T14:18:09.313Z 2025-12-05T15:02:53.656Z
8622184 8622184 20251126180844_39NU1 BE000C 2025-11-28T14:18:05.121Z 2025-12-05T15:02:53.320Z
8622147 8622147 20251126175932_l2Y93 BE000C 2025-11-28T14:17:49.547Z 2025-12-05T15:02:52.840Z
8622071 8622071 20251126174346_w8gHA BE000C 2025-11-28T14:17:37.019Z 2025-12-05T15:02:51.557Z
8621981 8621981 20251126172255_9XVoA BE000C 2025-11-28T14:17:12.978Z 2025-12-05T15:02:50.292Z
8621971 8621971 20251126172051_1n4TP BE000C 2025-11-28T14:17:11.567Z 2025-12-05T15:02:50.141Z
8621940 8621940 20251126171438_nXKSh BE000C 2025-11-28T14:17:05.831Z 2025-12-05T15:02:49.695Z
8608343 8608343 20251125220852_EgQvO BE000C 2025-11-27T14:15:43.281Z 2025-12-04T15:07:43.821Z
8581789 8581789 20251123022340_2oJ8Y BE000C 2025-11-24T14:32:38.333Z 2025-12-01T15:21:37.197Z
8581458 8581458 20251122235945_qIdqD BE000C 2025-11-24T14:31:35.996Z 2025-12-01T15:20:34.528Z
8581416 8581416 20251122234736_URaNP BE000C 2025-11-24T14:31:33.187Z 2025-12-01T15:20:26.274Z
8581367 8581367 20251122232347_daX3x BE000C 2025-11-24T14:31:29.430Z 2025-12-01T15:20:15.857Z
8581359 8581359 20251122232016_p0pvE BE000C 2025-11-24T14:31:28.482Z 2025-12-01T15:20:15.113Z
8581340 8581340 20251122231314_TmOge BE000C 2025-11-24T14:31:27.520Z 2025-12-01T15:20:14.313Z
8581307 8581307 20251122230133_WXA5j BE000C 2025-11-24T14:31:24.922Z 2025-12-01T15:20:12.243Z
8581303 8581303 20251122230039_lUFdZ BE000C 2025-11-24T14:31:24.794Z 2025-12-01T15:20:12.185Z
8581237 8581237 20251122222614_M8Mhj BE000C 2025-11-24T14:31:21.458Z 2025-12-01T15:20:03.911Z
8581234 8581234 20251122222425_3Izp1 BE000C 2025-11-24T14:31:21.272Z 2025-12-01T15:20:03.758Z
8579103 8579103 20251122222215_EhL6V BE000C 2025-11-24T14:13:30.844Z 2025-12-01T15:20:02.984Z
8578917 8578917 20251122214946_6OdIS BE000C 2025-11-24T14:13:05.951Z 2025-12-01T15:19:55.890Z
8578893 8578893 20251122214654_iWoez BE000C 2025-11-24T14:12:57.300Z 2025-11-24T14:12:57.300Z
8578890 8578890 20251122214541_n1BBY BE000C 2025-11-24T14:12:56.308Z 2025-12-01T15:19:55.122Z
8578822 8578822 20251122213042_gYfOR BE000C 2025-11-24T14:12:46.701Z 2025-12-01T15:19:53.383Z
8578779 8578779 20251122212431_gv6dx BE000C 2025-11-24T14:12:39.803Z 2025-12-01T15:19:52.774Z
8578746 8578746 20251122212205_fK4jO BE000C 2025-11-24T14:12:37.274Z 2025-12-01T15:19:51.255Z
8578652 8578652 20251122210614_zwbzX BE000C 2025-11-24T14:12:16.088Z 2025-12-01T15:19:49.360Z
8578592 8578592 20251122205909_VgOVe BE000C 2025-11-24T14:12:10.596Z 2025-12-01T15:19:48.756Z
8578451 8578451 20251122203746_eCqjO BE000C 2025-11-24T14:11:46.096Z 2025-12-01T15:19:37.951Z
8578429 8578429 20251122203620_gVzdq BE000C 2025-11-24T14:11:43.847Z 2025-12-01T15:19:37.247Z
8578308 8578308 20251122202701_xyfFi BE000C 2025-11-24T14:11:23.236Z 2025-12-01T15:19:31.646Z
8578282 8578282 20251122202207_pD80O BE000C 2025-11-24T14:11:18.495Z 2025-11-24T14:11:18.495Z
8578256 8578256 20251122201429_0nZ2e BE000C 2025-11-24T14:11:13.752Z 2025-11-24T14:11:13.752Z
8578247 8578247 20251122201251_giEFH BE000C 2025-11-24T14:11:12.332Z 2025-12-01T15:19:25.905Z
8578191 8578191 20251122195744_tE8jo BE000C 2025-11-24T14:11:03.803Z 2025-12-01T15:19:20.985Z
8578187 8578187 20251122195737_Ih8Ar BE000C 2025-11-24T14:11:03.362Z 2025-11-24T14:11:03.362Z
8578078 8578078 20251122193616_FSAS7 BE000C 2025-11-24T14:10:40.966Z 2025-12-01T15:19:08.169Z
8577989 8577989 20251122192112_C58Ko BE000C 2025-11-24T14:10:27.018Z 2025-12-01T15:19:05.529Z
8577492 8577492 20251122181719_Gf0ZS BE000C 2025-11-24T14:08:47.547Z 2025-12-01T15:18:52.065Z
8577280 8577280 20251122175118_tT4wX BE000C 2025-11-24T14:08:11.421Z 2025-12-01T15:18:46.333Z
8577169 8577169 20251122172659_WAU42 BE000C 2025-11-24T14:07:52.055Z 2025-12-01T15:18:44.420Z
8577150 8577150 20251122172600_3jJM2 BE000C 2025-11-24T14:07:49.857Z 2025-11-24T14:07:49.857Z
8515958 8515958 20251118052605_ghkD3 BE000C 2025-11-19T14:40:04.572Z 2025-11-26T15:08:05.079Z
8515949 8515949 20251118052328_1HW79 BE000C 2025-11-19T14:40:03.849Z 2025-11-26T15:08:04.956Z
8515871 8515871 20251118051703_4NIYn BE000C 2025-11-19T14:40:00.993Z 2025-11-26T15:08:04.617Z
8515702 8515702 20251118045637_Bripf BE000C 2025-11-19T14:39:54.576Z 2025-11-26T15:08:03.552Z

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