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

3,873 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
8952307 8952307 20251215022613_RKR28 HR002K 2025-12-24T15:09:22.734Z 2025-12-24T15:09:22.734Z
8952287 8952287 20251215022552_z3qwS HR002K 2025-12-24T15:09:22.240Z 2025-12-24T15:09:22.240Z
8952285 8952285 20251215022551_YC139 HR002K 2025-12-24T15:09:22.075Z 2025-12-24T15:09:22.075Z
8952257 8952257 20251215022358_dcZr9 HR002K 2025-12-24T15:09:21.477Z 2025-12-24T15:09:21.477Z
8952222 8952222 20251215022157_xGz6w HR002K 2025-12-24T15:09:21.054Z 2025-12-24T15:09:21.054Z
8952170 8952170 20251215022040_R4WO0 HR002K 2025-12-24T15:09:20.359Z 2025-12-24T15:09:20.359Z
8952126 8952126 20251215021825_7eK3s HR002K 2025-12-24T15:09:19.449Z 2025-12-24T15:09:19.449Z
8952121 8952121 20251215021810_tmnpE HR002K 2025-12-24T15:09:19.445Z 2025-12-24T15:09:19.445Z
8952118 8952118 20251215021802_grQtl HR002K 2025-12-24T15:09:19.418Z 2025-12-24T15:09:19.418Z
8952111 8952111 20251215021725_F6b4f HR002K 2025-12-24T15:09:19.278Z 2025-12-24T15:09:19.278Z
8952080 8952080 20251215021457_MKlky HR002K 2025-12-24T15:09:18.680Z 2025-12-24T15:09:18.680Z
8952071 8952071 20251215021446_75dNc HR002K 2025-12-24T15:09:18.485Z 2025-12-24T15:09:18.485Z
8952068 8952068 20251215021434_bV97c HR002K 2025-12-24T15:09:18.482Z 2025-12-24T15:09:18.482Z
8952061 8952061 20251215021431_zyY7i HR002K 2025-12-24T15:09:18.325Z 2025-12-24T15:09:18.325Z
8952055 8952055 20251215021419_WeB9c HR002K 2025-12-24T15:09:18.322Z 2025-12-24T15:09:18.322Z
8952050 8952050 20251215021414_IxWjl HR002K 2025-12-24T15:09:18.299Z 2025-12-24T15:09:18.299Z
8952031 8952031 20251215021329_j3P49 HR002K 2025-12-24T15:09:18.199Z 2025-12-24T15:09:18.199Z
8952023 8952023 20251215021244_SUHUI HR002K 2025-12-24T15:09:17.996Z 2025-12-24T15:09:17.996Z
8951983 8951983 20251215021118_hCPL3 HR002K 2025-12-24T15:09:17.212Z 2025-12-24T15:09:17.212Z
8951962 8951962 20251215021015_RiNF4 HR002K 2025-12-24T15:09:16.876Z 2025-12-24T15:09:16.876Z
8951813 8951813 20251215020216_UAgcv HR002K 2025-12-24T15:09:14.660Z 2025-12-24T15:09:14.660Z
8951804 8951804 20251215020135_r5ETG HR002K 2025-12-24T15:09:14.410Z 2025-12-24T15:09:14.410Z
8951786 8951786 20251215020124_tusP6 HR002K 2025-12-24T15:09:14.316Z 2025-12-24T15:09:14.316Z
8951776 8951776 20251215020058_4i5x2 HR002K 2025-12-24T15:09:14.292Z 2025-12-24T15:09:14.292Z
8951737 8951737 20251215015905_Timg0 HR002K 2025-12-24T15:09:13.183Z 2025-12-24T15:09:13.183Z
8951710 8951710 20251215015750_CvxqV HR002K 2025-12-24T15:09:12.368Z 2025-12-24T15:09:12.368Z
8951673 8951673 20251215015550_7d7gq HR002K 2025-12-24T15:09:11.946Z 2025-12-24T15:09:11.946Z
8951634 8951634 20251215015411_hm6uc HR002K 2025-12-24T15:09:11.062Z 2025-12-24T15:09:11.062Z
8951595 8951595 20251215015118_6dl7i HR002K 2025-12-24T15:09:09.516Z 2025-12-24T15:09:09.516Z
8951592 8951592 20251215015048_lSui9 HR002K 2025-12-24T15:09:09.513Z 2025-12-24T15:09:09.513Z
8951565 8951565 20251215014922_3ElYa HR002K 2025-12-24T15:08:54.321Z 2025-12-24T15:08:54.321Z
8951525 8951525 20251215014709_WStyg HR002K 2025-12-24T15:08:50.847Z 2025-12-24T15:08:50.847Z
8951509 8951509 20251215014641_roydi HR002K 2025-12-24T15:08:50.794Z 2025-12-24T15:08:50.794Z
8951479 8951479 20251215014437_sDOYE HR002K 2025-12-24T15:08:46.178Z 2025-12-24T15:08:46.178Z
8951439 8951439 20251215014220_Kx72x HR002K 2025-12-24T15:08:27.622Z 2025-12-24T15:08:27.622Z
8951430 8951430 20251215014140_gzHOm HR002K 2025-12-24T15:08:27.375Z 2025-12-24T15:08:27.375Z
8951425 8951425 20251215014129_jg5ZF HR002K 2025-12-24T15:08:25.742Z 2025-12-24T15:08:25.742Z
8951363 8951363 20251215013642_bpvG6 HR002K 2025-12-24T15:08:15.129Z 2025-12-24T15:08:15.129Z
8951308 8951308 20251215013513_bBgK3 HR002K 2025-12-24T15:08:10.102Z 2025-12-24T15:08:10.102Z
8951296 8951296 20251215013426_PUwIB HR002K 2025-12-24T15:08:07.560Z 2025-12-24T15:08:07.560Z
8951283 8951283 20251215013400_rQ0Hr HR002K 2025-12-24T15:08:06.912Z 2025-12-24T15:08:06.912Z
8951246 8951246 20251215013144_0r4Oa HR002K 2025-12-24T15:08:00.813Z 2025-12-24T15:08:00.813Z
8951242 8951242 20251215013144_ITVXW HR002K 2025-12-24T15:08:00.809Z 2025-12-24T15:08:00.809Z
8951216 8951216 20251215013042_8gFZs HR002K 2025-12-24T15:07:58.795Z 2025-12-24T15:07:58.795Z
8951208 8951208 20251215013027_zumnT HR002K 2025-12-24T15:07:57.255Z 2025-12-24T15:07:57.255Z
8951167 8951167 20251215012845_k13Wz HR002K 2025-12-24T15:07:47.857Z 2025-12-24T15:07:47.857Z
8951162 8951162 20251215012844_EdZvZ HR002K 2025-12-24T15:07:47.822Z 2025-12-24T15:07:47.822Z
8951128 8951128 20251215012647_OaydE HR002K 2025-12-24T15:07:47.423Z 2025-12-24T15:07:47.423Z
8951115 8951115 20251215012547_sT26g HR002K 2025-12-24T15:07:47.126Z 2025-12-24T15:07:47.126Z
8951068 8951068 20251215012340_6t0Wk HR002K 2025-12-24T15:07:45.725Z 2025-12-24T15:07:45.725Z
8951044 8951044 20251215012228_4YW5R HR002K 2025-12-24T15:07:45.189Z 2025-12-24T15:07:45.189Z
8951034 8951034 20251215012217_48Apj HR002K 2025-12-24T15:07:44.961Z 2025-12-24T15:07:44.961Z
8950994 8950994 20251215011906_AF9aD HR002K 2025-12-24T15:07:43.488Z 2025-12-24T15:07:43.488Z
8950956 8950956 20251215011718_iedGq HR002K 2025-12-24T15:07:41.718Z 2025-12-24T15:07:41.718Z
8950930 8950930 20251215011550_7D7LB HR002K 2025-12-24T15:07:41.339Z 2025-12-24T15:07:41.339Z
8950899 8950899 20251215011457_VQAg2 HR002K 2025-12-24T15:07:40.291Z 2025-12-24T15:07:40.291Z
8950879 8950879 20251215011358_vLzyU HR002K 2025-12-24T15:07:39.507Z 2025-12-24T15:07:39.507Z
8950834 8950834 20251215011249_M2y43 HR002K 2025-12-24T15:07:38.901Z 2025-12-24T15:07:38.901Z
8950791 8950791 20251215011018_kf328 HR002K 2025-12-24T15:07:37.784Z 2025-12-24T15:07:37.784Z
8950729 8950729 20251215010802_UQld1 HR002K 2025-12-24T15:07:36.580Z 2025-12-24T15:07:36.580Z
8950716 8950716 20251215010712_V8SkC HR002K 2025-12-24T15:07:36.435Z 2025-12-24T15:07:36.435Z
8950710 8950710 20251215010712_2liuj HR002K 2025-12-24T15:07:36.388Z 2025-12-24T15:07:36.388Z
8950687 8950687 20251215010639_6WGJX HR002K 2025-12-24T15:07:36.166Z 2025-12-24T15:07:36.166Z
8950665 8950665 20251215010550_hewSM HR002K 2025-12-24T15:07:35.619Z 2025-12-24T15:07:35.619Z
8950650 8950650 20251215010502_39c1s HR002K 2025-12-24T15:07:35.416Z 2025-12-24T15:07:35.416Z
8950641 8950641 20251215010443_eRJlE HR002K 2025-12-24T15:07:35.201Z 2025-12-24T15:07:35.201Z
8950619 8950619 20251215010311_5v3oI HR002K 2025-12-24T15:07:34.643Z 2025-12-24T15:07:34.643Z
8950555 8950555 20251215010040_wZ7x4 HR002K 2025-12-24T15:07:33.185Z 2025-12-24T15:07:33.185Z
8950523 8950523 20251215005840_GuIJN HR002K 2025-12-24T15:07:32.764Z 2025-12-24T15:07:32.764Z
8950513 8950513 20251215005811_32gTl HR002K 2025-12-24T15:07:32.180Z 2025-12-24T15:07:32.180Z
8950505 8950505 20251215005759_3dTKW HR002K 2025-12-24T15:07:32.005Z 2025-12-24T15:07:32.005Z
8950502 8950502 20251215005759_slv2J HR002K 2025-12-24T15:07:31.987Z 2025-12-24T15:07:31.987Z
8950492 8950492 20251215005649_hN2fp HR002K 2025-12-24T15:07:31.845Z 2025-12-24T15:07:31.845Z
8950482 8950482 20251215005625_w3I2X HR002K 2025-12-24T15:07:31.809Z 2025-12-24T15:07:31.809Z
8950461 8950461 20251215005524_vkl77 HR002K 2025-12-24T15:07:31.294Z 2025-12-24T15:07:31.294Z
8950403 8950403 20251215005204_B2x8X HR002K 2025-12-24T15:07:29.879Z 2025-12-24T15:07:29.879Z
8950394 8950394 20251215005132_fMzNU HR002K 2025-12-24T15:07:29.551Z 2025-12-24T15:07:29.551Z
8950377 8950377 20251215005044_Zz11U HR002K 2025-12-24T15:07:29.219Z 2025-12-24T15:07:29.219Z
8950368 8950368 20251215005031_Qgc7w HR002K 2025-12-24T15:07:29.189Z 2025-12-24T15:07:29.189Z
8950330 8950330 20251215004823_hWrZ3 HR002K 2025-12-24T15:07:28.751Z 2025-12-24T15:07:28.751Z
8950309 8950309 20251215004742_9mI2Y HR002K 2025-12-24T15:07:28.538Z 2025-12-24T15:07:28.538Z
8950299 8950299 20251215004720_ubGOA HR002K 2025-12-24T15:07:28.526Z 2025-12-24T15:07:28.526Z
8950281 8950281 20251215004556_CkZPg HR002K 2025-12-24T15:07:28.258Z 2025-12-24T15:07:28.258Z
8950274 8950274 20251215004553_QupkJ HR002K 2025-12-24T15:07:28.080Z 2025-12-24T15:07:28.080Z
8950269 8950269 20251215004531_Hkmbv HR002K 2025-12-24T15:07:28.045Z 2025-12-24T15:07:28.045Z
8950245 8950245 20251215004335_bdX6G HR002K 2025-12-24T15:07:27.395Z 2025-12-24T15:07:27.395Z
8950238 8950238 20251215004331_OEjjY HR002K 2025-12-24T15:07:27.393Z 2025-12-24T15:07:27.393Z
8950232 8950232 20251215004321_vWB2z HR002K 2025-12-24T15:07:27.390Z 2025-12-24T15:07:27.390Z
8950205 8950205 20251215004216_oLnCe HR002K 2025-12-24T15:07:25.903Z 2025-12-24T15:07:25.903Z
8950196 8950196 20251215004206_n2tkx HR002K 2025-12-24T15:07:24.253Z 2025-12-24T15:07:24.253Z
8950167 8950167 20251215004059_51typ HR002K 2025-12-24T15:07:23.736Z 2025-12-24T15:07:23.736Z
8950152 8950152 20251215004021_2pFxn HR002K 2025-12-24T15:07:09.350Z 2025-12-24T15:07:09.350Z
8950143 8950143 20251215004004_9xg2W HR002K 2025-12-24T15:07:09.333Z 2025-12-24T15:07:09.333Z
8950107 8950107 20251215003837_tR1C5 HR002K 2025-12-24T15:07:01.728Z 2025-12-24T15:07:01.728Z
8950072 8950072 20251215003710_dV0NA HR002K 2025-12-24T15:06:53.917Z 2025-12-24T15:06:53.917Z
8950047 8950047 20251215003553_Cges2 HR002K 2025-12-24T15:06:52.118Z 2025-12-24T15:06:52.118Z
8950028 8950028 20251215003513_szfHc HR002K 2025-12-24T15:06:49.993Z 2025-12-24T15:06:49.993Z
8949996 8949996 20251215003357_gF337 HR002K 2025-12-24T15:06:37.834Z 2025-12-24T15:06:37.834Z
8949984 8949984 20251215003333_M2CKM HR002K 2025-12-24T15:06:34.553Z 2025-12-24T15:06:34.553Z
8949978 8949978 20251215003319_vVFSH HR002K 2025-12-24T15:06:34.500Z 2025-12-24T15:06:34.500Z

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