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

7,184 rows where station_code = "BE000D" 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
8687113 8687113 20251204044100_60g9B BE000D 2025-12-05T14:13:55.161Z 2025-12-05T14:14:35.623Z
8687107 8687107 20251204043613_J78XV BE000D 2025-12-05T14:13:54.665Z 2025-12-05T14:14:35.621Z
8687076 8687076 20251204031129_VOg2x BE000D 2025-12-05T14:13:49.590Z 2025-12-05T14:14:35.606Z
8687074 8687074 20251204031018_bf9zK BE000D 2025-12-05T14:13:49.223Z 2025-12-05T14:14:35.604Z
8687050 8687050 20251204022755_w33uV BE000D 2025-12-05T14:13:44.198Z 2025-12-05T14:14:35.588Z
8687040 8687040 20251204020659_OcvuP BE000D 2025-12-05T14:13:41.439Z 2025-12-05T14:14:35.581Z
8687030 8687030 20251204015116_IAIlW BE000D 2025-12-05T14:13:31.182Z 2025-12-05T14:14:35.575Z
8681812 8681812 20251203041008_OU7Sg BE000D 2025-12-04T14:15:39.817Z 2025-12-05T14:22:02.310Z
8681597 8681597 20251203032804_S74Nq BE000D 2025-12-04T14:15:06.201Z 2025-12-05T14:21:42.562Z
8681425 8681425 20251203030821_ysmb7 BE000D 2025-12-04T14:14:42.043Z 2025-12-05T14:21:36.712Z
8681400 8681400 20251203030505_9W4qr BE000D 2025-12-04T14:14:38.916Z 2025-12-05T14:21:35.506Z
8664772 8664772 20251201013634_4nXAD BE000D 2025-12-02T14:22:03.309Z 2025-12-05T14:35:17.502Z
8664662 8664662 20251201012006_OKx89 BE000D 2025-12-02T14:21:45.633Z 2025-12-05T14:35:12.073Z
8664614 8664614 20251201011223_VvIA2 BE000D 2025-12-02T14:21:38.262Z 2025-12-05T14:35:10.531Z
8664524 8664524 20251201005028_6TXfv BE000D 2025-12-02T14:21:15.870Z 2025-12-05T14:35:07.112Z
8664304 8664304 20251201000059_8BptF BE000D 2025-12-02T14:20:40.898Z 2025-12-05T14:35:00.138Z
8664299 8664299 20251201000018_jEkrI BE000D 2025-12-02T14:20:40.599Z 2025-12-05T14:35:00.028Z
8664292 8664292 20251130235913_xSmNt BE000D 2025-12-02T14:20:39.874Z 2025-12-05T14:34:59.868Z
8664126 8664126 20251130231905_2EW6V BE000D 2025-12-02T14:20:07.381Z 2025-12-05T14:34:53.477Z
8664098 8664098 20251130231700_7lRG9 BE000D 2025-12-02T14:20:05.045Z 2025-12-05T14:34:52.767Z
8664090 8664090 20251130231621_j3xwo BE000D 2025-12-02T14:20:04.437Z 2025-12-05T14:34:51.930Z
8663989 8663989 20251130225429_B253Y BE000D 2025-12-02T14:19:45.643Z 2025-12-05T14:34:41.077Z
8663871 8663871 20251130222159_3wOAA BE000D 2025-12-02T14:19:29.174Z 2025-12-05T14:34:35.072Z
8663858 8663858 20251130222056_c86jz BE000D 2025-12-02T14:19:27.366Z 2025-12-05T14:34:34.668Z
8663841 8663841 20251130221744_gQ6tc BE000D 2025-12-02T14:19:23.889Z 2025-12-05T14:34:33.865Z
8663806 8663806 20251130220840_fJZEB BE000D 2025-12-02T14:19:12.796Z 2025-12-05T14:34:32.989Z
8663625 8663625 20251130211212_wX3Qy BE000D 2025-12-02T14:18:37.731Z 2025-12-05T14:34:26.375Z
8663553 8663553 20251130210234_WjCq7 BE000D 2025-12-02T14:18:27.553Z 2025-12-05T14:34:24.170Z
8663182 8663182 20251130201918_F4Zrk BE000D 2025-12-02T14:17:36.674Z 2025-12-05T14:33:59.496Z
8663113 8663113 20251130201149_xJgjI BE000D 2025-12-02T14:17:29.144Z 2025-12-05T14:33:57.696Z
8663098 8663098 20251130201010_JhApc BE000D 2025-12-02T14:17:27.170Z 2025-12-05T14:33:57.160Z
8662689 8662689 20251130192034_D6rRe BE000D 2025-12-02T14:16:18.534Z 2025-12-05T14:33:43.468Z
8651037 8651037 20251129222831_VEotI BE000D 2025-12-01T14:17:53.122Z 2025-12-05T14:41:35.150Z
8651034 8651034 20251129222828_y7oX0 BE000D 2025-12-01T14:17:52.858Z 2025-12-05T14:41:34.917Z
8650865 8650865 20251129214644_20U8Z BE000D 2025-12-01T14:17:23.829Z 2025-12-05T14:41:21.419Z
8645934 8645934 20251129003105_DRwRN BE000D 2025-11-30T14:24:56.817Z 2025-12-05T14:51:28.856Z
8645398 8645398 20251128215642_Ev2iu BE000D 2025-11-30T14:23:40.084Z 2025-12-05T14:50:38.277Z
8621972 8621972 20251126172051_1n4TP BE000D 2025-11-28T14:17:11.568Z 2025-12-05T15:02:50.141Z
8616507 8616507 20251126060402_efCxf BE000D 2025-11-27T14:31:14.642Z 2025-12-04T15:11:40.318Z
8615429 8615429 20251126050318_hE9IB BE000D 2025-11-27T14:29:32.066Z 2025-12-04T15:11:28.826Z
8615363 8615363 20251126045846_NYw4T BE000D 2025-11-27T14:29:28.945Z 2025-12-04T15:11:28.069Z
8614911 8614911 20251126043634_ilYDB BE000D 2025-11-27T14:28:42.513Z 2025-12-04T15:11:21.152Z
8614850 8614850 20251126043127_3q2Ds BE000D 2025-11-27T14:28:37.763Z 2025-12-04T15:11:14.839Z
8614584 8614584 20251126041910_fAnsq BE000D 2025-11-27T14:28:03.841Z 2025-12-04T15:10:53.044Z
8613857 8613857 20251126033742_genaA BE000D 2025-11-27T14:26:52.557Z 2025-12-04T15:09:52.845Z
8613441 8613441 20251126031817_GeMaA BE000D 2025-11-27T14:26:05.378Z 2025-12-04T15:09:40.614Z
8613129 8613129 20251126030332_E9h3p BE000D 2025-11-27T14:25:25.331Z 2025-12-04T15:09:37.546Z
8613109 8613109 20251126030236_0mCG2 BE000D 2025-11-27T14:25:24.398Z 2025-12-04T15:09:37.329Z
8612952 8612952 20251126025736_cBACh BE000D 2025-11-27T14:25:02.594Z 2025-12-04T15:09:36.098Z
8612871 8612871 20251126025324_2osDh BE000D 2025-11-27T14:24:57.151Z 2025-12-04T15:09:35.397Z
8612819 8612819 20251126024918_94aaf BE000D 2025-11-27T14:24:52.438Z 2025-12-04T15:09:34.526Z
8612767 8612767 20251126024444_8jNDq BE000D 2025-11-27T14:24:37.892Z 2025-12-04T15:09:33.905Z
8612426 8612426 20251126023115_WpjmZ BE000D 2025-11-27T14:24:09.822Z 2025-12-04T15:09:30.623Z
8612245 8612245 20251126022254_B2pct BE000D 2025-11-27T14:23:39.490Z 2025-12-04T15:09:28.535Z
8612156 8612156 20251126022006_59HBU BE000D 2025-11-27T14:23:34.176Z 2025-12-04T15:09:28.029Z
8612065 8612065 20251126021556_bIbhS BE000D 2025-11-27T14:23:28.137Z 2025-12-04T15:09:27.236Z
8611787 8611787 20251126020018_asavM BE000D 2025-11-27T14:22:52.769Z 2025-12-04T15:09:24.192Z
8611776 8611776 20251126015912_mrdVg BE000D 2025-11-27T14:22:44.194Z 2025-12-04T15:09:24.075Z
8611717 8611717 20251126015730_CyIsJ BE000D 2025-11-27T14:22:32.393Z 2025-12-04T15:09:23.697Z
8611326 8611326 20251126013722_gbzZ3 BE000D 2025-11-27T14:21:52.015Z 2025-12-04T15:09:10.123Z
8609159 8609159 20251125231644_mKGZ7 BE000D 2025-11-27T14:17:37.749Z 2025-12-04T15:07:51.994Z
8608243 8608243 20251125220324_BfYOH BE000D 2025-11-27T14:15:36.792Z 2025-12-04T15:07:43.000Z
8608150 8608150 20251125215218_222eh BE000D 2025-11-27T14:15:27.716Z 2025-12-04T15:07:41.661Z
8608091 8608091 20251125214921_6qti3 BE000D 2025-11-27T14:15:17.575Z 2025-12-04T15:07:41.151Z
8597643 8597643 20251124235610_wKVhZ BE000D 2025-11-26T14:17:15.773Z 2025-12-02T15:07:38.649Z
8597542 8597542 20251124234410_Z1YxN BE000D 2025-11-26T14:17:06.249Z 2025-12-02T15:07:37.407Z
8597132 8597132 20251124230436_qn3Oh BE000D 2025-11-26T14:16:14.546Z 2025-12-02T15:07:23.409Z
8597080 8597080 20251124225244_SGlqR BE000D 2025-11-26T14:15:58.120Z 2025-12-02T15:07:22.837Z
8596620 8596620 20251124214325_322Yz BE000D 2025-11-26T14:15:01.188Z 2025-12-02T15:07:03.538Z
8591081 8591081 20251124034548_dTaey BE000D 2025-11-25T14:23:35.129Z 2025-12-02T15:12:57.036Z
8590805 8590805 20251124031259_sbbbD BE000D 2025-11-25T14:22:50.481Z 2025-12-02T15:12:55.551Z
8590478 8590478 20251124024509_Z33TS BE000D 2025-11-25T14:22:06.369Z 2025-12-02T15:12:48.650Z
8590331 8590331 20251124023527_3N2BI BE000D 2025-11-25T14:21:43.830Z 2025-12-02T15:12:46.929Z
8590152 8590152 20251124022651_NK2sa BE000D 2025-11-25T14:21:29.767Z 2025-12-02T15:12:43.015Z
8590031 8590031 20251124021714_0vziO BE000D 2025-11-25T14:21:08.954Z 2025-12-02T15:12:41.533Z
8589867 8589867 20251124020044_O0ouz BE000D 2025-11-25T14:20:50.846Z 2025-12-02T15:12:37.788Z
8589805 8589805 20251124015527_WTxXX BE000D 2025-11-25T14:20:44.979Z 2025-12-02T15:12:36.069Z
8589784 8589784 20251124015255_cYymP BE000D 2025-11-25T14:20:42.482Z 2025-12-02T15:12:35.743Z
8589577 8589577 20251124014125_furmd BE000D 2025-11-25T14:20:13.496Z 2025-12-02T15:12:32.526Z
8589406 8589406 20251124013127_TxIrb BE000D 2025-11-25T14:19:57.926Z 2025-12-02T15:12:26.211Z
8589196 8589196 20251124011321_QpK0o BE000D 2025-11-25T14:19:26.018Z 2025-12-02T15:12:10.976Z
8589132 8589132 20251124010629_glM4S BE000D 2025-11-25T14:19:07.792Z 2025-12-02T15:12:09.622Z
8589120 8589120 20251124010354_2R3LZ BE000D 2025-11-25T14:19:06.310Z 2025-12-02T15:12:09.075Z
8589038 8589038 20251124005553_ZUkRX BE000D 2025-11-25T14:18:54.842Z 2025-12-02T15:12:03.862Z
8588821 8588821 20251124003412_G03CU BE000D 2025-11-25T14:18:21.402Z 2025-12-02T15:11:56.538Z
8588690 8588690 20251124002120_RH9qL BE000D 2025-11-25T14:18:08.415Z 2025-12-02T15:11:50.025Z
8588242 8588242 20251123233437_Sabo1 BE000D 2025-11-25T14:17:07.451Z 2025-12-02T15:11:38.516Z
8588144 8588144 20251123232750_8QCCh BE000D 2025-11-25T14:16:57.994Z 2025-12-02T15:11:28.859Z
8587501 8587501 20251123221033_UeGME BE000D 2025-11-25T14:15:24.521Z 2025-12-02T15:11:16.461Z
8577272 8577272 20251122175041_tzgKp BE000D 2025-11-24T14:08:10.708Z 2025-12-01T15:18:46.258Z
8573696 8573696 20251122035544_9XRd2 BE000D 2025-11-23T14:41:55.171Z 2025-11-30T15:06:35.885Z
8573604 8573604 20251122034230_5tLv6 BE000D 2025-11-23T14:41:25.864Z 2025-11-30T15:06:32.658Z
8573438 8573438 20251122031212_WX3Zg BE000D 2025-11-23T14:41:11.706Z 2025-11-30T15:06:24.533Z
8573371 8573371 20251122030135_fYmEv BE000D 2025-11-23T14:41:08.487Z 2025-11-30T15:06:19.540Z
8573344 8573344 20251122025908_2uGTT BE000D 2025-11-23T14:41:06.971Z 2025-11-30T15:06:16.457Z
8573334 8573334 20251122025806_aM118 BE000D 2025-11-23T14:41:06.606Z 2025-11-30T15:06:16.282Z
8573282 8573282 20251122025029_qxpug BE000D 2025-11-23T14:41:04.317Z 2025-11-30T15:06:13.712Z
8573248 8573248 20251122024802_1yaM0 BE000D 2025-11-23T14:41:02.328Z 2025-11-30T15:06:12.953Z
8573230 8573230 20251122024404_zHhge BE000D 2025-11-23T14:41:01.607Z 2025-11-30T15:06:12.613Z
8573075 8573075 20251122022557_C2x9j BE000D 2025-11-23T14:40:42.974Z 2025-11-30T15:06:09.249Z

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