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

4,355 rows where station_code = "HR001Q" 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
8667126 8667126 20251129172719_w2oAz HR001Q 2025-12-02T14:35:05.799Z 2025-12-06T14:45:22.521Z
8655684 8655684 20251130041127_7Txbh HR001Q 2025-12-01T14:27:21.095Z 2025-12-06T14:49:26.472Z
8655232 8655232 20251130034934_OWTnh HR001Q 2025-12-01T14:26:40.617Z 2025-12-06T14:48:55.916Z
8654099 8654099 20251130025854_7JrDT HR001Q 2025-12-01T14:24:51.499Z 2025-12-06T14:48:37.488Z
8653499 8653499 20251130022112_zXFo7 HR001Q 2025-12-01T14:23:36.584Z 2025-12-06T14:48:03.855Z
8653497 8653497 20251130022057_0f2tj HR001Q 2025-12-01T14:23:36.221Z 2025-12-06T14:48:03.557Z
8653326 8653326 20251130021021_vOjjR HR001Q 2025-12-01T14:23:14.365Z 2025-12-06T14:47:55.761Z
8653237 8653237 20251130020357_QvGqk HR001Q 2025-12-01T14:23:06.688Z 2025-12-06T14:47:51.915Z
8652993 8652993 20251130014929_519g6 HR001Q 2025-12-01T14:22:37.296Z 2025-12-06T14:47:47.428Z
8651820 8651820 20251130002346_f1F9W HR001Q 2025-12-01T14:20:00.256Z 2025-12-06T14:46:54.677Z
8651411 8651411 20251129233936_hrpPT HR001Q 2025-12-01T14:19:00.821Z 2025-12-06T14:46:45.728Z
8651203 8651203 20251129230450_WLLQG HR001Q 2025-12-01T14:18:22.751Z 2025-12-06T14:46:41.802Z
8651195 8651195 20251129230330_E4d3e HR001Q 2025-12-01T14:18:20.982Z 2025-12-06T14:46:41.746Z
8651135 8651135 20251129224649_kodHh HR001Q 2025-12-01T14:18:04.788Z 2025-12-06T14:46:40.549Z
8650973 8650973 20251129221829_WWA9H HR001Q 2025-12-01T14:17:39.520Z 2025-12-06T14:46:37.368Z
8650785 8650785 20251129212703_3sDxv HR001Q 2025-12-01T14:17:10.091Z 2025-12-06T14:46:33.743Z
8650448 8650448 20251129202142_mSLFI HR001Q 2025-12-01T14:16:14.012Z 2025-12-06T14:45:56.814Z
8649573 8649573 20251129175010_e5Fn2 HR001Q 2025-12-01T14:13:08.009Z 2025-12-06T14:45:33.376Z
8649442 8649442 20251129172719_1D8N3 HR001Q 2025-12-01T14:12:34.066Z 2025-12-01T14:35:20.743Z
8647123 8647123 20251129034542_VYHNe HR001Q 2025-11-30T14:27:43.140Z 2025-12-06T14:56:32.442Z
8645705 8645705 20251128233354_UT4yc HR001Q 2025-11-30T14:24:25.288Z 2025-12-06T14:55:02.417Z
8645656 8645656 20251128231829_v1DqL HR001Q 2025-11-30T14:24:21.278Z 2025-12-06T14:55:01.686Z
8636186 8636186 20251128032713_L03b4 HR001Q 2025-11-29T14:25:02.890Z 2025-12-06T15:02:57.174Z
8634682 8634682 20251128011004_uQ93w HR001Q 2025-11-29T14:21:55.479Z 2025-12-06T15:02:29.473Z
8634005 8634005 20251128001403_V3Mho HR001Q 2025-11-29T14:20:37.270Z 2025-12-06T15:01:50.536Z
8633305 8633305 20251127230122_qlx21 HR001Q 2025-11-29T14:19:23.750Z 2025-12-06T15:01:42.173Z
8632220 8632220 20251127204208_Gb9DT HR001Q 2025-11-29T14:17:09.300Z 2025-12-06T15:01:02.733Z
8623600 8623600 20251127012301_F1Cgn HR001Q 2025-11-28T14:22:14.685Z 2025-12-05T15:04:04.310Z
8623533 8623533 20251127010103_FLHmS HR001Q 2025-11-28T14:22:06.854Z 2025-12-05T15:03:58.647Z
8622848 8622848 20251126214917_F2ehH HR001Q 2025-11-28T14:20:10.937Z 2025-12-05T15:03:16.556Z
8585839 8585839 20251123180038_P1LO6 HR001Q 2025-11-25T14:11:06.825Z 2025-12-02T15:10:22.510Z
8528646 8528646 20251119044322_RacsV HR001Q 2025-11-20T14:43:32.082Z 2025-11-20T14:43:32.082Z
8527175 8527175 20251119011621_D3Iwq HR001Q 2025-11-20T14:41:00.172Z 2025-11-27T15:12:08.370Z
8526422 8526422 20251118222849_5lKRH HR001Q 2025-11-20T14:39:54.512Z 2025-11-27T15:11:47.854Z
8524584 8524584 20251119035833_i7fp8 HR001Q 2025-11-20T14:21:04.408Z 2025-11-27T15:12:59.199Z
8524403 8524403 20251119034253_4QmEK HR001Q 2025-11-20T14:20:48.674Z 2025-11-27T15:12:54.330Z
8523363 8523363 20251119015815_2Krs3 HR001Q 2025-11-20T14:18:12.804Z 2025-11-27T15:12:12.974Z
8522896 8522896 20251119010622_rGrO8 HR001Q 2025-11-20T14:16:54.166Z 2025-11-27T15:12:07.594Z
8522736 8522736 20251119005013_8WNvc HR001Q 2025-11-20T14:16:23.810Z 2025-11-27T15:12:06.146Z
8504060 8504060 20251117182616_Vq9ki HR001Q 2025-11-19T14:07:07.983Z 2025-11-26T15:07:09.556Z
8465874 8465874 20251114172138_q4PiW HR001Q 2025-11-16T14:10:30.676Z 2025-11-23T15:16:59.169Z
8446546 8446546 20251112174741_7n3WL HR001Q 2025-11-14T14:11:14.639Z 2025-11-21T15:11:11.478Z
8446335 8446335 20251112171608_Bd1zM HR001Q 2025-11-14T14:10:22.222Z 2025-11-21T15:11:09.332Z
8438997 8438997 20251112030132_qFAqB HR001Q 2025-11-13T14:25:18.481Z 2025-11-20T15:24:56.099Z
8438013 8438013 20251112010915_fjc3P HR001Q 2025-11-13T14:22:30.972Z 2025-11-20T15:24:08.708Z
8437977 8437977 20251112010606_Zbfl8 HR001Q 2025-11-13T14:22:24.162Z 2025-11-20T15:24:03.739Z
8437024 8437024 20251111230734_aFP7H HR001Q 2025-11-13T14:19:50.967Z 2025-11-20T15:23:08.035Z
8436875 8436875 20251111224534_djxj4 HR001Q 2025-11-13T14:19:29.519Z 2025-11-20T15:23:02.370Z
8435432 8435432 20251111193734_aDuRW HR001Q 2025-11-13T14:15:32.746Z 2025-11-20T15:22:17.186Z
8435055 8435055 20251111190637_tqEMg HR001Q 2025-11-13T14:14:22.865Z 2025-11-20T15:21:59.277Z
8434666 8434666 20251111183417_rS5Nw HR001Q 2025-11-13T14:13:30.228Z 2025-11-20T15:21:47.903Z
8426522 8426522 20251111031416_dXzk7 HR001Q 2025-11-12T14:25:39.824Z 2025-11-19T15:17:19.662Z
8423295 8423295 20251110230559_lRTpf HR001Q 2025-11-12T14:18:13.735Z 2025-11-19T15:15:51.430Z
8423137 8423137 20251110225653_VmJxQ HR001Q 2025-11-12T14:17:51.025Z 2025-11-19T15:15:45.254Z
8423046 8423046 20251110225101_8s4AT HR001Q 2025-11-12T14:17:40.895Z 2025-11-19T15:15:38.002Z
8423044 8423044 20251110225055_YGewY HR001Q 2025-11-12T14:17:40.638Z 2025-11-19T15:15:37.957Z
8421963 8421963 20251110212305_wNgwI HR001Q 2025-11-12T14:15:07.652Z 2025-11-19T15:14:57.510Z
8421367 8421367 20251110203057_pDehq HR001Q 2025-11-12T14:13:44.259Z 2025-11-19T15:14:31.416Z
8413917 8413917 20251110011039_zPYYk HR001Q 2025-11-11T14:18:51.186Z 2025-11-18T15:20:25.574Z
8413737 8413737 20251110003556_N33ZW HR001Q 2025-11-11T14:18:14.721Z 2025-11-18T15:20:23.979Z
8413474 8413474 20251109233413_5O8Mw HR001Q 2025-11-11T14:17:33.219Z 2025-11-18T15:20:21.589Z
8413187 8413187 20251109222818_wZ6Pq HR001Q 2025-11-11T14:16:34.324Z 2025-11-18T15:20:19.236Z
8413138 8413138 20251109221847_giobQ HR001Q 2025-11-11T14:16:19.163Z 2025-11-18T15:20:18.627Z
8412436 8412436 20251109202111_DOqNr HR001Q 2025-11-11T14:14:06.596Z 2025-11-18T15:20:11.200Z
8412367 8412367 20251109201358_WnjLy HR001Q 2025-11-11T14:13:53.970Z 2025-11-18T15:20:10.276Z
8412298 8412298 20251109200446_1NnQs HR001Q 2025-11-11T14:13:34.274Z 2025-11-18T15:20:09.669Z
8411859 8411859 20251109192839_A2NAn HR001Q 2025-11-11T14:12:13.008Z 2025-11-18T15:19:54.610Z
8411708 8411708 20251109191453_Le81t HR001Q 2025-11-11T14:11:46.210Z 2025-11-18T15:19:50.709Z
8411083 8411083 20251109180700_EsSi1 HR001Q 2025-11-11T14:09:42.938Z 2025-11-18T15:19:23.993Z
8410921 8410921 20251109174930_5UY3N HR001Q 2025-11-11T14:09:08.928Z 2025-11-18T15:19:16.840Z
8410507 8410507 20251109165512_4aJvL HR001Q 2025-11-11T14:07:47.845Z 2025-11-18T15:19:00.992Z
8403192 8403192 20251108223844_FuXBv HR001Q 2025-11-10T14:08:29.574Z 2025-11-17T14:58:32.834Z
8403165 8403165 20251108223407_3KEnf HR001Q 2025-11-10T14:08:26.750Z 2025-11-17T14:58:32.566Z
8402165 8402165 20251108184039_O482A HR001Q 2025-11-10T14:05:44.497Z 2025-11-17T14:58:11.903Z
8398008 8398008 20251108031809_oQxEo HR001Q 2025-11-09T14:13:52.450Z 2025-11-16T15:04:32.873Z
8396542 8396542 20251107213453_t4zFg HR001Q 2025-11-09T14:08:54.108Z 2025-11-16T15:03:33.898Z
8390477 8390477 20251107003806_34VUT HR001Q 2025-11-08T14:11:15.065Z 2025-11-15T15:00:03.053Z
8389122 8389122 20251106192929_T0go9 HR001Q 2025-11-08T14:05:26.334Z 2025-11-15T14:59:31.850Z
8388872 8388872 20251106174415_N2DHL HR001Q 2025-11-08T14:04:05.183Z 2025-11-15T14:59:22.002Z
8385933 8385933 20251106020137_FmBFZ HR001Q 2025-11-07T14:08:55.096Z 2025-11-14T15:08:30.203Z
8385468 8385468 20251106000711_8W2kP HR001Q 2025-11-07T14:06:51.895Z 2025-11-14T15:08:14.877Z
8385398 8385398 20251105234054_7lwBE HR001Q 2025-11-07T14:06:34.770Z 2025-11-14T15:08:08.520Z
8385243 8385243 20251105223522_76GEe HR001Q 2025-11-07T14:05:57.506Z 2025-11-14T15:08:05.459Z
8385098 8385098 20251105213309_2MAs2 HR001Q 2025-11-07T14:05:21.598Z 2025-11-14T15:07:57.182Z
8384963 8384963 20251105200130_PskJi HR001Q 2025-11-07T14:04:41.696Z 2025-11-14T15:07:50.478Z
8384779 8384779 20251105174351_Wgp33 HR001Q 2025-11-07T14:03:35.345Z 2025-11-14T15:07:44.000Z
8380551 8380551 20251105022114_gCgm1 HR001Q 2025-11-06T14:12:07.068Z 2025-11-13T15:14:56.396Z
8380312 8380312 20251105013639_3tXkh HR001Q 2025-11-06T14:11:19.117Z 2025-11-13T15:14:50.763Z
8380025 8380025 20251105002505_05EJM HR001Q 2025-11-06T14:10:06.951Z 2025-11-13T15:14:35.897Z
8379458 8379458 20251104222317_4cVWc HR001Q 2025-11-06T14:07:57.719Z 2025-11-13T15:14:14.736Z
8379024 8379024 20251104202812_X5qyF HR001Q 2025-11-06T14:06:17.423Z 2025-11-13T15:13:57.381Z
8378908 8378908 20251104195815_aYRLu HR001Q 2025-11-06T14:05:53.418Z 2025-11-13T15:13:52.464Z
8378845 8378845 20251104194359_SOE3v HR001Q 2025-11-06T14:05:40.314Z 2025-11-13T15:13:47.946Z
8370293 8370293 20251104012416_s57Z4 HR001Q 2025-11-05T14:10:22.815Z 2025-11-12T15:10:28.784Z
8370105 8370105 20251104002749_xkmla HR001Q 2025-11-05T14:09:28.811Z 2025-11-12T15:10:15.890Z
8368944 8368944 20251103174201_35Dt0 HR001Q 2025-11-05T14:04:41.305Z 2025-11-12T15:08:46.274Z
8368909 8368909 20251103172653_ueT4t HR001Q 2025-11-05T14:04:28.357Z 2025-11-12T15:08:45.490Z
8300071 8300071 20251029043322_ZHdr9 HR001Q 2025-10-30T12:52:58.969Z 2025-10-30T12:52:58.969Z
8297002 8297002 20251028223101_Nc1xo HR001Q 2025-10-30T12:48:44.912Z 2025-11-06T15:12:24.926Z
8296961 8296961 20251028222247_Nxnm3 HR001Q 2025-10-30T12:48:37.358Z 2025-11-06T15:12:24.585Z

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