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,161 rows where station_code = "HR002K" 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
8667485 8667485 20251130015144_tq111 HR002K 2025-12-02T14:38:39.939Z 2025-12-06T14:47:48.392Z
8667335 8667335 20251129235521_7hcgm HR002K 2025-12-02T14:37:18.036Z 2025-12-06T14:46:48.311Z
8665492 8665492 20251201032641_P7Akh HR002K 2025-12-02T14:23:46.654Z 2025-12-06T14:41:38.662Z
8665420 8665420 20251201031921_nWlTD HR002K 2025-12-02T14:23:40.116Z 2025-12-06T14:41:37.328Z
8665120 8665120 20251201023307_2U4qY HR002K 2025-12-02T14:22:58.224Z 2025-12-06T14:41:27.506Z
8656660 8656660 20251130050525_rC5A8 HR002K 2025-12-01T14:28:52.960Z 2025-12-01T14:28:52.960Z
8656602 8656602 20251130050052_SE5Us HR002K 2025-12-01T14:28:46.923Z 2025-12-01T14:28:46.923Z
8656493 8656493 20251130045725_FwetB HR002K 2025-12-01T14:28:41.840Z 2025-12-01T14:28:41.840Z
8656435 8656435 20251130045609_CpVNw HR002K 2025-12-01T14:28:38.741Z 2025-12-06T14:49:34.803Z
8656399 8656399 20251130045311_ZZA3M HR002K 2025-12-01T14:28:35.663Z 2025-12-01T14:28:35.663Z
8656382 8656382 20251130045226_j4Cvb HR002K 2025-12-01T14:28:34.735Z 2025-12-06T14:49:34.190Z
8656379 8656379 20251130045216_JGRQR HR002K 2025-12-01T14:28:34.449Z 2025-12-06T14:49:34.173Z
8656317 8656317 20251130044916_34waT HR002K 2025-12-01T14:28:19.888Z 2025-12-01T14:28:19.888Z
8656271 8656271 20251130044603_5HeLa HR002K 2025-12-01T14:28:15.081Z 2025-12-06T14:49:32.933Z
8656187 8656187 20251130044209_qGk2q HR002K 2025-12-01T14:28:09.460Z 2025-12-06T14:49:32.036Z
8656163 8656163 20251130044103_Q9JmI HR002K 2025-12-01T14:28:07.446Z 2025-12-06T14:49:31.743Z
8656137 8656137 20251130043932_BhRba HR002K 2025-12-01T14:28:05.971Z 2025-12-06T14:49:31.350Z
8656037 8656037 20251130043200_r286o HR002K 2025-12-01T14:27:58.235Z 2025-12-01T14:27:58.235Z
8656012 8656012 20251130043011_YXofp HR002K 2025-12-01T14:27:56.238Z 2025-12-06T14:49:29.697Z
8655824 8655824 20251130042017_Vhuso HR002K 2025-12-01T14:27:31.727Z 2025-12-06T14:49:28.262Z
8655803 8655803 20251130041931_j3jiN HR002K 2025-12-01T14:27:30.667Z 2025-12-06T14:49:28.126Z
8655618 8655618 20251130040916_KXtX9 HR002K 2025-12-01T14:27:17.819Z 2025-12-01T14:27:17.819Z
8655480 8655480 20251130040353_BUsu7 HR002K 2025-12-01T14:26:59.250Z 2025-12-06T14:49:22.150Z
8655385 8655385 20251130040009_uPdEU HR002K 2025-12-01T14:26:52.376Z 2025-12-06T14:49:11.264Z
8655354 8655354 20251130035742_RFOAk HR002K 2025-12-01T14:26:49.728Z 2025-12-06T14:49:09.170Z
8655313 8655313 20251130035431_Nr2QA HR002K 2025-12-01T14:26:45.591Z 2025-12-06T14:49:05.746Z
8655145 8655145 20251130034618_HNq3D HR002K 2025-12-01T14:26:34.091Z 2025-12-06T14:48:52.079Z
8655131 8655131 20251130034519_8lENA HR002K 2025-12-01T14:26:24.619Z 2025-12-06T14:48:51.752Z
8654882 8654882 20251130033713_0qBd6 HR002K 2025-12-01T14:26:08.791Z 2025-12-01T14:26:08.791Z
8654858 8654858 20251130033609_3fd3r HR002K 2025-12-01T14:26:07.250Z 2025-12-01T14:26:07.250Z
8654851 8654851 20251130033608_kgDrW HR002K 2025-12-01T14:26:06.458Z 2025-12-01T14:26:06.458Z
8654837 8654837 20251130033537_d2GPk HR002K 2025-12-01T14:26:05.663Z 2025-12-06T14:48:49.080Z
8654822 8654822 20251130033446_IRT3Z HR002K 2025-12-01T14:26:04.449Z 2025-12-06T14:48:48.880Z
8654783 8654783 20251130033301_gFxGr HR002K 2025-12-01T14:26:01.147Z 2025-12-06T14:48:48.377Z
8654715 8654715 20251130032825_BWsW3 HR002K 2025-12-01T14:25:47.079Z 2025-12-01T14:25:47.079Z
8654712 8654712 20251130032812_KQpSe HR002K 2025-12-01T14:25:46.741Z 2025-12-01T14:25:46.741Z
8654703 8654703 20251130032727_2Dzp1 HR002K 2025-12-01T14:25:46.057Z 2025-12-06T14:48:46.115Z
8654612 8654612 20251130032230_yTQha HR002K 2025-12-01T14:25:37.444Z 2025-12-01T14:25:37.444Z
8654485 8654485 20251130031811_Bhhil HR002K 2025-12-01T14:25:28.500Z 2025-12-01T14:25:28.500Z
8654395 8654395 20251130031416_kJuI1 HR002K 2025-12-01T14:25:22.339Z 2025-12-06T14:48:41.856Z
8654382 8654382 20251130031322_OATDZ HR002K 2025-12-01T14:25:21.222Z 2025-12-06T14:48:41.545Z
8654108 8654108 20251130025914_I9qRf HR002K 2025-12-01T14:24:52.224Z 2025-12-06T14:48:37.643Z
8654058 8654058 20251130025518_JxX1e HR002K 2025-12-01T14:24:47.625Z 2025-12-06T14:48:36.665Z
8653810 8653810 20251130024209_ELUGF HR002K 2025-12-01T14:24:17.537Z 2025-12-06T14:48:32.609Z
8653514 8653514 20251130022209_wI2sx HR002K 2025-12-01T14:23:38.009Z 2025-12-06T14:48:06.090Z
8653508 8653508 20251130022140_FgfhX HR002K 2025-12-01T14:23:37.394Z 2025-12-06T14:48:05.280Z
8653455 8653455 20251130021707_nAnzg HR002K 2025-12-01T14:23:32.432Z 2025-12-06T14:47:58.451Z
8653388 8653388 20251130021334_2jzXg HR002K 2025-12-01T14:23:20.144Z 2025-12-06T14:47:57.187Z
8653302 8653302 20251130020919_0AC4g HR002K 2025-12-01T14:23:12.185Z 2025-12-06T14:47:54.955Z
8653207 8653207 20251130020311_RBsVh HR002K 2025-12-01T14:23:04.445Z 2025-12-06T14:47:51.532Z
8653028 8653028 20251130015133_Ufm1X HR002K 2025-12-01T14:22:40.082Z 2025-12-06T14:47:48.340Z
8652887 8652887 20251130014417_iucsK HR002K 2025-12-01T14:22:28.770Z 2025-12-06T14:47:44.756Z
8652848 8652848 20251130013800_y6abb HR002K 2025-12-01T14:22:14.174Z 2025-12-06T14:47:43.370Z
8652613 8652613 20251130012431_E9AE2 HR002K 2025-12-01T14:21:51.919Z 2025-12-06T14:47:40.142Z
8652504 8652504 20251130011303_qz6vc HR002K 2025-12-01T14:21:32.768Z 2025-12-06T14:47:37.899Z
8652489 8652489 20251130011247_1ZS0J HR002K 2025-12-01T14:21:30.456Z 2025-12-06T14:47:37.718Z
8652320 8652320 20251130010250_ipgRI HR002K 2025-12-01T14:21:15.597Z 2025-12-06T14:47:35.384Z
8652263 8652263 20251130010016_zz3uW HR002K 2025-12-01T14:21:04.635Z 2025-12-06T14:47:33.148Z
8652190 8652190 20251130005419_QipBq HR002K 2025-12-01T14:20:54.055Z 2025-12-06T14:47:29.679Z
8652184 8652184 20251130005338_NNybi HR002K 2025-12-01T14:20:53.342Z 2025-12-06T14:47:28.672Z
8652163 8652163 20251130005116_mb1jI HR002K 2025-12-01T14:20:50.405Z 2025-12-06T14:47:24.894Z
8652149 8652149 20251130005049_ZF4QK HR002K 2025-12-01T14:20:48.960Z 2025-12-06T14:47:23.752Z
8652121 8652121 20251130004913_GkaIi HR002K 2025-12-01T14:20:46.216Z 2025-12-06T14:47:21.276Z
8651893 8651893 20251130003218_kG2RQ HR002K 2025-12-01T14:20:13.148Z 2025-12-06T14:46:55.819Z
8651872 8651872 20251130002949_9J8OL HR002K 2025-12-01T14:20:09.693Z 2025-12-06T14:46:55.418Z
8651868 8651868 20251130002930_0dw2V HR002K 2025-12-01T14:20:09.337Z 2025-12-06T14:46:55.317Z
8651649 8651649 20251130000813_bv5sn HR002K 2025-12-01T14:19:38.404Z 2025-12-06T14:46:50.102Z
8651438 8651438 20251129234248_xqWTv HR002K 2025-12-01T14:19:07.698Z 2025-12-06T14:46:46.179Z
8651397 8651397 20251129233808_fFiMA HR002K 2025-12-01T14:18:58.821Z 2025-12-06T14:46:45.451Z
8651346 8651346 20251129233016_gTb37 HR002K 2025-12-01T14:18:50.296Z 2025-12-06T14:46:44.266Z
8651343 8651343 20251129232952_xy0BK HR002K 2025-12-01T14:18:50.026Z 2025-12-06T14:46:44.227Z
8651294 8651294 20251129232157_pGbgW HR002K 2025-12-01T14:18:41.540Z 2025-12-06T14:46:43.393Z
8651167 8651167 20251129225622_CC3gR HR002K 2025-12-01T14:18:10.828Z 2025-12-06T14:46:41.311Z
8651032 8651032 20251129222817_WaFR0 HR002K 2025-12-01T14:17:52.426Z 2025-12-06T14:46:38.568Z
8650997 8650997 20251129222259_ZqHAW HR002K 2025-12-01T14:17:45.201Z 2025-12-06T14:46:37.933Z
8650926 8650926 20251129220706_Yg81E HR002K 2025-12-01T14:17:33.081Z 2025-12-06T14:46:36.049Z
8650883 8650883 20251129215527_xMmlE HR002K 2025-12-01T14:17:27.056Z 2025-12-06T14:46:35.201Z
8650254 8650254 20251129194646_x2qCR HR002K 2025-12-01T14:15:38.666Z 2025-12-06T14:45:52.936Z
8650100 8650100 20251129192142_Oe7J9 HR002K 2025-12-01T14:15:04.807Z 2025-12-06T14:45:48.125Z
8649667 8649667 20251129180420_5wC7Z HR002K 2025-12-01T14:13:27.736Z 2025-12-06T14:45:35.861Z
8649601 8649601 20251129175445_n33d7 HR002K 2025-12-01T14:13:14.440Z 2025-12-06T14:45:33.900Z
8647702 8647702 20251129051129_EYBtQ HR002K 2025-11-30T14:28:46.092Z 2025-12-06T14:56:44.591Z
8647656 8647656 20251129050233_LHXu6 HR002K 2025-11-30T14:28:42.158Z 2025-12-06T14:56:42.625Z
8647578 8647578 20251129045223_K5TZN HR002K 2025-11-30T14:28:36.669Z 2025-12-06T14:56:41.529Z
8647574 8647574 20251129045222_QUwDr HR002K 2025-11-30T14:28:36.519Z 2025-12-06T14:56:41.486Z
8647516 8647516 20251129044646_RV2R2 HR002K 2025-11-30T14:28:32.069Z 2025-12-06T14:56:40.395Z
8647464 8647464 20251129043912_jhv51 HR002K 2025-11-30T14:28:27.835Z 2025-12-06T14:56:39.506Z
8647393 8647393 20251129042919_bHGlY HR002K 2025-11-30T14:28:05.614Z 2025-12-06T14:56:37.938Z
8647379 8647379 20251129042852_bQgww HR002K 2025-11-30T14:28:04.413Z 2025-12-06T14:56:37.801Z
8647288 8647288 20251129041538_LK89V HR002K 2025-11-30T14:27:56.642Z 2025-12-06T14:56:35.902Z
8647169 8647169 20251129035552_yELAM HR002K 2025-11-30T14:27:47.128Z 2025-12-06T14:56:33.222Z
8647111 8647111 20251129034451_O57Rs HR002K 2025-11-30T14:27:41.947Z 2025-12-06T14:56:32.211Z
8647078 8647078 20251129033706_xCRLz HR002K 2025-11-30T14:27:25.348Z 2025-12-06T14:56:31.258Z
8647068 8647068 20251129033535_2G5m3 HR002K 2025-11-30T14:27:23.792Z 2025-12-06T14:56:31.112Z
8647065 8647065 20251129033451_GoSeb HR002K 2025-11-30T14:27:23.627Z 2025-12-06T14:56:31.096Z
8646938 8646938 20251129031523_JcvNs HR002K 2025-11-30T14:27:09.140Z 2025-12-06T14:56:28.243Z
8646778 8646778 20251129025242_NfEgB HR002K 2025-11-30T14:26:56.939Z 2025-12-06T14:56:25.023Z
8646770 8646770 20251129025216_GVe2Y HR002K 2025-11-30T14:26:56.321Z 2025-12-06T14:56:24.902Z
8646748 8646748 20251129024804_Zj434 HR002K 2025-11-30T14:26:47.363Z 2025-12-06T14:56:24.497Z
8646618 8646618 20251129023116_n79g9 HR002K 2025-11-30T14:26:23.341Z 2025-12-06T14:56:19.119Z

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