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

1,611 rows where station_code = "US003Y" 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
8687242 8687242 20251204060617_hA6OS US003Y 2025-12-05T14:14:29.140Z 2025-12-06T14:22:41.233Z
8687090 8687090 20251204033058_eSPK6 US003Y 2025-12-05T14:13:51.705Z 2025-12-06T14:22:30.159Z
8683776 8683776 20251204080322_0bf02 US003Y 2025-12-05T14:00:32.723Z 2025-12-06T14:18:00.326Z
8683729 8683729 20251204072521_9CyyR US003Y 2025-12-05T14:00:22.758Z 2025-12-06T14:18:00.314Z
8683724 8683724 20251204072421_Sltvs US003Y 2025-12-05T14:00:21.770Z 2025-12-06T14:18:00.312Z
8683717 8683717 20251204071107_ajdyR US003Y 2025-12-05T14:00:20.344Z 2025-12-06T14:18:00.310Z
8683706 8683706 20251204070228_Wfqcw US003Y 2025-12-05T14:00:16.341Z 2025-12-06T14:18:00.307Z
8683689 8683689 20251204065040_HMwP6 US003Y 2025-12-05T14:00:11.755Z 2025-12-06T14:18:00.302Z
8677599 8677599 20251203105859_PohwV US003Y 2025-12-04T14:01:55.079Z 2025-12-06T14:19:43.138Z
8677533 8677533 20251203103701_TeTwq US003Y 2025-12-04T14:01:36.529Z 2025-12-06T14:19:36.561Z
8677529 8677529 20251203103510_DfSWS US003Y 2025-12-04T14:01:36.021Z 2025-12-06T14:19:36.430Z
8677496 8677496 20251203102623_403AJ US003Y 2025-12-04T14:01:26.437Z 2025-12-06T14:19:32.885Z
8677488 8677488 20251203102118_2XYiI US003Y 2025-12-04T14:01:24.703Z 2025-12-06T14:19:32.359Z
8677461 8677461 20251203101017_kkJeS US003Y 2025-12-04T14:01:19.144Z 2025-12-06T14:19:30.355Z
8677389 8677389 20251203093312_ByARn US003Y 2025-12-04T14:01:00.829Z 2025-12-06T14:19:22.071Z
8677388 8677388 20251203093026_Syhmb US003Y 2025-12-04T14:01:00.315Z 2025-12-06T14:19:21.742Z
8677316 8677316 20251203084002_54rGe US003Y 2025-12-04T14:00:45.332Z 2025-12-06T14:19:09.088Z
8677312 8677312 20251203083510_uZQDK US003Y 2025-12-04T14:00:44.364Z 2025-12-06T14:19:07.293Z
8677262 8677262 20251203080356_8P6yr US003Y 2025-12-04T14:00:31.568Z 2025-12-06T14:18:41.774Z
8670851 8670851 20251201103238_0IAID US003Y 2025-12-03T14:10:32.807Z 2025-12-06T14:30:27.509Z
8670489 8670489 20251201090809_CHyBS US003Y 2025-12-03T14:09:00.223Z 2025-12-06T14:30:00.190Z
8670411 8670411 20251201084440_Cm0xO US003Y 2025-12-03T14:08:38.700Z 2025-12-06T14:29:57.189Z
8670395 8670395 20251201083353_huZxJ US003Y 2025-12-03T14:08:31.644Z 2025-12-06T14:29:56.234Z
8670391 8670391 20251201082906_k25De US003Y 2025-12-03T14:08:29.625Z 2025-12-06T14:29:54.192Z
8670387 8670387 20251201082622_9U9rR US003Y 2025-12-03T14:08:28.848Z 2025-12-06T14:29:54.016Z
8670372 8670372 20251201074544_FD1AD US003Y 2025-12-03T14:08:22.737Z 2025-12-06T14:29:52.448Z
8666889 8666889 20251201065237_Z0cx3 US003Y 2025-12-02T14:30:40.100Z 2025-12-06T14:42:42.442Z
8666863 8666863 20251201053626_DlZBn US003Y 2025-12-02T14:30:25.609Z 2025-12-06T14:42:21.463Z
8648451 8648451 20251129075823_NptsX US003Y 2025-11-30T14:30:11.010Z 2025-12-06T14:57:44.199Z
8648431 8648431 20251129074951_oA2OX US003Y 2025-11-30T14:30:09.881Z 2025-12-06T14:57:40.994Z
8648274 8648274 20251129071816_09Oam US003Y 2025-11-30T14:30:00.699Z 2025-12-06T14:57:29.178Z
8648256 8648256 20251129071544_6UOEB US003Y 2025-11-30T14:29:59.984Z 2025-12-06T14:57:28.366Z
8648155 8648155 20251129064856_dzgZY US003Y 2025-11-30T14:29:41.363Z 2025-12-06T14:57:16.826Z
8648065 8648065 20251129063404_M6XLw US003Y 2025-11-30T14:29:32.420Z 2025-12-06T14:57:11.465Z
8647956 8647956 20251129061053_LG3Bc US003Y 2025-11-30T14:29:25.548Z 2025-12-06T14:56:59.964Z
8647887 8647887 20251129055521_nd9UM US003Y 2025-11-30T14:29:21.028Z 2025-12-06T14:56:51.529Z
8647642 8647642 20251129050014_9y1Zd US003Y 2025-11-30T14:28:40.868Z 2025-12-06T14:56:42.421Z
8647609 8647609 20251129045741_3p6jf US003Y 2025-11-30T14:28:39.028Z 2025-12-06T14:56:42.091Z
8647526 8647526 20251129044733_QNiPv US003Y 2025-11-30T14:28:32.830Z 2025-12-06T14:56:40.555Z
8647354 8647354 20251129042621_E94pn US003Y 2025-11-30T14:28:02.841Z 2025-12-06T14:56:37.332Z
8647342 8647342 20251129042424_X68Ut US003Y 2025-11-30T14:28:00.956Z 2025-12-06T14:56:37.103Z
8647338 8647338 20251129042400_caTcr US003Y 2025-11-30T14:28:00.609Z 2025-12-06T14:56:37.032Z
8647181 8647181 20251129035755_GYJ19 US003Y 2025-11-30T14:27:48.276Z 2025-12-06T14:56:33.401Z
8647095 8647095 20251129034253_U8ygV US003Y 2025-11-30T14:27:33.512Z 2025-12-06T14:56:31.773Z
8646959 8646959 20251129031957_Y0fh1 US003Y 2025-11-30T14:27:11.228Z 2025-12-06T14:56:28.709Z
8646743 8646743 20251129024658_Ad97H US003Y 2025-11-30T14:26:46.315Z 2025-12-06T14:56:24.369Z
8646714 8646714 20251129024128_I0hAx US003Y 2025-11-30T14:26:41.896Z 2025-12-06T14:56:23.861Z
8646291 8646291 20251129014023_uwvGh US003Y 2025-11-30T14:25:48.015Z 2025-12-06T14:55:55.714Z
8645983 8645983 20251129004119_SG0u3 US003Y 2025-11-30T14:25:01.847Z 2025-12-06T14:55:23.048Z
8645940 8645940 20251129003247_EuJC0 US003Y 2025-11-30T14:24:57.596Z 2025-12-06T14:55:18.645Z
8639192 8639192 20251129103909_hUEkr US003Y 2025-11-30T14:04:06.413Z 2025-12-06T14:43:36.017Z
8639161 8639161 20251129103519_JAlsW US003Y 2025-11-30T14:04:00.013Z 2025-12-06T14:43:35.204Z
8639125 8639125 20251129103041_xQ28Z US003Y 2025-11-30T14:03:48.744Z 2025-12-06T14:43:30.159Z
8638894 8638894 20251129100027_FmtLp US003Y 2025-11-30T14:02:49.350Z 2025-12-06T14:43:05.132Z
8638892 8638892 20251129095948_KQEpP US003Y 2025-11-30T14:02:48.920Z 2025-11-30T14:02:48.920Z
8638659 8638659 20251129092011_FqEvW US003Y 2025-11-30T14:01:50.118Z 2025-12-06T14:42:57.785Z
8638524 8638524 20251129090237_0Z3rj US003Y 2025-11-30T14:01:18.817Z 2025-12-06T14:42:53.631Z
8638475 8638475 20251129085528_SvHU3 US003Y 2025-11-30T14:01:04.212Z 2025-12-06T14:42:52.224Z
8638448 8638448 20251129084851_B9tKq US003Y 2025-11-30T14:00:57.628Z 2025-12-06T14:42:51.392Z
8638326 8638326 20251129082738_ZCsYl US003Y 2025-11-30T14:00:32.103Z 2025-12-06T14:42:47.815Z
8636296 8636296 20251128033317_TgPeo US003Y 2025-11-29T14:25:21.137Z 2025-12-06T15:03:04.289Z
8636130 8636130 20251128032022_FRbZP US003Y 2025-11-29T14:24:56.923Z 2025-12-06T15:02:56.514Z
8627215 8627215 20251128103853_tsVRq US003Y 2025-11-29T14:03:00.939Z 2025-12-06T14:51:14.793Z
8626765 8626765 20251128093311_NZKH3 US003Y 2025-11-29T14:01:27.119Z 2025-12-06T14:50:41.954Z
8626652 8626652 20251128091521_4OBXk US003Y 2025-11-29T14:01:06.653Z 2025-12-06T14:50:39.745Z
8626586 8626586 20251128090726_vFSI6 US003Y 2025-11-29T14:00:57.419Z 2025-12-06T14:50:38.398Z
8626548 8626548 20251128085810_Rc3NB US003Y 2025-11-29T14:00:41.847Z 2025-12-06T14:50:35.900Z
8625000 8625000 20251127073444_esc2K US003Y 2025-11-28T14:26:07.643Z 2025-12-05T15:05:37.639Z
8624330 8624330 20251127041608_3z7B2 US003Y 2025-11-28T14:24:28.672Z 2025-12-05T15:04:59.306Z
8624117 8624117 20251127031212_0Qhxa US003Y 2025-11-28T14:23:49.187Z 2025-12-05T15:04:45.760Z
8604392 8604392 20251123224630_aJyqm US003Y 2025-11-26T14:34:20.477Z 2025-12-02T15:11:20.120Z
8592843 8592843 20251124093426_uCsUB US003Y 2025-11-25T14:28:07.306Z 2025-12-02T15:13:08.041Z
8592824 8592824 20251124093110_dhhbp US003Y 2025-11-25T14:28:04.032Z 2025-12-02T15:13:07.899Z
8592675 8592675 20251124085722_R7YIr US003Y 2025-11-25T14:27:26.823Z 2025-12-02T15:13:06.236Z
8592624 8592624 20251124084625_dsZME US003Y 2025-11-25T14:27:21.584Z 2025-12-02T15:13:05.863Z
8592587 8592587 20251124083800_AuMS2 US003Y 2025-11-25T14:27:17.162Z 2025-12-02T15:13:05.465Z
8592492 8592492 20251124080027_d4BK3 US003Y 2025-11-25T14:26:49.810Z 2025-12-02T15:13:04.588Z
8592344 8592344 20251124065319_6dk6Q US003Y 2025-11-25T14:26:33.529Z 2025-12-02T15:13:03.400Z
8591980 8591980 20251124052802_Doo0Y US003Y 2025-11-25T14:25:28.699Z 2025-12-02T15:13:01.320Z
8591788 8591788 20251124045718_MYjV8 US003Y 2025-11-25T14:25:08.516Z 2025-12-02T15:13:00.534Z
8591734 8591734 20251124044901_0Fj6U US003Y 2025-11-25T14:25:02.686Z 2025-12-02T15:13:00.271Z
8591625 8591625 20251124043740_dmYPc US003Y 2025-11-25T14:24:40.298Z 2025-12-02T15:12:59.729Z
8591022 8591022 20251124033745_1AY5q US003Y 2025-11-25T14:23:17.014Z 2025-12-02T15:12:56.700Z
8589908 8589908 20251124020428_Woj4K US003Y 2025-11-25T14:20:54.653Z 2025-12-02T15:12:39.968Z
8589080 8589080 20251124010024_IJPxR US003Y 2025-11-25T14:18:58.836Z 2025-12-02T15:12:04.623Z
8588868 8588868 20251124003855_s3mlJ US003Y 2025-11-25T14:18:27.933Z 2025-12-02T15:11:57.182Z
8588359 8588359 20251123234705_ifOWf US003Y 2025-11-25T14:17:26.719Z 2025-12-02T15:11:40.564Z
8584065 8584065 20251123104827_LexZf US003Y 2025-11-25T14:05:13.800Z 2025-12-02T15:09:45.854Z
8583315 8583315 20251124102638_333aA US003Y 2025-11-25T14:01:18.325Z 2025-12-02T15:05:28.576Z
8583138 8583138 20251124094221_nMR1T US003Y 2025-11-25T14:00:25.038Z 2025-12-02T15:05:25.925Z
8583028 8583028 20251123094421_grNUh US003Y 2025-11-24T14:34:45.904Z 2025-12-01T15:22:30.955Z
8582862 8582862 20251123085733_BzqgC US003Y 2025-11-24T14:34:34.245Z 2025-12-01T15:22:28.689Z
8582800 8582800 20251123083529_N32i8 US003Y 2025-11-24T14:34:31.215Z 2025-12-01T15:22:28.072Z
8582793 8582793 20251123083406_kWlzM US003Y 2025-11-24T14:34:30.931Z 2025-12-01T15:22:27.950Z
8582780 8582780 20251123082947_2UQmr US003Y 2025-11-24T14:34:30.453Z 2025-12-01T15:22:27.886Z
8582763 8582763 20251123082525_MGAfo US003Y 2025-11-24T14:34:29.482Z 2025-12-01T15:22:27.660Z
8582705 8582705 20251123080255_KXW55 US003Y 2025-11-24T14:34:25.993Z 2025-12-01T15:22:26.743Z
8582696 8582696 20251123075856_XXd1y US003Y 2025-11-24T14:34:25.546Z 2025-12-01T15:22:26.607Z
8582676 8582676 20251123075040_Nry9V US003Y 2025-11-24T14:34:24.789Z 2025-12-01T15:22:26.445Z
8582644 8582644 20251123073536_7xzGY US003Y 2025-11-24T14:34:23.427Z 2025-12-01T15:22:26.148Z

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