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 = "US000D" 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
8691466 8691466 20251205054805_hxFFr US000D 2025-12-06T14:17:51.185Z 2025-12-06T14:18:01.122Z
8691462 8691462 20251205054656_gprrJ US000D 2025-12-06T14:17:50.344Z 2025-12-06T14:18:01.121Z
8690709 8690709 20251205012459_GcdGv US000D 2025-12-06T14:15:13.894Z 2025-12-06T14:18:00.942Z
8687507 8687507 20251205065725_y9bON US000D 2025-12-06T14:00:32.194Z 2025-12-06T14:00:32.194Z
8687491 8687491 20251205064553_LV0Ul US000D 2025-12-06T14:00:28.243Z 2025-12-06T14:00:28.243Z
8684517 8684517 20251204130059_89au0 US000D 2025-12-05T14:03:35.841Z 2025-12-06T14:18:00.532Z
8681892 8681892 20251203042343_xcM3s US000D 2025-12-04T14:15:57.014Z 2025-12-06T14:28:38.986Z
8681110 8681110 20251203022502_LcX7i US000D 2025-12-04T14:13:52.448Z 2025-12-06T14:27:49.946Z
8676557 8676557 20251202060207_XW98R US000D 2025-12-03T14:25:18.645Z 2025-12-06T14:35:23.566Z
8675788 8675788 20251202051423_yQmR3 US000D 2025-12-03T14:24:15.208Z 2025-12-06T14:35:00.203Z
8675376 8675376 20251202043336_b7tHY US000D 2025-12-03T14:23:39.063Z 2025-12-06T14:34:50.835Z
8675098 8675098 20251202040026_7rgCR US000D 2025-12-03T14:23:02.063Z 2025-12-06T14:34:29.043Z
8674930 8674930 20251202034104_RCBDo US000D 2025-12-03T14:22:44.263Z 2025-12-06T14:34:23.618Z
8674859 8674859 20251202033426_2WCNB US000D 2025-12-03T14:22:30.133Z 2025-12-06T14:34:21.270Z
8674268 8674268 20251202015617_pss65 US000D 2025-12-03T14:21:20.347Z 2025-12-06T14:34:02.876Z
8670047 8670047 20251202125520_0Xgra US000D 2025-12-03T14:06:37.418Z 2025-12-06T14:24:32.447Z
8670039 8670039 20251202125505_lyss2 US000D 2025-12-03T14:06:35.535Z 2025-12-06T14:24:32.182Z
8669996 8669996 20251202124244_G5f88 US000D 2025-12-03T14:06:27.362Z 2025-12-06T14:24:30.100Z
8669840 8669840 20251202121639_oTxJY US000D 2025-12-03T14:05:48.906Z 2025-12-06T14:24:22.872Z
8669748 8669748 20251202120753_U1hF8 US000D 2025-12-03T14:05:21.415Z 2025-12-06T14:24:18.580Z
8669739 8669739 20251202120643_937f7 US000D 2025-12-03T14:05:19.892Z 2025-12-06T14:24:18.028Z
8669667 8669667 20251202115542_2aYMu US000D 2025-12-03T14:04:54.681Z 2025-12-06T14:24:14.000Z
8669651 8669651 20251202115230_2DKoi US000D 2025-12-03T14:04:52.265Z 2025-12-06T14:24:13.092Z
8669634 8669634 20251202114815_7kBJo US000D 2025-12-03T14:04:46.447Z 2025-12-06T14:24:12.315Z
8669553 8669553 20251202113058_mCpFq US000D 2025-12-03T14:04:31.191Z 2025-12-06T14:24:01.790Z
8669464 8669464 20251202111605_yG5j2 US000D 2025-12-03T14:04:02.343Z 2025-12-06T14:23:56.461Z
8669379 8669379 20251202110254_8Fzsn US000D 2025-12-03T14:03:30.905Z 2025-12-06T14:23:51.205Z
8669343 8669343 20251202105620_aUMu1 US000D 2025-12-03T14:03:25.420Z 2025-12-06T14:23:49.959Z
8669268 8669268 20251202104255_TGH7e US000D 2025-12-03T14:03:06.069Z 2025-12-06T14:23:46.835Z
8669213 8669213 20251202103258_91rWs US000D 2025-12-03T14:02:52.687Z 2025-12-06T14:23:40.442Z
8669065 8669065 20251202100759_YNibN US000D 2025-12-03T14:02:13.110Z 2025-12-06T14:23:30.239Z
8669051 8669051 20251202100301_wfonP US000D 2025-12-03T14:02:09.261Z 2025-12-06T14:23:29.196Z
8669010 8669010 20251202095219_JfLpm US000D 2025-12-03T14:02:00.787Z 2025-12-06T14:23:25.834Z
8668989 8668989 20251202095012_yUZkT US000D 2025-12-03T14:01:57.914Z 2025-12-06T14:23:24.813Z
8668935 8668935 20251202093210_XxUdK US000D 2025-12-03T14:01:37.919Z 2025-12-06T14:23:22.184Z
8668922 8668922 20251202092723_QtHln US000D 2025-12-03T14:01:36.150Z 2025-12-06T14:23:21.597Z
8668881 8668881 20251202091722_2vcNx US000D 2025-12-03T14:01:31.510Z 2025-12-06T14:23:16.137Z
8668848 8668848 20251202091140_kANJb US000D 2025-12-03T14:01:26.846Z 2025-12-06T14:23:14.123Z
8668839 8668839 20251202090942_SEcey US000D 2025-12-03T14:01:25.876Z 2025-12-06T14:23:13.819Z
8668832 8668832 20251202090924_Ab0Jq US000D 2025-12-03T14:01:25.329Z 2025-12-06T14:23:13.691Z
8668809 8668809 20251202090334_45Go3 US000D 2025-12-03T14:01:21.995Z 2025-12-06T14:23:12.562Z
8668623 8668623 20251202080225_SUWVV US000D 2025-12-03T14:00:36.438Z 2025-12-06T14:22:58.001Z
8668531 8668531 20251202072712_K3iae US000D 2025-12-03T14:00:15.700Z 2025-12-06T14:22:47.051Z
8668464 8668464 20251129055557_DSi23 US000D 2025-12-02T14:48:41.247Z 2025-12-06T14:56:54.853Z
8668263 8668263 20251130070052_9oWgU US000D 2025-12-02T14:42:15.251Z 2025-12-06T14:50:28.926Z
8668255 8668255 20251130070026_ArRyD US000D 2025-12-02T14:42:14.986Z 2025-12-06T14:50:28.813Z
8668235 8668235 20251130065321_hf5wA US000D 2025-12-02T14:42:13.709Z 2025-12-06T14:50:28.093Z
8668180 8668180 20251130063149_fmYle US000D 2025-12-02T14:42:08.983Z 2025-12-06T14:50:25.772Z
8668105 8668105 20251130060156_rw6jM US000D 2025-12-02T14:42:01.071Z 2025-12-06T14:50:21.913Z
8668081 8668081 20251130055701_7XoaP US000D 2025-12-02T14:41:59.318Z 2025-12-06T14:50:18.648Z
8668069 8668069 20251130055210_txBb3 US000D 2025-12-02T14:41:52.986Z 2025-12-06T14:50:09.427Z
8668033 8668033 20251130054103_BvYtx US000D 2025-12-02T14:41:30.799Z 2025-12-06T14:49:55.473Z
8668024 8668024 20251130054102_wDPHd US000D 2025-12-02T14:41:30.723Z 2025-12-06T14:49:55.442Z
8667911 8667911 20251130050836_aKA8P US000D 2025-12-02T14:41:17.506Z 2025-12-06T14:49:39.848Z
8667852 8667852 20251130043754_nqVLt US000D 2025-12-02T14:40:38.474Z 2025-12-06T14:49:30.990Z
8667716 8667716 20251130033006_mEiLK US000D 2025-12-02T14:39:54.302Z 2025-12-06T14:48:47.567Z
8667497 8667497 20251130015546_j3wWx US000D 2025-12-02T14:38:42.596Z 2025-12-06T14:47:49.847Z
8667473 8667473 20251130014516_eTsR8 US000D 2025-12-02T14:38:26.279Z 2025-12-06T14:47:45.836Z
8660569 8660569 20251130130702_HeceM US000D 2025-12-02T14:08:18.106Z 2025-12-06T14:37:19.270Z
8660547 8660547 20251130130248_P57MK US000D 2025-12-02T14:08:15.292Z 2025-12-06T14:37:18.714Z
8660449 8660449 20251130125216_3yfRT US000D 2025-12-02T14:07:51.882Z 2025-12-06T14:37:16.070Z
8660440 8660440 20251130125216_8Rqxp US000D 2025-12-02T14:07:51.278Z 2025-12-06T14:37:16.007Z
8660416 8660416 20251130125103_vUZvR US000D 2025-12-02T14:07:48.458Z 2025-12-06T14:37:15.652Z
8660331 8660331 20251130123012_3NOa8 US000D 2025-12-02T14:07:24.964Z 2025-12-06T14:37:00.492Z
8660227 8660227 20251130120915_bAk72 US000D 2025-12-02T14:06:59.329Z 2025-12-06T14:36:57.505Z
8660190 8660190 20251130120357_iRaqx US000D 2025-12-02T14:06:51.936Z 2025-12-06T14:36:54.990Z
8660074 8660074 20251130115243_o6C6x US000D 2025-12-02T14:06:26.619Z 2025-12-06T14:36:52.101Z
8659712 8659712 20251130110736_M8eJX US000D 2025-12-02T14:05:06.942Z 2025-12-06T14:36:40.344Z
8659666 8659666 20251130110311_zJGcJ US000D 2025-12-02T14:04:48.538Z 2025-12-06T14:36:32.017Z
8659605 8659605 20251130105433_WOMEV US000D 2025-12-02T14:04:37.940Z 2025-12-06T14:36:25.003Z
8659598 8659598 20251130105356_IWHEK US000D 2025-12-02T14:04:36.804Z 2025-12-06T14:36:24.720Z
8659545 8659545 20251130104627_QlWau US000D 2025-12-02T14:04:22.662Z 2025-12-06T14:36:23.151Z
8659520 8659520 20251130104005_0ZIP3 US000D 2025-12-02T14:04:18.752Z 2025-12-06T14:36:22.577Z
8659454 8659454 20251130102933_h3EdT US000D 2025-12-02T14:03:57.378Z 2025-12-06T14:36:19.206Z
8659327 8659327 20251130101055_lXKM2 US000D 2025-12-02T14:03:30.802Z 2025-12-06T14:36:14.568Z
8659277 8659277 20251130100311_YWghn US000D 2025-12-02T14:03:22.260Z 2025-12-06T14:36:13.050Z
8659179 8659179 20251130094211_HVCjG US000D 2025-12-02T14:02:50.483Z 2025-12-06T14:36:09.616Z
8659159 8659159 20251130094116_NCn7T US000D 2025-12-02T14:02:47.087Z 2025-12-06T14:36:09.190Z
8659071 8659071 20251130092917_zgSWG US000D 2025-12-02T14:02:27.204Z 2025-12-06T14:36:05.316Z
8659059 8659059 20251130092622_9gkFw US000D 2025-12-02T14:02:24.409Z 2025-12-06T14:36:04.646Z
8658625 8658625 20251126075257_nRrdw US000D 2025-12-01T15:06:09.494Z 2025-12-04T15:11:53.624Z
8658286 8658286 20251129074804_Kc2wC US000D 2025-12-01T14:46:36.646Z 2025-12-06T14:57:39.652Z
8648740 8648740 20251129110755_H6I3Q US000D 2025-12-01T14:04:15.533Z 2025-12-06T14:43:42.048Z
8648311 8648311 20251129072626_FLXTJ US000D 2025-11-30T14:30:03.093Z 2025-12-06T14:57:31.850Z
8648293 8648293 20251129072108_W9jwE US000D 2025-11-30T14:30:02.141Z 2025-12-06T14:57:31.114Z
8648267 8648267 20251129071740_21Uwl US000D 2025-11-30T14:30:00.341Z 2025-12-06T14:57:28.492Z
8648179 8648179 20251129065151_WK03Z US000D 2025-11-30T14:29:45.157Z 2025-12-06T14:57:17.666Z
8648148 8648148 20251129064750_2k8jB US000D 2025-11-30T14:29:40.714Z 2025-12-06T14:57:16.332Z
8648111 8648111 20251129063934_XD68I US000D 2025-11-30T14:29:38.092Z 2025-12-06T14:57:13.612Z
8648059 8648059 20251129063257_CmB5a US000D 2025-11-30T14:29:32.122Z 2025-12-06T14:57:10.974Z
8647959 8647959 20251129061128_Lli7e US000D 2025-11-30T14:29:25.793Z 2025-12-06T14:57:01.511Z
8647683 8647683 20251129050751_7zj4Q US000D 2025-11-30T14:28:44.941Z 2025-12-06T14:56:44.067Z
8647257 8647257 20251129041321_kJmw9 US000D 2025-11-30T14:27:53.970Z 2025-12-06T14:56:35.004Z
8646899 8646899 20251129030900_P0ATU US000D 2025-11-30T14:27:05.925Z 2025-12-06T14:56:27.479Z
8646682 8646682 20251129023820_iTVmZ US000D 2025-11-30T14:26:39.644Z 2025-12-06T14:56:23.318Z
8646426 8646426 20251129020453_m8DBv US000D 2025-11-30T14:25:58.541Z 2025-12-06T14:56:06.120Z
8640145 8640145 20251129125823_Kjb1o US000D 2025-11-30T14:07:23.090Z 2025-12-06T14:43:59.915Z
8640069 8640069 20251129124458_YGKXq US000D 2025-11-30T14:07:01.674Z 2025-12-06T14:43:58.463Z
8640053 8640053 20251129124314_fuKD4 US000D 2025-11-30T14:06:58.892Z 2025-12-06T14:43:58.165Z
8640042 8640042 20251129124220_YcE8b US000D 2025-11-30T14:06:57.517Z 2025-12-06T14:43:57.980Z

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