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,800 rows where station_code = "BE0018" 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
8687195 8687195 20251204054241_2Nvsg BE0018 2025-12-05T14:14:22.137Z 2025-12-05T14:14:35.648Z
8687193 8687193 20251204054121_9qyTS BE0018 2025-12-05T14:14:21.675Z 2025-12-05T14:14:35.647Z
8687169 8687169 20251204052941_SdaHK BE0018 2025-12-05T14:14:08.793Z 2025-12-05T14:14:35.640Z
8687146 8687146 20251204052047_bLfNu BE0018 2025-12-05T14:14:03.588Z 2025-12-05T14:14:35.634Z
8666028 8666028 20251201042504_n5Fkj BE0018 2025-12-02T14:25:07.028Z 2025-12-05T14:36:27.650Z
8665847 8665847 20251201040240_NsN4z BE0018 2025-12-02T14:24:34.763Z 2025-12-05T14:36:21.364Z
8665834 8665834 20251201040228_P21eh BE0018 2025-12-02T14:24:34.067Z 2025-12-05T14:36:21.169Z
8665722 8665722 20251201035153_EA0V6 BE0018 2025-12-02T14:24:22.288Z 2025-12-05T14:36:17.320Z
8665680 8665680 20251201035026_SeVWe BE0018 2025-12-02T14:24:19.354Z 2025-12-05T14:36:15.936Z
8665659 8665659 20251201034809_O712O BE0018 2025-12-02T14:24:17.069Z 2025-12-05T14:36:15.264Z
8665642 8665642 20251201034535_mKeNL BE0018 2025-12-02T14:24:15.609Z 2025-12-05T14:36:14.814Z
8665633 8665633 20251201034450_mFbFf BE0018 2025-12-02T14:24:14.400Z 2025-12-05T14:36:14.547Z
8665476 8665476 20251201032341_MVTpD BE0018 2025-12-02T14:23:45.000Z 2025-12-05T14:36:08.725Z
8665449 8665449 20251201032120_k8MoS BE0018 2025-12-02T14:23:42.604Z 2025-12-05T14:36:07.864Z
8665106 8665106 20251201022914_urvDp BE0018 2025-12-02T14:22:56.145Z 2025-12-05T14:35:42.524Z
8664780 8664780 20251201013645_5wXjm BE0018 2025-12-02T14:22:03.697Z 2025-12-05T14:35:17.661Z
8664716 8664716 20251201013025_wj6pG BE0018 2025-12-02T14:21:57.545Z 2025-12-05T14:35:15.831Z
8664677 8664677 20251201012155_op9Z8 BE0018 2025-12-02T14:21:47.043Z 2025-12-05T14:35:12.434Z
8664673 8664673 20251201012115_aMEIy BE0018 2025-12-02T14:21:46.763Z 2025-12-05T14:35:12.324Z
8664578 8664578 20251201005932_4lY2y BE0018 2025-12-02T14:21:32.658Z 2025-12-05T14:35:09.096Z
8664478 8664478 20251201003919_9B8C3 BE0018 2025-12-02T14:21:10.231Z 2025-12-05T14:35:05.667Z
8664470 8664470 20251201003821_X3A1V BE0018 2025-12-02T14:21:09.490Z 2025-12-05T14:35:05.417Z
8664452 8664452 20251201003316_ixYsj BE0018 2025-12-02T14:21:06.676Z 2025-12-05T14:35:04.628Z
8664423 8664423 20251201002505_aNUPT BE0018 2025-12-02T14:21:02.693Z 2025-12-05T14:35:03.663Z
8664354 8664354 20251201000818_abLER BE0018 2025-12-02T14:20:47.174Z 2025-12-05T14:35:01.772Z
8664322 8664322 20251201000338_BC30C BE0018 2025-12-02T14:20:42.763Z 2025-12-05T14:35:00.644Z
8664289 8664289 20251130235905_3IXSh BE0018 2025-12-02T14:20:39.477Z 2025-12-05T14:34:59.740Z
8664274 8664274 20251130235513_9OdPo BE0018 2025-12-02T14:20:37.502Z 2025-12-05T14:34:59.208Z
8664230 8664230 20251130234923_NAdgx BE0018 2025-12-02T14:20:32.771Z 2025-12-05T14:34:57.789Z
8664222 8664222 20251130234430_5B1pA BE0018 2025-12-02T14:20:31.161Z 2025-12-05T14:34:57.247Z
8664171 8664171 20251130233059_VXwnr BE0018 2025-12-02T14:20:14.508Z 2025-12-05T14:34:55.485Z
8664070 8664070 20251130231357_LekrV BE0018 2025-12-02T14:20:03.094Z 2025-12-05T14:34:43.888Z
8664013 8664013 20251130230224_c1yZf BE0018 2025-12-02T14:19:55.827Z 2025-12-05T14:34:41.869Z
8663835 8663835 20251130221723_Nrbj5 BE0018 2025-12-02T14:19:23.483Z 2025-12-05T14:34:33.790Z
8663761 8663761 20251130215033_8PVwM BE0018 2025-12-02T14:19:02.982Z 2025-12-05T14:34:31.037Z
8663667 8663667 20251130212133_a3WI1 BE0018 2025-12-02T14:18:50.008Z 2025-12-05T14:34:27.660Z
8663635 8663635 20251130211255_xcyKx BE0018 2025-12-02T14:18:38.160Z 2025-12-05T14:34:26.461Z
8663565 8663565 20251130210442_bkZkC BE0018 2025-12-02T14:18:28.956Z 2025-12-05T14:34:24.515Z
8663322 8663322 20251130203025_5fncD BE0018 2025-12-02T14:17:58.313Z 2025-12-05T14:34:04.488Z
8663262 8663262 20251130202459_SmEfB BE0018 2025-12-02T14:17:54.236Z 2025-12-05T14:34:03.490Z
8663236 8663236 20251130202403_1Di2K BE0018 2025-12-02T14:17:52.609Z 2025-12-05T14:34:03.150Z
8646040 8646040 20251129005419_Ctrem BE0018 2025-11-30T14:25:05.967Z 2025-12-05T14:51:31.582Z
8645724 8645724 20251128233738_MXG3V BE0018 2025-11-30T14:24:26.776Z 2025-12-05T14:51:09.962Z
8645501 8645501 20251128222803_jJ0ot BE0018 2025-11-30T14:23:51.120Z 2025-12-05T14:50:44.294Z
8645400 8645400 20251128215642_Ev2iu BE0018 2025-11-30T14:23:40.096Z 2025-12-05T14:50:38.277Z
8645335 8645335 20251128212131_37OYy BE0018 2025-11-30T14:23:34.953Z 2025-12-05T14:50:36.897Z
8645140 8645140 20251128204222_J4xZ6 BE0018 2025-11-30T14:23:09.426Z 2025-12-05T14:50:32.302Z
8644054 8644054 20251128185412_b8fqe BE0018 2025-11-30T14:21:16.778Z 2025-12-05T14:50:15.305Z
8623605 8623605 20251127012412_FyWtL BE0018 2025-11-28T14:22:14.925Z 2025-12-05T15:04:04.458Z
8623471 8623471 20251127004646_XfI1k BE0018 2025-11-28T14:21:48.039Z 2025-12-05T15:03:54.980Z
8623408 8623408 20251127002627_ae2nn BE0018 2025-11-28T14:21:40.313Z 2025-12-05T15:03:49.518Z
8623373 8623373 20251127001633_VcAAz BE0018 2025-11-28T14:21:36.102Z 2025-12-05T15:03:45.178Z
8623022 8623022 20251126223043_03nIW BE0018 2025-11-28T14:20:30.265Z 2025-12-05T15:03:25.884Z
8622947 8622947 20251126221244_Jcger BE0018 2025-11-28T14:20:22.111Z 2025-12-05T15:03:20.546Z
8622814 8622814 20251126213737_sbDKj BE0018 2025-11-28T14:20:06.366Z 2025-12-05T15:03:14.241Z
8622406 8622406 20251126190445_r8Hli BE0018 2025-11-28T14:18:48.269Z 2025-12-05T15:02:56.532Z
8622306 8622306 20251126183929_GE1Zz BE0018 2025-11-28T14:18:21.421Z 2025-12-05T15:02:55.212Z
8622197 8622197 20251126181133_gK6Yy BE0018 2025-11-28T14:18:06.844Z 2025-12-05T15:02:53.454Z
8621843 8621843 20251126164422_lzSne BE0018 2025-11-28T14:16:52.098Z 2025-12-05T15:02:48.497Z
8607803 8607803 20251125212250_ynfBS BE0018 2025-11-27T14:14:31.843Z 2025-12-04T15:07:30.529Z
8607352 8607352 20251125204337_Eyjvr BE0018 2025-11-27T14:13:26.610Z 2025-12-04T15:07:01.080Z
8607279 8607279 20251125203536_3nee3 BE0018 2025-11-27T14:13:05.384Z 2025-12-04T15:06:59.798Z
8605763 8605763 20251125165231_Bynuo BE0018 2025-11-27T14:07:49.453Z 2025-12-04T15:05:41.164Z
8591522 8591522 20251124042231_en9q1 BE0018 2025-11-25T14:24:29.137Z 2025-12-02T15:12:59.149Z
8591086 8591086 20251124034550_NnXeP BE0018 2025-11-25T14:23:35.471Z 2025-12-02T15:12:57.043Z
8591009 8591009 20251124033537_PWRWb BE0018 2025-11-25T14:23:14.586Z 2025-12-02T15:12:56.603Z
8590876 8590876 20251124032322_vZjwm BE0018 2025-11-25T14:22:58.320Z 2025-12-02T15:12:55.927Z
8590783 8590783 20251124031024_0ecPJ BE0018 2025-11-25T14:22:47.800Z 2025-12-02T15:12:55.434Z
8590512 8590512 20251124024850_KeiEP BE0018 2025-11-25T14:22:08.702Z 2025-12-02T15:12:49.166Z
8590372 8590372 20251124023837_iO1n2 BE0018 2025-11-25T14:21:45.722Z 2025-12-02T15:12:47.201Z
8589873 8589873 20251124020056_jljsn BE0018 2025-11-25T14:20:51.236Z 2025-12-02T15:12:37.812Z
8589833 8589833 20251124015832_1msJj BE0018 2025-11-25T14:20:47.420Z 2025-12-02T15:12:37.092Z
8589664 8589664 20251124014548_9eYHM BE0018 2025-11-25T14:20:18.820Z 2025-12-02T15:12:33.111Z
8589429 8589429 20251124013357_Bfs4f BE0018 2025-11-25T14:20:04.008Z 2025-12-02T15:12:30.578Z
8589423 8589423 20251124013343_k34TV BE0018 2025-11-25T14:20:03.191Z 2025-12-02T15:12:28.435Z
8589345 8589345 20251124012605_DiC84 BE0018 2025-11-25T14:19:42.918Z 2025-12-02T15:12:20.238Z
8588918 8588918 20251124004522_gYa60 BE0018 2025-11-25T14:18:46.687Z 2025-12-02T15:12:01.141Z
8588560 8588560 20251124000819_a6xzD BE0018 2025-11-25T14:17:47.033Z 2025-12-02T15:11:49.245Z
8586754 8586754 20251123204658_A5e6I BE0018 2025-11-25T14:13:47.051Z 2025-12-02T15:11:02.582Z
8581346 8581346 20251122231341_nF5jg BE0018 2025-11-24T14:31:27.667Z 2025-12-01T15:20:14.382Z
8581323 8581323 20251122230527_2fcUs BE0018 2025-11-24T14:31:25.660Z 2025-12-01T15:20:13.659Z
8581285 8581285 20251122225436_OG51D BE0018 2025-11-24T14:31:23.811Z 2025-12-01T15:20:11.430Z
8581283 8581283 20251122225416_zdXQb BE0018 2025-11-24T14:31:23.768Z 2025-12-01T15:20:11.416Z
8581275 8581275 20251122224935_HAHDI BE0018 2025-11-24T14:31:23.591Z 2025-12-01T15:20:08.064Z
8581251 8581251 20251122222917_ZCu6U BE0018 2025-11-24T14:31:21.929Z 2025-12-01T15:20:04.947Z
8581226 8581226 20251122165354_BarCf BE0018 2025-11-24T14:29:43.992Z 2025-12-01T15:18:41.924Z
8578335 8578335 20251122202925_3ftXT BE0018 2025-11-24T14:11:25.502Z 2025-12-01T15:19:32.307Z
8577908 8577908 20251122190950_DUf6L BE0018 2025-11-24T14:10:08.798Z 2025-12-01T15:19:01.966Z
8577758 8577758 20251122185330_JdjDz BE0018 2025-11-24T14:09:35.943Z 2025-12-01T15:18:57.355Z
8577712 8577712 20251122184953_kcfhZ BE0018 2025-11-24T14:09:29.918Z 2025-12-01T15:18:56.760Z
8577701 8577701 20251122184811_UXjOj BE0018 2025-11-24T14:09:28.320Z 2025-12-01T15:18:56.667Z
8577463 8577463 20251122181147_5fowB BE0018 2025-11-24T14:08:40.690Z 2025-12-01T15:18:50.956Z
8577366 8577366 20251122175939_T2RUV BE0018 2025-11-24T14:08:28.943Z 2025-12-01T15:18:48.350Z
8577293 8577293 20251122175227_Nm3Dq BE0018 2025-11-24T14:08:12.547Z 2025-12-01T15:18:46.792Z
8577202 8577202 20251122173208_qCFhA BE0018 2025-11-24T14:07:56.508Z 2025-12-01T15:18:44.711Z
8577063 8577063 20251122171402_l8Ikd BE0018 2025-11-24T14:07:26.446Z 2025-12-01T15:18:42.857Z
8574238 8574238 20251122053512_WFQT9 BE0018 2025-11-23T14:42:59.738Z 2025-11-30T15:07:03.339Z
8574186 8574186 20251122052253_r1mEl BE0018 2025-11-23T14:42:45.312Z 2025-11-30T15:07:01.765Z
8574154 8574154 20251122051847_agaTa BE0018 2025-11-23T14:42:27.221Z 2025-11-30T15:07:00.456Z
8574023 8574023 20251122050020_100Mq BE0018 2025-11-23T14:42:12.302Z 2025-11-30T15:06:55.772Z

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