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 = "USL00A" 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
6271637 6271637 20250304115006_H5xQn USL00A 2025-03-07T15:13:22.601Z 2025-03-11T13:25:31.724Z
6271611 6271611 20250304114654_rn4cC USL00A 2025-03-07T15:13:20.733Z 2025-03-11T13:25:31.246Z
6271588 6271588 20250304114422_vEQxD USL00A 2025-03-07T15:13:18.224Z 2025-03-11T13:25:30.289Z
6271554 6271554 20250304113804_BTh3U USL00A 2025-03-07T15:13:13.854Z 2025-03-11T13:25:29.395Z
6271533 6271533 20250304113106_LisUG USL00A 2025-03-07T15:13:11.894Z 2025-03-11T13:25:28.669Z
6271519 6271519 20250304112930_zQvkt USL00A 2025-03-07T15:13:08.272Z 2025-03-11T13:25:28.168Z
6271500 6271500 20250304112723_IMBcC USL00A 2025-03-07T15:13:07.405Z 2025-03-11T13:25:27.817Z
6271401 6271401 20250304110015_8Svnt USL00A 2025-03-07T15:12:55.923Z 2025-03-11T13:25:23.395Z
6271382 6271382 20250304105128_DN12P USL00A 2025-03-07T15:12:52.557Z 2025-03-11T13:25:18.145Z
6271377 6271377 20250304105050_JHIT6 USL00A 2025-03-07T15:12:52.333Z 2025-03-11T13:25:16.713Z
6271363 6271363 20250304104815_mxtln USL00A 2025-03-07T15:12:51.519Z 2025-03-11T13:25:07.676Z
6271344 6271344 20250304104328_U3jNT USL00A 2025-03-07T15:12:48.048Z 2025-03-11T13:25:01.686Z
6271329 6271329 20250304103804_4byVx USL00A 2025-03-07T15:12:46.552Z 2025-03-11T13:25:01.113Z
6271233 6271233 20250304101649_tQatV USL00A 2025-03-07T15:12:33.086Z 2025-03-11T13:24:58.322Z
6271087 6271087 20250304092949_kcXHu USL00A 2025-03-07T15:12:14.982Z 2025-03-11T13:24:52.785Z
6271028 6271028 20250304091028_EElG3 USL00A 2025-03-07T15:12:09.039Z 2025-03-11T13:24:50.919Z
6271013 6271013 20250304090400_xUTCi USL00A 2025-03-07T15:12:07.846Z 2025-03-11T13:24:50.377Z
6271000 6271000 20250304090048_rrRzJ USL00A 2025-03-07T15:12:07.026Z 2025-03-11T13:24:50.092Z
6270986 6270986 20250304085558_VVLgF USL00A 2025-03-07T15:12:05.274Z 2025-03-11T13:24:49.592Z
6270963 6270963 20250304084840_HfX6W USL00A 2025-03-07T15:12:02.524Z 2025-03-11T13:24:49.000Z
6262784 6262784 20250305124855_jMSI3 USL00A 2025-03-07T14:58:31.698Z 2025-03-13T12:43:30.598Z
6262702 6262702 20250305123844_SscNP USL00A 2025-03-07T14:58:24.964Z 2025-03-13T12:43:29.903Z
6262662 6262662 20250305123634_0i2m2 USL00A 2025-03-07T14:58:21.261Z 2025-03-13T12:43:29.508Z
6262557 6262557 20250305122744_vT2Ia USL00A 2025-03-07T14:58:14.557Z 2025-03-13T12:43:28.590Z
6262508 6262508 20250305122351_6SmE5 USL00A 2025-03-07T14:58:08.797Z 2025-03-13T12:43:27.897Z
6262368 6262368 20250305121514_qhP72 USL00A 2025-03-07T14:57:53.134Z 2025-03-13T12:43:26.351Z
6261820 6261820 20250305113044_n7jw8 USL00A 2025-03-07T14:57:01.930Z 2025-03-13T12:43:17.076Z
6261783 6261783 20250305112730_GAdVl USL00A 2025-03-07T14:56:58.247Z 2025-03-13T12:43:16.928Z
6261638 6261638 20250305111213_D93A3 USL00A 2025-03-07T14:56:43.178Z 2025-03-13T12:43:15.786Z
6261606 6261606 20250305110854_D6HEF USL00A 2025-03-07T14:56:40.439Z 2025-03-13T12:43:14.382Z
6261489 6261489 20250305105443_bT4Pw USL00A 2025-03-07T14:56:28.360Z 2025-03-13T12:43:13.034Z
6261453 6261453 20250305104948_nLa1A USL00A 2025-03-07T14:56:25.346Z 2025-03-13T12:43:11.959Z
6261364 6261364 20250305104008_dHq63 USL00A 2025-03-07T14:56:17.347Z 2025-03-13T12:43:10.327Z
6261310 6261310 20250305103630_MJPA3 USL00A 2025-03-07T14:56:12.771Z 2025-03-13T12:43:10.106Z
6261127 6261127 20250305102111_M8jfo USL00A 2025-03-07T14:55:45.356Z 2025-03-13T12:43:06.693Z
6261019 6261019 20250305100918_jLRoE USL00A 2025-03-07T14:55:21.860Z 2025-03-13T12:43:05.840Z
6260937 6260937 20250305095351_2F9Pg USL00A 2025-03-07T14:55:11.927Z 2025-03-13T12:43:02.701Z
6260872 6260872 20250305094746_V2tbm USL00A 2025-03-07T14:55:04.481Z 2025-03-13T12:43:01.113Z
6260712 6260712 20250305092842_PfktS USL00A 2025-03-07T14:54:52.903Z 2025-03-13T12:42:55.931Z
6260696 6260696 20250305092653_ysNel USL00A 2025-03-07T14:54:51.497Z 2025-03-13T12:42:55.327Z
6260676 6260676 20250305092613_WgMxd USL00A 2025-03-07T14:54:50.966Z 2025-03-13T12:42:55.239Z
6260630 6260630 20250305092157_HyO3k USL00A 2025-03-07T14:54:47.165Z 2025-03-13T12:42:54.156Z
6260531 6260531 20250305090836_lyN13 USL00A 2025-03-07T14:54:37.401Z 2025-03-13T12:42:49.608Z
6260371 6260371 20250305084057_DswtV USL00A 2025-03-07T14:54:06.532Z 2025-03-13T12:42:43.684Z
6260233 6260233 20250305081210_kAig7 USL00A 2025-03-07T14:53:27.221Z 2025-03-13T12:42:41.105Z
6260031 6260031 20250305071541_UN83j USL00A 2025-03-07T14:53:05.412Z 2025-03-13T12:42:36.757Z
6260008 6260008 20250305070632_PQi4z USL00A 2025-03-07T14:53:03.346Z 2025-03-13T12:42:36.172Z
6259966 6259966 20250305065236_PXqX4 USL00A 2025-03-07T14:52:59.704Z 2025-03-13T12:42:35.825Z
6259891 6259891 20250305061609_2JcNI USL00A 2025-03-07T14:52:50.151Z 2025-03-13T12:42:33.425Z
6259437 6259437 20250305043937_7x8C3 USL00A 2025-03-07T14:51:42.953Z 2025-03-13T12:42:24.000Z
6258235 6258235 20250305025657_BR3Hl USL00A 2025-03-07T14:49:12.155Z 2025-03-13T12:42:03.138Z
6236900 6236900 20250225094420_KcV2R USL00A 2025-03-05T15:20:43.845Z 2025-03-05T15:20:43.845Z
6236865 6236865 20250225064524_r1alO USL00A 2025-03-05T15:19:28.343Z 2025-03-05T15:19:28.343Z
6236830 6236830 20250225025811_8GzlF USL00A 2025-03-05T15:18:03.850Z 2025-03-05T15:18:03.850Z
6236698 6236698 20250226084402_yMc0i USL00A 2025-03-05T15:09:12.068Z 2025-03-06T14:52:39.423Z
6236692 6236692 20250226082821_36s3p USL00A 2025-03-05T15:09:01.903Z 2025-03-06T14:52:37.528Z
6236687 6236687 20250226080740_OuE5X USL00A 2025-03-05T15:08:43.042Z 2025-03-06T14:52:35.037Z
6236683 6236683 20250226080504_KMxkx USL00A 2025-03-05T15:08:39.513Z 2025-03-06T14:52:34.518Z
6236670 6236670 20250226071653_TuSdQ USL00A 2025-03-05T15:07:50.725Z 2025-03-06T14:52:17.433Z
6236667 6236667 20250226065639_yGwA2 USL00A 2025-03-05T15:07:45.968Z 2025-03-06T14:52:05.797Z
6236659 6236659 20250226062513_b03l1 USL00A 2025-03-05T15:07:39.245Z 2025-03-06T14:52:00.459Z
6236655 6236655 20250226062109_ltw6G USL00A 2025-03-05T15:07:37.818Z 2025-03-06T14:51:59.734Z
6236651 6236651 20250226061536_2jLyZ USL00A 2025-03-05T15:07:36.206Z 2025-03-06T14:51:58.890Z
6236591 6236591 20250226040615_RdGEv USL00A 2025-03-05T15:05:33.342Z 2025-03-06T14:51:32.195Z
6233422 6233422 20250303094226_grHgY USL00A 2025-03-05T14:13:30.073Z 2025-03-11T13:34:49.646Z
6233415 6233415 20250303094131_viIGn USL00A 2025-03-05T14:13:29.150Z 2025-03-11T13:34:49.539Z
6233398 6233398 20250303093744_7z4Jl USL00A 2025-03-05T14:13:26.317Z 2025-03-11T13:34:48.951Z
6233362 6233362 20250303093016_h1pot USL00A 2025-03-05T14:13:15.146Z 2025-03-11T13:34:46.166Z
6233320 6233320 20250303091946_9sndx USL00A 2025-03-05T14:13:10.316Z 2025-03-11T13:34:45.147Z
6233194 6233194 20250303085050_s7TlB USL00A 2025-03-05T14:12:42.098Z 2025-03-11T13:34:42.083Z
6233171 6233171 20250303084252_7cakH USL00A 2025-03-05T14:12:38.037Z 2025-03-11T13:34:41.428Z
6233112 6233112 20250303083026_cGoiC USL00A 2025-03-05T14:12:31.782Z 2025-03-11T13:34:40.471Z
6233106 6233106 20250303082855_TTo6C USL00A 2025-03-05T14:12:30.699Z 2025-03-11T13:34:40.236Z
6232994 6232994 20250303074025_SHTap USL00A 2025-03-05T14:12:03.488Z 2025-03-11T13:34:36.910Z
6232983 6232983 20250303071436_2LzLT USL00A 2025-03-05T14:11:59.994Z 2025-03-11T13:34:30.009Z
6232907 6232907 20250303060400_HGzaR USL00A 2025-03-05T14:11:47.718Z 2025-03-11T13:34:26.563Z
6232816 6232816 20250303045556_eesvH USL00A 2025-03-05T14:11:18.357Z 2025-03-11T13:33:54.875Z
6232767 6232767 20250303043409_GHqO3 USL00A 2025-03-05T14:10:59.086Z 2025-03-11T13:33:48.771Z
6232706 6232706 20250303034222_c4orp USL00A 2025-03-05T14:10:18.950Z 2025-03-11T13:33:05.262Z
6232701 6232701 20250303033826_zilz0 USL00A 2025-03-05T14:10:17.393Z 2025-03-11T13:33:04.516Z
6232683 6232683 20250303031847_OVZUm USL00A 2025-03-05T14:09:55.782Z 2025-03-11T13:32:57.156Z
6230172 6230172 20250302125220_SM2XX USL00A 2025-03-04T14:34:16.372Z 2025-03-10T13:52:31.650Z
6229724 6229724 20250302114524_Fq3iq USL00A 2025-03-04T14:32:53.586Z 2025-03-10T13:51:49.436Z
6229301 6229301 20250302095917_DOOfd USL00A 2025-03-04T14:31:20.681Z 2025-03-10T13:50:03.078Z
6219628 6219628 20250301125923_517r8 USL00A 2025-03-03T14:36:37.151Z 2025-03-09T13:33:20.714Z
6219408 6219408 20250301120855_kWHJU USL00A 2025-03-03T14:35:39.674Z 2025-03-09T13:32:53.739Z
6219265 6219265 20250301105115_v5eyP USL00A 2025-03-03T14:34:37.444Z 2025-03-09T13:32:32.185Z
6219214 6219214 20250301095923_xkr1g USL00A 2025-03-03T14:34:03.419Z 2025-03-09T13:32:18.440Z
6219153 6219153 20250301054613_45cAO USL00A 2025-03-03T14:32:20.522Z 2025-03-09T13:31:32.334Z
6218357 6218357 20250302125220_J87SS USL00A 2025-03-03T14:22:40.170Z 2025-03-03T14:24:37.219Z
6218270 6218270 20250302123131_vFGZI USL00A 2025-03-03T14:22:30.208Z 2025-03-10T13:52:17.804Z
6218264 6218264 20250302123048_Oqrk3 USL00A 2025-03-03T14:22:29.512Z 2025-03-10T13:52:17.472Z
6218210 6218210 20250302122022_v2RtB USL00A 2025-03-03T14:22:23.483Z 2025-03-10T13:52:11.092Z
6218127 6218127 20250302120545_Tdj2F USL00A 2025-03-03T14:22:03.384Z 2025-03-10T13:52:01.380Z
6218046 6218046 20250302114524_pwBjA USL00A 2025-03-03T14:21:51.989Z 2025-03-03T14:24:37.117Z
6217968 6217968 20250302112942_3bsk9 USL00A 2025-03-03T14:21:43.120Z 2025-03-10T13:51:38.489Z
6217958 6217958 20250302112924_euleM USL00A 2025-03-03T14:21:41.405Z 2025-03-10T13:51:35.430Z
6217889 6217889 20250302111642_nVnAs USL00A 2025-03-03T14:21:25.377Z 2025-03-06T14:21:15.738Z
6217806 6217806 20250302105932_yUrRj USL00A 2025-03-03T14:21:14.164Z 2025-03-10T13:51:15.218Z
6217748 6217748 20250302105136_ng2M2 USL00A 2025-03-03T14:20:57.205Z 2025-03-10T13:51:05.273Z

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