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,765 rows where station_code = "HR0027" 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
9267483 9267483 20260127020401_GncJX HR0027 2026-01-28T14:21:55.382Z 2026-01-29T14:35:06.832Z
9224560 9224560 20260118051230_vzM01 HR0027 2026-01-19T14:24:55.281Z 2026-01-26T15:03:23.642Z
9223714 9223714 20260118020817_ebMnu HR0027 2026-01-19T14:20:44.322Z 2026-01-26T15:02:33.421Z
9223701 9223701 20260118020534_CwlUM HR0027 2026-01-19T14:20:42.194Z 2026-01-26T15:02:33.018Z
9223101 9223101 20260117230523_l6Qva HR0027 2026-01-19T14:17:44.400Z 2026-01-26T15:01:49.904Z
9222819 9222819 20260117205957_0Yrt3 HR0027 2026-01-19T14:16:24.929Z 2026-01-26T15:01:22.335Z
9222747 9222747 20260117203750_WlMDQ HR0027 2026-01-19T14:16:06.463Z 2026-01-26T15:01:19.585Z
9222455 9222455 20260117193925_PPWUf HR0027 2026-01-19T14:14:52.041Z 2026-01-26T15:00:54.649Z
9198893 9198893 20260113182639_IikHv HR0027 2026-01-15T14:08:00.438Z 2026-01-22T15:07:08.257Z
9188475 9188475 20260111235727_afX3R HR0027 2026-01-13T14:12:30.453Z 2026-01-20T15:21:52.155Z
9188346 9188346 20260111224913_Hjk1V HR0027 2026-01-13T14:11:50.594Z 2026-01-20T15:21:35.508Z
9187873 9187873 20260111191745_jdWsY HR0027 2026-01-13T14:09:21.926Z 2026-01-20T15:20:58.964Z
9187737 9187737 20260111184125_YCDUO HR0027 2026-01-13T14:08:37.549Z 2026-01-20T15:20:43.390Z
9187452 9187452 20260111171159_o5xCi HR0027 2026-01-13T14:07:22.825Z 2026-01-20T15:20:29.315Z
9182214 9182214 20260111044440_ga2EI HR0027 2026-01-12T14:13:44.612Z 2026-01-19T15:18:21.085Z
9182128 9182128 20260111042546_BffiL HR0027 2026-01-12T14:13:22.872Z 2026-01-19T15:18:16.763Z
9181997 9181997 20260111035814_y9Rwo HR0027 2026-01-12T14:12:53.993Z 2026-01-19T15:17:59.435Z
9181823 9181823 20260111032434_c2OmQ HR0027 2026-01-12T14:12:14.910Z 2026-01-19T15:17:50.207Z
9181501 9181501 20260111015916_hiLwk HR0027 2026-01-12T14:11:00.515Z 2026-01-19T15:17:21.978Z
9181260 9181260 20260111010930_T2o2Q HR0027 2026-01-12T14:10:09.118Z 2026-01-19T15:17:10.032Z
9181184 9181184 20260111004921_cJ9YU HR0027 2026-01-12T14:09:53.369Z 2026-01-19T15:17:07.098Z
9181062 9181062 20260111000744_Vu3Ny HR0027 2026-01-12T14:09:27.722Z 2026-01-19T15:16:46.419Z
9121877 9121877 20260101032455_XCBy8 HR0027 2026-01-02T14:09:59.905Z 2026-01-09T14:52:44.081Z
9115525 9115525 20251231051320_uGaF6 HR0027 2026-01-01T14:25:39.899Z 2026-01-08T15:10:51.463Z
9115066 9115066 20251231044531_tkW8i HR0027 2026-01-01T14:24:16.940Z 2026-01-08T15:10:23.890Z
9115040 9115040 20251231044404_pBtpG HR0027 2026-01-01T14:24:13.947Z 2026-01-08T15:10:20.894Z
9114777 9114777 20251231043036_KUOgL HR0027 2026-01-01T14:23:32.140Z 2026-01-08T15:10:09.718Z
9114382 9114382 20251231041435_SyPNh HR0027 2026-01-01T14:22:19.932Z 2026-01-08T15:09:44.582Z
9113581 9113581 20251231033759_Zzxuo HR0027 2026-01-01T14:19:39.316Z 2026-01-08T15:08:51.311Z
9113427 9113427 20251231032824_O2i9f HR0027 2026-01-01T14:18:53.076Z 2026-01-08T15:08:44.036Z
9113415 9113415 20251231032715_pUYKp HR0027 2026-01-01T14:18:47.750Z 2026-01-08T15:08:43.601Z
9113291 9113291 20251231032128_4BEhT HR0027 2026-01-01T14:18:23.477Z 2026-01-01T14:57:52.891Z
9112635 9112635 20251231024309_gknzq HR0027 2026-01-01T14:15:50.358Z 2026-01-08T15:07:54.739Z
9112546 9112546 20251231023656_r1u1k HR0027 2026-01-01T14:15:30.237Z 2026-01-08T15:07:51.749Z
9112063 9112063 20251231020207_NSS5Q HR0027 2026-01-01T14:13:52.446Z 2026-01-08T15:07:16.679Z
9112059 9112059 20251231020158_gCClH HR0027 2026-01-01T14:13:51.724Z 2026-01-08T15:07:16.502Z
9111487 9111487 20251231011324_yTSh3 HR0027 2026-01-01T14:11:41.581Z 2026-01-08T15:06:42.112Z
9111471 9111471 20251231011217_368tI HR0027 2026-01-01T14:11:39.089Z 2026-01-08T15:06:41.548Z
9111406 9111406 20251231010902_2Uhrt HR0027 2026-01-01T14:11:24.758Z 2026-01-01T14:57:50.919Z
9111328 9111328 20251231010239_Zbltm HR0027 2026-01-01T14:11:04.103Z 2026-01-08T15:06:31.385Z
9111245 9111245 20251231005442_eEPQz HR0027 2026-01-01T14:10:44.413Z 2026-01-08T15:06:24.871Z
9111233 9111233 20251231005158_iK23p HR0027 2026-01-01T14:10:40.672Z 2026-01-08T15:06:23.952Z
9111177 9111177 20251231004511_yJC93 HR0027 2026-01-01T14:10:23.242Z 2026-01-08T15:06:19.541Z
9111061 9111061 20251231003404_kTuIt HR0027 2026-01-01T14:09:58.889Z 2026-01-08T15:06:13.826Z
9110721 9110721 20251230235306_u86rs HR0027 2026-01-01T14:08:33.800Z 2026-01-01T14:57:50.110Z
9110609 9110609 20251230234101_uejnL HR0027 2026-01-01T14:08:02.608Z 2026-01-08T15:05:41.704Z
9110512 9110512 20251230232243_JP7jG HR0027 2026-01-01T14:07:35.865Z 2026-01-08T15:05:28.865Z
9109755 9109755 20251230204457_zBe2u HR0027 2026-01-01T14:03:33.669Z 2026-01-08T15:04:26.186Z
9091168 9091168 20251228180833_bZbbs HR0027 2025-12-30T14:52:02.172Z 2026-01-05T15:14:03.976Z
9086027 9086027 20251228042333_5yWC4 HR0027 2025-12-30T14:40:09.844Z 2026-01-05T15:09:52.686Z
9085782 9085782 20251228040154_oQakq HR0027 2025-12-30T14:39:23.093Z 2025-12-31T14:51:33.991Z
9085695 9085695 20251228035155_GAWVL HR0027 2025-12-30T14:39:12.712Z 2026-01-05T15:09:42.055Z
9085555 9085555 20251228033711_vULOp HR0027 2025-12-30T14:38:47.887Z 2026-01-05T15:09:37.211Z
9085472 9085472 20251228032845_GwZMm HR0027 2025-12-30T14:38:37.649Z 2026-01-05T15:09:34.371Z
9085334 9085334 20251228031541_VggZV HR0027 2025-12-30T14:38:12.686Z 2026-01-05T15:09:20.537Z
9085309 9085309 20251228031342_Jzm5E HR0027 2025-12-30T14:38:08.791Z 2026-01-05T15:09:19.868Z
9085265 9085265 20251228030953_LDmW9 HR0027 2025-12-30T14:38:04.394Z 2026-01-05T15:09:17.634Z
8755389 8755389 20251210030742_cNcYv HR0027 2025-12-13T15:44:06.473Z 2025-12-17T15:29:20.285Z
8755256 8755256 20251210025906_iYauH HR0027 2025-12-13T15:44:03.228Z 2025-12-17T15:29:19.119Z
8755203 8755203 20251210025719_mjhDH HR0027 2025-12-13T15:44:01.549Z 2025-12-17T15:29:18.479Z
8755201 8755201 20251210025719_ZhTA4 HR0027 2025-12-13T15:44:01.468Z 2025-12-17T15:29:18.443Z
8755177 8755177 20251210025557_asbti HR0027 2025-12-13T15:44:00.981Z 2025-12-17T15:29:18.319Z
8755040 8755040 20251210024457_QdUrd HR0027 2025-12-13T15:43:56.533Z 2025-12-17T15:29:16.771Z
8755008 8755008 20251210023958_tyqz4 HR0027 2025-12-13T15:43:49.287Z 2025-12-17T15:29:16.291Z
8754569 8754569 20251210020525_uerCE HR0027 2025-12-13T15:43:12.587Z 2025-12-17T15:29:04.391Z
8746789 8746789 20251211033047_K4oPo HR0027 2025-12-13T15:29:29.278Z 2025-12-19T15:16:36.716Z
8746641 8746641 20251211031824_vpeUf HR0027 2025-12-13T15:29:21.796Z 2025-12-19T15:16:32.341Z
8746023 8746023 20251211023204_PAcHw HR0027 2025-12-13T15:28:27.445Z 2025-12-19T15:15:58.909Z
8742767 8742767 20251210224240_8jG9S HR0027 2025-12-13T15:23:07.622Z 2025-12-19T15:13:23.310Z
8742729 8742729 20251210224036_sVXqG HR0027 2025-12-13T15:23:05.489Z 2025-12-19T15:13:22.413Z
8742350 8742350 20251210221503_patkm HR0027 2025-12-13T15:22:17.495Z 2025-12-19T15:13:13.839Z
8742144 8742144 20251210220421_4Bvaf HR0027 2025-12-13T15:22:08.198Z 2025-12-19T15:13:09.270Z
8741766 8741766 20251210213605_aJBIi HR0027 2025-12-13T15:21:21.726Z 2025-12-19T15:12:38.765Z
8741453 8741453 20251210211635_5i41r HR0027 2025-12-13T15:20:43.108Z 2025-12-19T15:12:30.791Z
8741361 8741361 20251210211123_Nmd5v HR0027 2025-12-13T15:20:36.922Z 2025-12-19T15:12:28.683Z
8740839 8740839 20251210201232_Hp0eO HR0027 2025-12-13T15:19:41.299Z 2025-12-19T15:11:54.851Z
8740758 8740758 20251210200221_cuOcB HR0027 2025-12-13T15:19:32.674Z 2025-12-19T15:11:52.193Z
8739974 8739974 20251210180452_n7C77 HR0027 2025-12-13T15:17:35.628Z 2025-12-19T15:11:07.083Z
8739696 8739696 20251210170214_XyiSE HR0027 2025-12-13T15:16:55.579Z 2025-12-19T15:10:38.074Z
8733753 8733753 20251211170803_XtSYN HR0027 2025-12-13T14:49:17.667Z 2025-12-20T14:24:17.079Z
8720247 8720247 20251211045221_gJrb8 HR0027 2025-12-12T14:02:14.359Z 2025-12-20T14:21:58.694Z
8719879 8719879 20251211041628_oQ0hZ HR0027 2025-12-12T14:00:50.972Z 2025-12-20T14:21:50.146Z
8719862 8719862 20251211041553_7VJ0W HR0027 2025-12-12T14:00:46.746Z 2025-12-20T14:21:49.844Z
8656295 8656295 20251130044829_q2pwl HR0027 2025-12-01T14:28:18.996Z 2025-12-08T14:56:10.481Z
8655713 8655713 20251130041229_PtePH HR0027 2025-12-01T14:27:22.282Z 2025-12-08T14:56:01.857Z
8655604 8655604 20251130040833_rCXve HR0027 2025-12-01T14:27:16.606Z 2025-12-08T14:56:01.055Z
8654807 8654807 20251130033339_OYF4A HR0027 2025-12-01T14:26:03.534Z 2025-12-08T14:55:43.039Z
8654757 8654757 20251130033217_7QRLq HR0027 2025-12-01T14:25:58.630Z 2025-12-08T14:55:42.349Z
8654673 8654673 20251130032514_tSNd4 HR0027 2025-12-01T14:25:43.075Z 2025-12-08T14:55:40.961Z
8654532 8654532 20251130031922_843Mm HR0027 2025-12-01T14:25:33.135Z 2025-12-08T14:55:30.430Z
8654172 8654172 20251130030234_nZv7p HR0027 2025-12-01T14:24:56.668Z 2025-12-08T14:55:08.427Z
8652794 8652794 20251130013438_tKL3x HR0027 2025-12-01T14:22:07.802Z 2025-12-08T14:54:32.989Z
8652221 8652221 20251130005551_J00Jx HR0027 2025-12-01T14:20:56.475Z 2025-12-08T14:54:15.591Z
8651730 8651730 20251130001435_TCDNn HR0027 2025-12-01T14:19:46.569Z 2025-12-08T14:54:01.318Z
8647532 8647532 20251129044802_LlRPW HR0027 2025-11-30T14:28:33.249Z 2025-12-07T14:59:13.046Z
8647337 8647337 20251129042351_UBnm6 HR0027 2025-11-30T14:28:00.435Z 2025-12-07T14:58:41.654Z
8645744 8645744 20251128234350_Fv2Kl HR0027 2025-11-30T14:24:28.627Z 2025-12-07T14:57:17.177Z
8645536 8645536 20251128224304_uH53B HR0027 2025-11-30T14:23:56.585Z 2025-12-07T14:57:12.046Z
8635609 8635609 20251128023207_Vcv2d HR0027 2025-11-29T14:23:56.319Z 2025-12-06T15:02:47.231Z
8635579 8635579 20251128022806_zK31A HR0027 2025-11-29T14:23:46.508Z 2025-12-06T15:02:46.849Z

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