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 = "US000J" 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
8691467 8691467 20251205054805_hxFFr US000J 2025-12-06T14:17:51.185Z 2025-12-06T14:18:01.122Z
8691463 8691463 20251205054656_gprrJ US000J 2025-12-06T14:17:50.344Z 2025-12-06T14:18:01.121Z
8691431 8691431 20251205053238_eSuC4 US000J 2025-12-06T14:17:45.837Z 2025-12-06T14:18:01.112Z
8691384 8691384 20251205051253_04mS7 US000J 2025-12-06T14:17:33.382Z 2025-12-06T14:18:01.101Z
8690956 8690956 20251205023308_QTail US000J 2025-12-06T14:15:59.914Z 2025-12-06T14:18:00.999Z
8690858 8690858 20251205020612_nkMX9 US000J 2025-12-06T14:15:42.531Z 2025-12-06T14:18:00.974Z
8690849 8690849 20251205020507_Ws6Fp US000J 2025-12-06T14:15:41.129Z 2025-12-06T14:18:00.972Z
8690836 8690836 20251205020252_ZuJRn US000J 2025-12-06T14:15:38.700Z 2025-12-06T14:18:00.969Z
8690706 8690706 20251205012459_B3gvF US000J 2025-12-06T14:15:13.524Z 2025-12-06T14:18:00.941Z
8690607 8690607 20251205005520_5vhn5 US000J 2025-12-06T14:14:53.107Z 2025-12-06T14:18:00.919Z
8688842 8688842 20251205125954_sZnF9 US000J 2025-12-06T14:05:59.490Z 2025-12-06T14:05:59.490Z
8688735 8688735 20251205123040_fuTgW US000J 2025-12-06T14:05:36.763Z 2025-12-06T14:05:36.763Z
8688730 8688730 20251205123021_i020B US000J 2025-12-06T14:05:35.716Z 2025-12-06T14:05:35.716Z
8688704 8688704 20251205122752_J3159 US000J 2025-12-06T14:05:28.022Z 2025-12-06T14:05:28.022Z
8688639 8688639 20251205121643_IZzMh US000J 2025-12-06T14:05:15.234Z 2025-12-06T14:05:15.234Z
8688608 8688608 20251205120825_7dRJ3 US000J 2025-12-06T14:05:08.205Z 2025-12-06T14:05:08.205Z
8688590 8688590 20251205120650_5KVH4 US000J 2025-12-06T14:05:05.968Z 2025-12-06T14:05:05.968Z
8688585 8688585 20251205120634_nmfdq US000J 2025-12-06T14:05:04.971Z 2025-12-06T14:05:04.971Z
8688571 8688571 20251205120416_qI7ix US000J 2025-12-06T14:05:03.739Z 2025-12-06T14:05:03.739Z
8688546 8688546 20251205115746_74T1S US000J 2025-12-06T14:04:53.617Z 2025-12-06T14:04:53.617Z
8688509 8688509 20251205114717_dA7e1 US000J 2025-12-06T14:04:45.459Z 2025-12-06T14:04:45.459Z
8688478 8688478 20251205114058_QIWjY US000J 2025-12-06T14:04:42.465Z 2025-12-06T14:04:42.465Z
8688451 8688451 20251205113236_GBAGn US000J 2025-12-06T14:04:37.839Z 2025-12-06T14:04:37.839Z
8688271 8688271 20251205105657_2AnEM US000J 2025-12-06T14:03:56.142Z 2025-12-06T14:03:56.142Z
8688206 8688206 20251205104447_ETmLu US000J 2025-12-06T14:03:38.391Z 2025-12-06T14:03:38.391Z
8688169 8688169 20251205103922_CA827 US000J 2025-12-06T14:03:31.260Z 2025-12-06T14:03:31.260Z
8688125 8688125 20251205102757_GWC2d US000J 2025-12-06T14:03:14.833Z 2025-12-06T14:03:14.833Z
8688092 8688092 20251205101705_uVqdI US000J 2025-12-06T14:03:07.349Z 2025-12-06T14:03:07.349Z
8688020 8688020 20251205100014_P7kbu US000J 2025-12-06T14:02:49.213Z 2025-12-06T14:02:49.213Z
8687982 8687982 20251205095334_BDJ8H US000J 2025-12-06T14:02:35.188Z 2025-12-06T14:02:35.188Z
8687977 8687977 20251205095252_hrPCQ US000J 2025-12-06T14:02:33.848Z 2025-12-06T14:02:33.848Z
8687923 8687923 20251205094624_2qkdb US000J 2025-12-06T14:02:25.282Z 2025-12-06T14:02:25.282Z
8687916 8687916 20251205094557_zsknb US000J 2025-12-06T14:02:23.193Z 2025-12-06T14:02:23.193Z
8687885 8687885 20251205092748_L3jhs US000J 2025-12-06T14:02:11.229Z 2025-12-06T14:02:11.229Z
8687882 8687882 20251205092748_pS7Rs US000J 2025-12-06T14:02:10.886Z 2025-12-06T14:02:10.886Z
8687823 8687823 20251205091313_j2Yvd US000J 2025-12-06T14:01:56.223Z 2025-12-06T14:01:56.223Z
8687802 8687802 20251205090824_srwQK US000J 2025-12-06T14:01:51.594Z 2025-12-06T14:01:51.594Z
8687765 8687765 20251205085558_vE20H US000J 2025-12-06T14:01:41.338Z 2025-12-06T14:01:41.338Z
8687760 8687760 20251205085511_fOzfm US000J 2025-12-06T14:01:40.213Z 2025-12-06T14:01:40.213Z
8687754 8687754 20251205085310_PV1yH US000J 2025-12-06T14:01:37.547Z 2025-12-06T14:01:37.547Z
8687748 8687748 20251205085159_jLq7w US000J 2025-12-06T14:01:36.199Z 2025-12-06T14:01:36.199Z
8687710 8687710 20251205083620_9snaY US000J 2025-12-06T14:01:27.790Z 2025-12-06T14:01:27.790Z
8687680 8687680 20251205082559_Zq6C7 US000J 2025-12-06T14:01:21.461Z 2025-12-06T14:01:21.461Z
8687656 8687656 20251205081736_lJDJH US000J 2025-12-06T14:01:11.987Z 2025-12-06T14:01:11.987Z
8687648 8687648 20251205081512_D6GlU US000J 2025-12-06T14:01:09.478Z 2025-12-06T14:01:09.478Z
8687637 8687637 20251205080856_xFHrN US000J 2025-12-06T14:01:06.599Z 2025-12-06T14:01:06.599Z
8687603 8687603 20251205075725_iYqY1 US000J 2025-12-06T14:00:57.703Z 2025-12-06T14:00:57.703Z
8687584 8687584 20251205074850_0CifW US000J 2025-12-06T14:00:52.301Z 2025-12-06T14:00:52.301Z
8687581 8687581 20251205074756_s52kD US000J 2025-12-06T14:00:50.701Z 2025-12-06T14:00:50.701Z
8687576 8687576 20251205073835_gOsgK US000J 2025-12-06T14:00:49.529Z 2025-12-06T14:00:49.529Z
8687561 8687561 20251205073316_XzXGA US000J 2025-12-06T14:00:46.208Z 2025-12-06T14:00:46.208Z
8687553 8687553 20251205072606_gTD0o US000J 2025-12-06T14:00:44.458Z 2025-12-06T14:00:44.458Z
8687526 8687526 20251205070058_5FahD US000J 2025-12-06T14:00:34.946Z 2025-12-06T14:00:34.946Z
8687501 8687501 20251205065725_SIQ3O US000J 2025-12-06T14:00:31.220Z 2025-12-06T14:00:31.220Z
8687489 8687489 20251205064553_z9USY US000J 2025-12-06T14:00:27.883Z 2025-12-06T14:00:27.883Z
8687481 8687481 20251205063610_xwDel US000J 2025-12-06T14:00:26.301Z 2025-12-06T14:00:26.301Z
8687265 8687265 20251204063353_77JUO US000J 2025-12-05T14:14:33.183Z 2025-12-06T14:22:44.074Z
8687162 8687162 20251204052911_wjMhz US000J 2025-12-05T14:14:06.021Z 2025-12-06T14:22:34.641Z
8684518 8684518 20251204130059_89au0 US000J 2025-12-05T14:03:35.874Z 2025-12-06T14:18:00.532Z
8684389 8684389 20251204122534_AeqNX US000J 2025-12-05T14:02:54.054Z 2025-12-06T14:18:00.496Z
8684317 8684317 20251204120349_6yDyA US000J 2025-12-05T14:02:41.848Z 2025-12-06T14:18:00.475Z
8684295 8684295 20251204115810_AYr6T US000J 2025-12-05T14:02:38.286Z 2025-12-06T14:18:00.469Z
8684259 8684259 20251204114906_XCjKR US000J 2025-12-05T14:02:23.809Z 2025-12-06T14:18:00.457Z
8684249 8684249 20251204114526_32A6f US000J 2025-12-05T14:02:21.772Z 2025-12-06T14:18:00.453Z
8684166 8684166 20251204110431_Nl21x US000J 2025-12-05T14:02:04.738Z 2025-12-06T14:18:00.432Z
8684116 8684116 20251204104910_DOrhz US000J 2025-12-05T14:01:58.715Z 2025-12-06T14:18:00.421Z
8683686 8683686 20251204064816_gqlYX US000J 2025-12-05T14:00:11.095Z 2025-12-06T14:18:00.301Z
8683280 8683280 20251203064959_H3m2q US000J 2025-12-04T14:19:03.783Z 2025-12-06T14:29:49.121Z
8683154 8683154 20251203063340_hAg8H US000J 2025-12-04T14:18:39.476Z 2025-12-06T14:29:43.169Z
8683057 8683057 20251203062320_gJA20 US000J 2025-12-04T14:18:30.894Z 2025-12-06T14:29:40.470Z
8682975 8682975 20251203061754_bIW1Q US000J 2025-12-04T14:18:25.060Z 2025-12-06T14:29:34.478Z
8682524 8682524 20251203054344_ukT0X US000J 2025-12-04T14:17:24.384Z 2025-12-06T14:29:13.595Z
8682477 8682477 20251203053858_eXL3z US000J 2025-12-04T14:17:17.291Z 2025-12-06T14:29:04.555Z
8682474 8682474 20251203053834_6ONDR US000J 2025-12-04T14:17:16.813Z 2025-12-06T14:29:04.460Z
8682464 8682464 20251203053759_BFfzn US000J 2025-12-04T14:17:15.266Z 2025-12-06T14:29:03.987Z
8682443 8682443 20251203053427_DfFnr US000J 2025-12-04T14:17:12.431Z 2025-12-06T14:29:03.116Z
8682374 8682374 20251203052230_QMEzm US000J 2025-12-04T14:17:02.748Z 2025-12-06T14:28:57.350Z
8682335 8682335 20251203051705_DLSM2 US000J 2025-12-04T14:16:49.422Z 2025-12-06T14:28:54.838Z
8681936 8681936 20251203043012_DnUe7 US000J 2025-12-04T14:16:02.365Z 2025-12-06T14:28:40.766Z
8681752 8681752 20251203035536_shT6R US000J 2025-12-04T14:15:30.279Z 2025-12-06T14:28:28.077Z
8681535 8681535 20251203032242_IcEgD US000J 2025-12-04T14:15:00.285Z 2025-12-06T14:28:17.199Z
8681164 8681164 20251203023128_Pm9aO US000J 2025-12-04T14:13:58.883Z 2025-12-06T14:27:51.821Z
8681112 8681112 20251203022502_LcX7i US000J 2025-12-04T14:13:52.478Z 2025-12-06T14:27:49.946Z
8681054 8681054 20251203021707_U1JMD US000J 2025-12-04T14:13:39.356Z 2025-12-06T14:27:47.633Z
8681034 8681034 20251203021516_6ksiH US000J 2025-12-04T14:13:37.098Z 2025-12-06T14:27:47.021Z
8680749 8680749 20251203011216_6gLq2 US000J 2025-12-04T14:12:51.377Z 2025-12-06T14:27:24.794Z
8680601 8680601 20251203004648_81jDr US000J 2025-12-04T14:12:27.146Z 2025-12-06T14:27:19.355Z
8677811 8677811 20251203123753_64XAE US000J 2025-12-04T14:02:42.371Z 2025-12-06T14:20:06.920Z
8677788 8677788 20251203123304_2Onuu US000J 2025-12-04T14:02:38.832Z 2025-12-06T14:20:05.637Z
8677783 8677783 20251203123041_TgP7h US000J 2025-12-04T14:02:36.186Z 2025-12-06T14:20:05.397Z
8677771 8677771 20251203122745_usVtp US000J 2025-12-04T14:02:30.781Z 2025-12-06T14:20:04.082Z
8677736 8677736 20251203120457_0JT6d US000J 2025-12-04T14:02:25.121Z 2025-12-06T14:20:00.195Z
8677687 8677687 20251203114845_Ntz6g US000J 2025-12-04T14:02:18.052Z 2025-12-06T14:19:57.679Z
8677675 8677675 20251203114244_ypihi US000J 2025-12-04T14:02:16.891Z 2025-12-06T14:19:56.694Z
8677669 8677669 20251203114036_Xt6tI US000J 2025-12-04T14:02:15.963Z 2025-12-06T14:19:56.216Z
8677654 8677654 20251203113122_rp7ph US000J 2025-12-04T14:02:12.935Z 2025-12-06T14:19:54.451Z
8677564 8677564 20251203104649_6ADp0 US000J 2025-12-04T14:01:46.025Z 2025-12-06T14:19:38.480Z
8677479 8677479 20251203101710_jTQm5 US000J 2025-12-04T14:01:21.998Z 2025-12-06T14:19:31.514Z
8677156 8677156 20251202071037_kQ6zQ US000J 2025-12-03T14:26:22.201Z 2025-12-06T14:35:36.911Z
8677017 8677017 20251202064026_ybPme US000J 2025-12-03T14:26:12.082Z 2025-12-06T14:35:33.023Z

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