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

2,283 rows where station_code = "HR001P" 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
8656797 8656797 20251130050951_Jou2y HR001P 2025-12-01T14:29:00.939Z 2025-12-06T14:49:41.437Z
8653144 8653144 20251130020019_CmREW HR001P 2025-12-01T14:22:53.204Z 2025-12-06T14:47:50.821Z
8635360 8635360 20251128020712_26Op5 HR001P 2025-11-29T14:23:08.188Z 2025-12-06T15:02:43.649Z
8635246 8635246 20251128015636_o8ML2 HR001P 2025-11-29T14:22:53.846Z 2025-12-06T15:02:42.381Z
8622746 8622746 20251126210128_7mWZq HR001P 2025-11-28T14:19:47.386Z 2025-12-05T15:03:05.744Z
8469651 8469651 20251115031340_CXeDy HR001P 2025-11-16T14:20:46.916Z 2025-11-23T15:17:53.291Z
8439413 8439413 20251112034708_D08Wq HR001P 2025-11-13T14:26:31.727Z 2025-11-20T15:25:22.120Z
8434347 8434347 20251111180923_oRKUP HR001P 2025-11-13T14:12:34.913Z 2025-11-20T15:21:38.076Z
8427046 8427046 20251111040225_b17Vs HR001P 2025-11-12T14:27:08.679Z 2025-11-19T15:17:41.910Z
8426736 8426736 20251111033800_BPRDG HR001P 2025-11-12T14:26:15.537Z 2025-11-19T15:17:25.248Z
8397011 8397011 20251108000338_ysSHl HR001P 2025-11-09T14:10:31.824Z 2025-11-16T15:03:56.767Z
8397008 8397008 20251108000338_2KcRN HR001P 2025-11-09T14:10:31.144Z 2025-11-16T15:03:56.728Z
8396640 8396640 20251107222219_0vKTE HR001P 2025-11-09T14:09:19.896Z 2025-11-16T15:03:35.823Z
8389474 8389474 20251106210344_vCpJ2 HR001P 2025-11-08T14:07:04.495Z 2025-11-15T14:59:39.390Z
8389089 8389089 20251106191904_OqHV0 HR001P 2025-11-08T14:05:19.101Z 2025-11-15T14:59:30.962Z
8385298 8385298 20251105230115_26O8Y HR001P 2025-11-07T14:06:08.606Z 2025-11-14T15:08:07.301Z
8381307 8381307 20251105044038_1JvZz HR001P 2025-11-06T14:14:46.365Z 2025-11-13T15:15:26.635Z
8381200 8381200 20251105042206_9EYp5 HR001P 2025-11-06T14:14:12.699Z 2025-11-13T15:15:20.963Z
8374738 8374738 20251103044524_e3Y29 HR001P 2025-11-05T14:33:08.199Z 2025-11-11T15:08:06.728Z
8371367 8371367 20251104041512_2Iedo HR001P 2025-11-05T14:14:42.344Z 2025-11-12T15:11:00.464Z
8368926 8368926 20251103173532_DgHcu HR001P 2025-11-05T14:04:37.066Z 2025-11-12T15:08:45.991Z
8289019 8289019 20251028181129_8YJwP HR001P 2025-10-30T12:12:10.625Z 2025-11-06T15:11:37.235Z
8130973 8130973 20251017201307_a0mIg HR001P 2025-10-19T12:06:15.106Z 2025-10-26T13:14:57.566Z
8119452 8119452 20251016181115_1N3NW HR001P 2025-10-18T12:13:09.791Z 2025-10-25T13:25:42.169Z
8103763 8103763 20251014234435_bIATM HR001P 2025-10-16T12:13:36.040Z 2025-10-23T13:08:32.347Z
8103032 8103032 20251014202141_W2E7w HR001P 2025-10-16T12:10:39.439Z 2025-10-23T13:08:16.132Z
8091620 8091620 20251012204544_CuziX HR001P 2025-10-14T12:08:24.693Z 2025-10-21T13:09:02.310Z
8074118 8074118 20251008215749_z6xoW HR001P 2025-10-10T12:05:22.933Z 2025-10-17T12:37:20.442Z
8074018 8074018 20251008212616_gjubF HR001P 2025-10-10T12:05:09.724Z 2025-10-17T12:37:18.423Z
8007384 8007384 20250929015954_lSqG1 HR001P 2025-09-30T12:28:30.232Z 2025-10-07T13:01:03.725Z
8004527 8004527 20250928235512_uSPnW HR001P 2025-09-30T12:22:47.760Z 2025-10-07T13:00:47.406Z
8002199 8002199 20250928212907_jF3KT HR001P 2025-09-30T12:17:19.991Z 2025-10-07T13:00:30.176Z
8000679 8000679 20250928191819_nFF6L HR001P 2025-09-30T12:13:14.654Z 2025-10-07T13:00:07.121Z
8000307 8000307 20250928180559_i3hKY HR001P 2025-09-30T12:11:53.713Z 2025-10-07T12:59:53.219Z
7982056 7982056 20250926180029_s7lN4 HR001P 2025-09-28T12:18:50.230Z 2025-10-05T13:10:11.488Z
7932908 7932908 20250921234125_DxOPl HR001P 2025-09-24T12:51:12.708Z 2025-09-30T13:02:58.657Z
7931491 7931491 20250921224037_Y4L9i HR001P 2025-09-24T12:48:46.358Z 2025-09-30T13:02:45.788Z
7927828 7927828 20250921190025_RrzMg HR001P 2025-09-24T12:45:18.375Z 2025-09-30T13:02:08.526Z
7906783 7906783 20250921012750_bJReo HR001P 2025-09-22T12:37:05.606Z 2025-09-29T13:05:35.304Z
7906180 7906180 20250921004525_7yZsD HR001P 2025-09-22T12:36:08.103Z 2025-09-29T13:05:31.717Z
7895552 7895552 20250919235716_1Bf4W HR001P 2025-09-21T12:38:52.158Z 2025-09-28T12:54:41.742Z
7891887 7891887 20250919191047_2I2BO HR001P 2025-09-21T12:32:49.688Z 2025-09-28T12:54:15.166Z
7891885 7891885 20250919191047_f4avO HR001P 2025-09-21T12:32:49.465Z 2025-09-28T12:54:15.071Z
7891836 7891836 20250919190419_X82SL HR001P 2025-09-21T12:32:44.164Z 2025-09-28T12:54:14.587Z
7891635 7891635 20250919182220_Ab3oZ HR001P 2025-09-21T12:32:04.473Z 2025-09-28T12:54:11.575Z
7885425 7885425 20250920034350_hDukz HR001P 2025-09-21T12:08:19.928Z 2025-09-29T13:03:07.649Z
7880081 7880081 20250918205339_TCe3h HR001P 2025-09-20T12:32:12.050Z 2025-09-27T12:47:37.125Z
7879899 7879899 20250918203513_OOTwC HR001P 2025-09-20T12:31:33.252Z 2025-09-27T12:47:36.558Z
7879155 7879155 20250918185505_ehyYc HR001P 2025-09-20T12:29:42.751Z 2025-09-27T12:47:31.553Z
7872365 7872365 20250919012105_kaA31 HR001P 2025-09-20T12:01:57.379Z 2025-09-28T12:53:04.140Z
7871042 7871042 20250917225226_BR7nz HR001P 2025-09-19T12:30:25.036Z 2025-09-25T13:13:02.442Z
7854922 7854922 20250915205331_DJRaz HR001P 2025-09-17T12:35:46.998Z 2025-09-22T13:05:45.912Z
7789023 7789023 20250907191140_36YhO HR001P 2025-09-09T12:01:56.153Z 2025-09-16T12:50:37.763Z
7759126 7759126 20250903212428_myINB HR001P 2025-09-05T12:08:43.984Z 2025-09-12T12:48:41.521Z
7741678 7741678 20250902014058_VIQYC HR001P 2025-09-03T12:20:49.150Z 2025-09-10T12:47:01.222Z
7740705 7740705 20250902004038_yDBKi HR001P 2025-09-03T12:18:39.977Z 2025-09-10T12:46:38.275Z
7739455 7739455 20250901231620_EQ1Q4 HR001P 2025-09-03T12:15:42.477Z 2025-09-10T12:46:11.792Z
7738663 7738663 20250901220955_IF8SG HR001P 2025-09-03T12:13:19.102Z 2025-09-10T12:45:52.163Z
7737867 7737867 20250901205627_tLYOF HR001P 2025-09-03T12:10:47.676Z 2025-09-10T12:45:34.687Z
7737076 7737076 20250901184907_3K7E4 HR001P 2025-09-03T12:07:54.709Z 2025-09-10T12:45:15.388Z
7727842 7727842 20250901000211_Qjbw7 HR001P 2025-09-02T12:21:38.330Z 2025-09-09T12:48:00.321Z
7726218 7726218 20250831220338_xmStu HR001P 2025-09-02T12:17:49.917Z 2025-09-09T12:47:16.245Z
7725157 7725157 20250831203819_m3HM0 HR001P 2025-09-02T12:14:52.528Z 2025-09-09T12:46:44.108Z
7674450 7674450 20250827024318_sGwIy HR001P 2025-08-28T12:26:15.019Z 2025-09-04T12:56:43.935Z
7671349 7671349 20250826230522_KYb8p HR001P 2025-08-28T12:20:23.733Z 2025-09-04T12:56:06.225Z
7669804 7669804 20250826204639_77HAP HR001P 2025-08-28T12:16:29.167Z 2025-09-04T12:55:37.235Z
7661852 7661852 20250826020107_2wwWo HR001P 2025-08-27T12:27:22.210Z 2025-09-03T12:52:58.107Z
7660457 7660457 20250826005604_mOBs0 HR001P 2025-08-27T12:24:20.813Z 2025-09-03T12:52:50.629Z
7658846 7658846 20250825233240_5bf3d HR001P 2025-08-27T12:20:58.973Z 2025-09-03T12:52:40.139Z
7656751 7656751 20250825211813_iZrq3 HR001P 2025-08-27T12:15:58.344Z 2025-09-03T12:52:13.998Z
7655747 7655747 20250825200818_JDj63 HR001P 2025-08-27T12:13:28.085Z 2025-09-03T12:52:07.894Z
7528505 7528505 20250814212505_NO9zK HR001P 2025-08-17T12:49:30.577Z 2025-08-22T12:47:34.408Z
7526980 7526980 20250814193841_jY4QW HR001P 2025-08-17T12:47:05.632Z 2025-08-22T12:47:30.986Z
7520783 7520783 20250815025034_d0bF5 HR001P 2025-08-17T12:20:03.758Z 2025-08-23T12:48:47.583Z
7517946 7517946 20250815011228_3a1BN HR001P 2025-08-17T12:14:42.645Z 2025-08-23T12:48:36.687Z
7512552 7512552 20250814221005_s3133 HR001P 2025-08-17T12:01:50.848Z 2025-08-23T12:48:06.689Z
7505947 7505947 20250814015018_nxycP HR001P 2025-08-16T12:49:38.336Z 2025-08-22T12:46:50.012Z
7505246 7505246 20250814010836_3RrNV HR001P 2025-08-16T12:49:04.854Z 2025-08-22T12:46:47.804Z
7485484 7485484 20250813013022_wS5wa HR001P 2025-08-15T12:28:58.464Z 2025-08-21T12:47:37.522Z
7483873 7483873 20250813004255_Gv0kc HR001P 2025-08-15T12:25:19.867Z 2025-08-21T12:47:31.621Z
7481646 7481646 20250812232416_73HrO HR001P 2025-08-15T12:18:32.528Z 2025-08-21T12:47:26.024Z
7478145 7478145 20250812212138_vXYpl HR001P 2025-08-15T12:07:23.739Z 2025-08-21T12:47:08.905Z
7477448 7477448 20250812205257_l1iyg HR001P 2025-08-15T12:04:32.786Z 2025-08-21T12:47:04.786Z
7447867 7447867 20250812002756_BkkRG HR001P 2025-08-13T12:13:26.868Z 2025-08-20T13:06:00.729Z
7445874 7445874 20250811225956_pB6b3 HR001P 2025-08-13T12:09:56.623Z 2025-08-20T13:05:55.218Z
7432693 7432693 20250811002234_O0ldG HR001P 2025-08-12T12:11:37.833Z 2025-08-18T13:39:03.971Z
7414266 7414266 20250809014328_cPn4q HR001P 2025-08-10T12:10:33.482Z 2025-08-17T13:34:17.037Z
7410659 7410659 20250808203524_Oi6Gd HR001P 2025-08-10T12:01:48.606Z 2025-08-17T13:32:23.747Z
7407389 7407389 20250808022418_PFyqx HR001P 2025-08-09T12:14:53.588Z 2025-08-16T13:20:57.423Z
7406054 7406054 20250808005614_Q33S8 HR001P 2025-08-09T12:11:23.831Z 2025-08-16T13:20:27.916Z
7405957 7405957 20250808004633_HdzHv HR001P 2025-08-09T12:10:59.567Z 2025-08-16T13:20:27.008Z
7395477 7395477 20250807022937_ksEeY HR001P 2025-08-08T12:15:13.639Z 2025-08-15T13:38:34.510Z
7394648 7394648 20250807011542_JUu32 HR001P 2025-08-08T12:13:29.124Z 2025-08-15T13:37:27.215Z
7392332 7392332 20250806193213_REEGT HR001P 2025-08-08T12:05:35.565Z 2025-08-15T13:35:04.753Z
7386544 7386544 20250805230942_lIB3c HR001P 2025-08-07T12:23:58.915Z 2025-08-14T12:57:50.288Z
7379190 7379190 20250805022832_CZHoj HR001P 2025-08-07T12:14:58.952Z 2025-08-13T12:59:05.478Z
7378502 7378502 20250805020650_broRA HR001P 2025-08-07T12:14:11.232Z 2025-08-13T12:58:56.072Z
7378215 7378215 20250805015800_2L1tE HR001P 2025-08-07T12:13:56.236Z 2025-08-13T12:58:52.304Z
7378177 7378177 20250805015656_0oGGb HR001P 2025-08-07T12:13:54.293Z 2025-08-13T12:58:52.067Z
7377674 7377674 20250805014045_VJJ2j HR001P 2025-08-07T12:13:14.259Z 2025-08-13T12:58:48.236Z

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