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

5,140 rows where station_code = "BE000S" 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
8750703 8750703 20251209191442_ff1Hx BE000S 2025-12-13T15:38:40.278Z 2025-12-14T15:43:30.661Z
8750555 8750555 20251209185323_e26n4 BE000S 2025-12-13T15:38:25.731Z 2025-12-14T15:43:19.177Z
8750536 8750536 20251209184917_BDQFj BE000S 2025-12-13T15:38:16.324Z 2025-12-14T15:43:17.116Z
8750365 8750365 20251209181215_z3vHw BE000S 2025-12-13T15:37:58.091Z 2025-12-14T15:43:09.930Z
8750266 8750266 20251209175657_szbtZ BE000S 2025-12-13T15:37:53.780Z 2025-12-14T15:43:06.002Z
8750258 8750258 20251209175519_wUN8h BE000S 2025-12-13T15:37:53.284Z 2025-12-14T15:43:05.612Z
8746428 8746428 20251211030256_davk6 BE000S 2025-12-13T15:28:46.320Z 2025-12-14T15:35:56.344Z
8746162 8746162 20251211024122_04pOD BE000S 2025-12-13T15:28:33.229Z 2025-12-14T15:35:40.862Z
8746062 8746062 20251211023613_owE0x BE000S 2025-12-13T15:28:28.855Z 2025-12-14T15:35:34.465Z
8745106 8745106 20251211012845_5RUmL BE000S 2025-12-13T15:26:58.764Z 2025-12-14T15:34:33.795Z
8744472 8744472 20251211004512_Vki2j BE000S 2025-12-13T15:26:11.238Z 2025-12-14T15:33:50.591Z
8744048 8744048 20251211001113_KYIJP BE000S 2025-12-13T15:25:29.019Z 2025-12-14T15:33:39.538Z
8743507 8743507 20251210233209_NPzy3 BE000S 2025-12-13T15:24:15.320Z 2025-12-14T15:33:09.051Z
8743465 8743465 20251210232914_gx2TB BE000S 2025-12-13T15:24:12.903Z 2025-12-14T15:33:06.865Z
8742738 8742738 20251210224057_pV7s4 BE000S 2025-12-13T15:23:06.263Z 2025-12-14T15:32:17.133Z
8742732 8742732 20251210224046_mKMbk BE000S 2025-12-13T15:23:05.716Z 2025-12-14T15:32:15.519Z
8741340 8741340 20251210211001_Hjm8h BE000S 2025-12-13T15:20:35.496Z 2025-12-14T15:30:44.858Z
8741066 8741066 20251210204234_j7fo1 BE000S 2025-12-13T15:19:58.683Z 2025-12-14T15:30:29.910Z
8713408 8713408 20251209034324_TiVJK BE000S 2025-12-10T14:16:21.358Z 2025-12-14T15:55:06.914Z
8713391 8713391 20251209034039_D1A2l BE000S 2025-12-10T14:16:19.862Z 2025-12-14T15:55:06.360Z
8713339 8713339 20251209033036_7Z38x BE000S 2025-12-10T14:16:15.325Z 2025-12-14T15:55:03.714Z
8713332 8713332 20251209032907_JtbWV BE000S 2025-12-10T14:16:14.506Z 2025-12-14T15:55:03.444Z
8713328 8713328 20251209032718_PgEv2 BE000S 2025-12-10T14:16:09.586Z 2025-12-14T15:55:03.194Z
8713212 8713212 20251209030230_ufmaf BE000S 2025-12-10T14:15:54.708Z 2025-12-14T15:55:00.145Z
8713068 8713068 20251209023001_iwQGW BE000S 2025-12-10T14:15:35.014Z 2025-12-14T15:54:56.128Z
8712656 8712656 20251209003837_Rak4x BE000S 2025-12-10T14:14:32.244Z 2025-12-14T15:54:06.395Z
8712619 8712619 20251209002815_xIXtQ BE000S 2025-12-10T14:14:28.221Z 2025-12-14T15:54:04.341Z
8712566 8712566 20251209000354_BKIlC BE000S 2025-12-10T14:14:19.822Z 2025-12-14T15:54:02.854Z
8712421 8712421 20251208225123_vjY4l BE000S 2025-12-10T14:13:55.818Z 2025-12-14T15:53:56.560Z
8687179 8687179 20251204053245_GsKAg BE000S 2025-12-05T14:14:19.432Z 2025-12-11T14:42:04.119Z
8666667 8666667 20251130182554_mEpKm BE000S 2025-12-02T14:27:05.552Z 2025-12-09T14:56:34.180Z
8666049 8666049 20251201042740_rDAV2 BE000S 2025-12-02T14:25:09.028Z 2025-12-09T14:59:36.508Z
8665939 8665939 20251201041157_xcoiA BE000S 2025-12-02T14:24:56.758Z 2025-12-09T14:59:29.876Z
8665763 8665763 20251201035620_3nDdx BE000S 2025-12-02T14:24:26.769Z 2025-12-09T14:59:01.507Z
8665758 8665758 20251201035511_b32A4 BE000S 2025-12-02T14:24:26.256Z 2025-12-09T14:59:01.440Z
8665740 8665740 20251201035302_qZAy9 BE000S 2025-12-02T14:24:23.696Z 2025-12-09T14:59:01.061Z
8665736 8665736 20251201035232_1Rk0D BE000S 2025-12-02T14:24:23.378Z 2025-12-09T14:59:01.016Z
8665698 8665698 20251201035108_fNAWU BE000S 2025-12-02T14:24:20.757Z 2025-12-09T14:59:00.241Z
8665620 8665620 20251201034415_Kn6u6 BE000S 2025-12-02T14:24:12.953Z 2025-12-09T14:58:58.613Z
8665591 8665591 20251201034025_N3Ute BE000S 2025-12-02T14:23:57.763Z 2025-12-09T14:58:55.791Z
8665559 8665559 20251201033507_ZzgeG BE000S 2025-12-02T14:23:54.215Z 2025-12-09T14:58:55.279Z
8665510 8665510 20251201033010_Rr2j9 BE000S 2025-12-02T14:23:48.255Z 2025-12-09T14:58:54.250Z
8665494 8665494 20251201032708_plRj2 BE000S 2025-12-02T14:23:46.962Z 2025-12-09T14:58:54.045Z
8665398 8665398 20251201031540_OX6iM BE000S 2025-12-02T14:23:37.707Z 2025-12-09T14:58:52.118Z
8665355 8665355 20251201031047_859z7 BE000S 2025-12-02T14:23:33.799Z 2025-12-09T14:58:51.252Z
8665292 8665292 20251201030222_ZtZnd BE000S 2025-12-02T14:23:18.235Z 2025-12-09T14:58:50.309Z
8665221 8665221 20251201024846_nh7q2 BE000S 2025-12-02T14:23:09.776Z 2025-12-09T14:58:48.184Z
8665183 8665183 20251201024438_OmtXs BE000S 2025-12-02T14:23:05.614Z 2025-12-09T14:58:47.340Z
8665179 8665179 20251201024250_JpoX8 BE000S 2025-12-02T14:23:04.864Z 2025-12-09T14:58:47.228Z
8665113 8665113 20251201023228_322lh BE000S 2025-12-02T14:22:57.324Z 2025-12-09T14:58:45.735Z
8665046 8665046 20251201022053_Mvd0W BE000S 2025-12-02T14:22:41.617Z 2025-12-09T14:58:44.096Z
8664905 8664905 20251201020304_Ur9Pr BE000S 2025-12-02T14:22:25.746Z 2025-12-09T14:58:40.973Z
8664903 8664903 20251201020234_FxsJt BE000S 2025-12-02T14:22:25.380Z 2025-12-09T14:58:40.925Z
8664855 8664855 20251201015133_rDdv7 BE000S 2025-12-02T14:22:13.420Z 2025-12-09T14:58:39.619Z
8664811 8664811 20251201014327_m9o4j BE000S 2025-12-02T14:22:07.709Z 2025-12-09T14:58:38.359Z
8664799 8664799 20251201014206_w7fdz BE000S 2025-12-02T14:22:06.268Z 2025-12-09T14:58:38.117Z
8664686 8664686 20251201012501_vq4u4 BE000S 2025-12-02T14:21:47.973Z 2025-12-09T14:58:35.064Z
8664552 8664552 20251201005533_3NHfD BE000S 2025-12-02T14:21:21.002Z 2025-12-09T14:58:13.846Z
8664533 8664533 20251201005309_gLM72 BE000S 2025-12-02T14:21:16.753Z 2025-12-09T14:58:13.295Z
8664482 8664482 20251201004022_YZ8H5 BE000S 2025-12-02T14:21:11.367Z 2025-12-09T14:58:12.205Z
8664445 8664445 20251201002838_ADfuH BE000S 2025-12-02T14:21:05.625Z 2025-12-09T14:58:11.356Z
8664391 8664391 20251201001405_2ZBOc BE000S 2025-12-02T14:20:58.557Z 2025-12-09T14:58:07.914Z
8664378 8664378 20251201001244_YW3I8 BE000S 2025-12-02T14:20:57.325Z 2025-12-09T14:58:07.792Z
8664277 8664277 20251130235634_MUfMN BE000S 2025-12-02T14:20:38.354Z 2025-12-09T14:58:05.333Z
8664166 8664166 20251130232948_WDyGG BE000S 2025-12-02T14:20:14.010Z 2025-12-09T14:58:03.033Z
8664138 8664138 20251130232505_N0DEd BE000S 2025-12-02T14:20:09.268Z 2025-12-09T14:58:02.311Z
8663888 8663888 20251130223031_A5rrI BE000S 2025-12-02T14:19:32.002Z 2025-12-09T14:57:57.106Z
8663592 8663592 20251130210617_i2E5Q BE000S 2025-12-02T14:18:31.894Z 2025-12-09T14:57:34.522Z
8663069 8663069 20251130200442_0XO5W BE000S 2025-12-02T14:17:23.637Z 2025-12-09T14:57:24.464Z
8662554 8662554 20251130190956_bMbLG BE000S 2025-12-02T14:15:52.797Z 2025-12-09T14:56:57.259Z
8662480 8662480 20251130185615_yUcoQ BE000S 2025-12-02T14:15:42.276Z 2025-12-09T14:56:41.367Z
8662415 8662415 20251130184706_PWTki BE000S 2025-12-02T14:15:25.261Z 2025-12-09T14:56:39.668Z
8662329 8662329 20251130183414_43MTI BE000S 2025-12-02T14:15:09.403Z 2025-12-09T14:56:37.483Z
8662281 8662281 20251130182552_DXUN6 BE000S 2025-12-02T14:14:53.907Z 2025-12-09T14:56:34.091Z
8662111 8662111 20251130180109_DQNn8 BE000S 2025-12-02T14:14:21.274Z 2025-12-09T14:56:29.524Z
8655758 8655758 20251130041641_2eJFK BE000S 2025-12-01T14:27:26.937Z 2025-12-01T14:27:26.937Z
8655625 8655625 20251130041015_2wGxi BE000S 2025-12-01T14:27:18.686Z 2025-12-08T14:56:01.217Z
8655458 8655458 20251130040315_ARwKK BE000S 2025-12-01T14:26:55.352Z 2025-12-08T14:55:59.073Z
8624280 8624280 20251127035556_WCyWw BE000S 2025-11-28T14:24:24.202Z 2025-12-05T15:04:57.409Z
8624089 8624089 20251127030414_92Wyo BE000S 2025-11-28T14:23:45.312Z 2025-12-05T15:04:43.961Z
8623823 8623823 20251127021306_Tarue BE000S 2025-11-28T14:22:57.438Z 2025-12-05T15:04:18.546Z
8623760 8623760 20251127015507_eJI6y BE000S 2025-11-28T14:22:49.786Z 2025-12-05T15:04:15.131Z
8623654 8623654 20251127013724_TNatz BE000S 2025-11-28T14:22:20.402Z 2025-12-05T15:04:06.105Z
8623612 8623612 20251127012625_2OobJ BE000S 2025-11-28T14:22:15.554Z 2025-12-05T15:04:04.591Z
8622530 8622530 20251126194535_wYz24 BE000S 2025-11-28T14:19:06.190Z 2025-12-05T15:03:03.004Z
8622468 8622468 20251126192634_PHm5r BE000S 2025-11-28T14:18:55.537Z 2025-12-05T15:03:01.845Z
8622267 8622267 20251126183125_v4cmY BE000S 2025-11-28T14:18:16.943Z 2025-12-05T15:02:54.653Z
8622175 8622175 20251126180713_rFdaU BE000S 2025-11-28T14:18:03.866Z 2025-12-05T15:02:53.225Z
8622099 8622099 20251126175027_7JnYM BE000S 2025-11-28T14:17:41.853Z 2025-12-05T15:02:52.209Z
8595754 8595754 20251124181916_PrTnj BE000S 2025-11-26T14:12:23.479Z 2025-12-02T15:06:08.891Z
8595711 8595711 20251124180457_qAusb BE000S 2025-11-26T14:12:16.632Z 2025-12-02T15:06:05.983Z
8579251 8579251 20251122225523_ChIZ6 BE000S 2025-11-24T14:13:52.174Z 2025-12-01T15:20:11.605Z
8579054 8579054 20251122221258_sZ8td BE000S 2025-11-24T14:13:23.624Z 2025-12-01T15:20:00.389Z
8578959 8578959 20251122215706_oVKkG BE000S 2025-11-24T14:13:11.216Z 2025-11-24T14:13:11.216Z
8578870 8578870 20251122214300_j48dz BE000S 2025-11-24T14:12:54.250Z 2025-12-01T15:19:54.819Z
8578865 8578865 20251122214208_iCjcG BE000S 2025-11-24T14:12:53.058Z 2025-11-24T14:12:53.058Z
8578819 8578819 20251122213006_TKpFC BE000S 2025-11-24T14:12:46.440Z 2025-11-24T14:12:46.440Z
8578109 8578109 20251122194228_J1snp BE000S 2025-11-24T14:10:45.954Z 2025-12-01T15:19:09.031Z
8578073 8578073 20251122193603_1pABI BE000S 2025-11-24T14:10:40.623Z 2025-12-01T15:19:08.067Z
8577555 8577555 20251122182920_4dtEm BE000S 2025-11-24T14:09:02.600Z 2025-12-01T15:18:53.945Z

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