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,404 rows where station_code = "HR0008" 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
8673581 8673581 20251201201226_WB033 HR0008 2025-12-03T14:19:22.235Z 2025-12-06T14:33:23.933Z
8661612 8661612 20251130162820_1l0Jq HR0008 2025-12-02T14:12:18.997Z 2025-12-06T14:38:15.816Z
8656333 8656333 20251130045009_2oD4l HR0008 2025-12-01T14:28:21.227Z 2025-12-06T14:49:33.642Z
8656077 8656077 20251130043532_JvQWY HR0008 2025-12-01T14:28:01.494Z 2025-12-06T14:49:30.425Z
8654078 8654078 20251130025609_VTq3m HR0008 2025-12-01T14:24:48.969Z 2025-12-06T14:48:36.968Z
8653617 8653617 20251130023048_ifmQO HR0008 2025-12-01T14:23:48.435Z 2025-12-06T14:48:21.134Z
8653403 8653403 20251130021501_nP4ZV HR0008 2025-12-01T14:23:21.486Z 2025-12-06T14:47:57.541Z
8653168 8653168 20251130020111_3SJT9 HR0008 2025-12-01T14:23:01.580Z 2025-12-06T14:47:51.034Z
8651242 8651242 20251129231107_ScnXL HR0008 2025-12-01T14:18:28.092Z 2025-12-06T14:46:42.406Z
8651161 8651161 20251129225341_J2zCZ HR0008 2025-12-01T14:18:09.726Z 2025-12-06T14:46:40.985Z
8651115 8651115 20251129224536_WjKlP HR0008 2025-12-01T14:18:02.936Z 2025-12-06T14:46:40.265Z
8650881 8650881 20251129214942_2IK0w HR0008 2025-12-01T14:17:26.487Z 2025-12-06T14:46:35.116Z
8650057 8650057 20251129191417_8e1rQ HR0008 2025-12-01T14:14:52.533Z 2025-12-06T14:45:46.668Z
8649627 8649627 20251129175747_c6E72 HR0008 2025-12-01T14:13:23.080Z 2025-12-06T14:45:34.993Z
8649472 8649472 20251129173028_x9Z3J HR0008 2025-12-01T14:12:45.650Z 2025-12-06T14:45:28.498Z
8649457 8649457 20251129172959_tGjvD HR0008 2025-12-01T14:12:39.504Z 2025-12-06T14:45:24.825Z
8647753 8647753 20251129052012_DtA9E HR0008 2025-11-30T14:28:51.624Z 2025-12-06T14:56:46.490Z
8647507 8647507 20251129044601_T4mxS HR0008 2025-11-30T14:28:31.248Z 2025-12-06T14:56:40.196Z
8646977 8646977 20251129032202_KtMW6 HR0008 2025-11-30T14:27:12.958Z 2025-12-06T14:56:29.079Z
8646736 8646736 20251129024637_FWslF HR0008 2025-11-30T14:26:44.742Z 2025-12-06T14:56:24.272Z
8646464 8646464 20251129020848_v9V0P HR0008 2025-11-30T14:26:01.684Z 2025-12-06T14:56:08.842Z
8646321 8646321 20251129014557_OWZQy HR0008 2025-11-30T14:25:50.508Z 2025-12-06T14:55:57.728Z
8645420 8645420 20251128220525_9SWsq HR0008 2025-11-30T14:23:42.358Z 2025-12-06T14:54:57.383Z
8636242 8636242 20251128032950_SeY2c HR0008 2025-11-29T14:25:09.162Z 2025-12-06T15:03:01.334Z
8634791 8634791 20251128011822_GGfSv HR0008 2025-11-29T14:22:03.721Z 2025-12-06T15:02:35.998Z
8633493 8633493 20251127232406_EpVeW HR0008 2025-11-29T14:19:48.105Z 2025-12-06T15:01:44.708Z
8633490 8633490 20251127232405_TZGDc HR0008 2025-11-29T14:19:47.882Z 2025-12-06T15:01:44.660Z
8623198 8623198 20251126232014_Cr4FQ HR0008 2025-11-28T14:21:04.500Z 2025-12-05T15:03:38.035Z
8623081 8623081 20251126224741_Qj5sd HR0008 2025-11-28T14:20:50.636Z 2025-12-05T15:03:28.007Z
8622771 8622771 20251126211839_ze3v3 HR0008 2025-11-28T14:19:52.016Z 2025-12-05T15:03:06.255Z
8622595 8622595 20251126201342_shPnN HR0008 2025-11-28T14:19:27.363Z 2025-12-05T15:03:03.877Z
8579762 8579762 20251123010734_QSA4m HR0008 2025-11-24T14:15:06.168Z 2025-12-01T15:21:00.765Z
8524851 8524851 20251119042846_n3mYL HR0008 2025-11-20T14:21:40.565Z 2025-11-27T15:13:06.607Z
8523631 8523631 20251119022833_32Jjr HR0008 2025-11-20T14:18:54.123Z 2025-11-27T15:12:24.293Z
8523076 8523076 20251119012611_pUCjI HR0008 2025-11-20T14:17:29.598Z 2025-11-27T15:12:08.881Z
8522550 8522550 20251119002816_MXJ2a HR0008 2025-11-20T14:15:58.584Z 2025-11-27T15:12:04.165Z
8521418 8521418 20251118205947_pMalB HR0008 2025-11-20T14:12:29.655Z 2025-11-27T15:11:38.919Z
8520082 8520082 20251118184428_xnhWX HR0008 2025-11-20T14:08:55.115Z 2025-11-27T15:11:30.955Z
8520054 8520054 20251118184107_x7uep HR0008 2025-11-20T14:08:51.471Z 2025-11-27T15:11:30.797Z
8520048 8520048 20251118183941_VXXgJ HR0008 2025-11-20T14:08:50.601Z 2025-11-27T15:11:30.739Z
8519787 8519787 20251118181124_pa0m8 HR0008 2025-11-20T14:08:02.086Z 2025-11-27T15:11:29.017Z
8442533 8442533 20251111021750_XDNef HR0008 2025-11-13T14:46:20.977Z 2025-11-19T15:16:48.973Z
8442450 8442450 20251110233216_pi942 HR0008 2025-11-13T14:44:59.455Z 2025-11-19T15:16:02.377Z
8442355 8442355 20251110200501_8xLZ2 HR0008 2025-11-13T14:43:21.781Z 2025-11-19T15:14:23.014Z
8442324 8442324 20251110192051_YBCK4 HR0008 2025-11-13T14:42:47.259Z 2025-11-19T15:14:11.462Z
8439952 8439952 20251112045935_j7jTb HR0008 2025-11-13T14:27:41.130Z 2025-11-20T15:25:39.180Z
8438756 8438756 20251112023526_DmkMX HR0008 2025-11-13T14:24:35.841Z 2025-11-20T15:24:46.804Z
8438335 8438335 20251112014620_4JS1B HR0008 2025-11-13T14:23:35.281Z 2025-11-20T15:24:25.320Z
8437589 8437589 20251112002211_xo5yB HR0008 2025-11-13T14:21:24.800Z 2025-11-20T15:23:44.427Z
8437545 8437545 20251112001712_vTAwO HR0008 2025-11-13T14:21:17.644Z 2025-11-20T15:23:42.502Z
8437122 8437122 20251111232436_07huz HR0008 2025-11-13T14:20:15.330Z 2025-11-20T15:23:14.922Z
8437081 8437081 20251111231545_tBeNH HR0008 2025-11-13T14:20:02.552Z 2025-11-20T15:23:13.709Z
8436700 8436700 20251111222118_jwqYQ HR0008 2025-11-13T14:18:56.262Z 2025-11-20T15:22:59.887Z
8436499 8436499 20251111214924_k3KLE HR0008 2025-11-13T14:18:19.615Z 2025-11-20T15:22:52.874Z
8436182 8436182 20251111205913_PzzXK HR0008 2025-11-13T14:17:30.864Z 2025-11-20T15:22:43.256Z
8435901 8435901 20251111202838_mZisd HR0008 2025-11-13T14:16:45.207Z 2025-11-20T15:22:36.395Z
8435506 8435506 20251111194222_AyIfD HR0008 2025-11-13T14:15:39.522Z 2025-11-20T15:22:21.697Z
8434280 8434280 20251111180511_hizz5 HR0008 2025-11-13T14:12:28.484Z 2025-11-20T15:21:36.110Z
8434256 8434256 20251111180254_Ydf6L HR0008 2025-11-13T14:12:25.321Z 2025-11-20T15:21:31.484Z
8428709 8428709 20251110030850_QWDM2 HR0008 2025-11-12T14:35:40.558Z 2025-11-18T15:21:09.198Z
8428705 8428705 20251110022155_qkhMR HR0008 2025-11-12T14:35:25.048Z 2025-11-18T15:20:56.160Z
8428704 8428704 20251110002132_tJ17Z HR0008 2025-11-12T14:35:06.616Z 2025-11-18T15:20:23.587Z
8428702 8428702 20251109224727_YG121 HR0008 2025-11-12T14:34:34.325Z 2025-11-18T15:20:19.861Z
8428696 8428696 20251109184336_2Hk55 HR0008 2025-11-12T14:33:10.256Z 2025-11-18T15:19:36.233Z
8424635 8424635 20251111003654_3LyFq HR0008 2025-11-12T14:20:40.693Z 2025-11-19T15:16:19.939Z
8424560 8424560 20251111003033_XM7Tf HR0008 2025-11-12T14:20:33.867Z 2025-11-19T15:16:19.208Z
8423379 8423379 20251110230928_A0AW6 HR0008 2025-11-12T14:18:18.604Z 2025-11-19T15:15:52.436Z
8422539 8422539 20251110220911_V2A6A HR0008 2025-11-12T14:16:43.473Z 2025-11-19T15:15:28.551Z
8420340 8420340 20251110185309_jLNCC HR0008 2025-11-12T14:10:25.249Z 2025-11-19T15:13:52.115Z
8405849 8405849 20251109044237_gHnR2 HR0008 2025-11-10T14:15:17.915Z 2025-11-17T14:59:04.771Z
8402442 8402442 20251108195408_e2LF3 HR0008 2025-11-10T14:06:53.179Z 2025-11-17T14:58:17.853Z
8398412 8398412 20251108042154_LE3PP HR0008 2025-11-09T14:15:15.475Z 2025-11-16T15:04:46.554Z
8398349 8398349 20251108041130_rv5Sh HR0008 2025-11-09T14:15:04.854Z 2025-11-16T15:04:44.583Z
8398187 8398187 20251108034809_iKqwj HR0008 2025-11-09T14:14:30.651Z 2025-11-16T15:04:39.368Z
8397988 8397988 20251108031524_DQ3JC HR0008 2025-11-09T14:13:50.593Z 2025-11-16T15:04:32.682Z
8396770 8396770 20251107225753_uW5yF HR0008 2025-11-09T14:09:44.943Z 2025-11-16T15:03:39.974Z
8396629 8396629 20251107221602_sMvPq HR0008 2025-11-09T14:09:17.863Z 2025-11-16T15:03:35.665Z
8395471 8395471 20251107163935_MSOEi HR0008 2025-11-09T14:04:23.668Z 2025-11-16T15:02:26.982Z
8392104 8392104 20251107043808_Jhcqn HR0008 2025-11-08T14:17:07.366Z 2025-11-15T15:00:42.275Z
8392076 8392076 20251107043142_fE3Pv HR0008 2025-11-08T14:17:02.783Z 2025-11-15T15:00:41.998Z
8391942 8391942 20251107040650_DCZff HR0008 2025-11-08T14:16:32.910Z 2025-11-15T15:00:40.486Z
8390995 8390995 20251107015131_9h5Dg HR0008 2025-11-08T14:13:15.177Z 2025-11-15T15:00:16.540Z
8390463 8390463 20251107003511_rgntU HR0008 2025-11-08T14:10:59.365Z 2025-11-15T15:00:02.733Z
8389688 8389688 20251106220611_5wfcb HR0008 2025-11-08T14:08:07.134Z 2025-11-15T14:59:46.721Z
8389634 8389634 20251106215430_VJDzs HR0008 2025-11-08T14:07:47.118Z 2025-11-15T14:59:44.350Z
8389107 8389107 20251106192418_4efCY HR0008 2025-11-08T14:05:23.839Z 2025-11-15T14:59:31.351Z
8386341 8386341 20251106034631_SoYi3 HR0008 2025-11-07T14:10:46.339Z 2025-11-14T15:08:41.982Z
8386127 8386127 20251106024112_hSCTp HR0008 2025-11-07T14:09:42.754Z 2025-11-14T15:08:36.071Z
8385850 8385850 20251106014348_t4gS7 HR0008 2025-11-07T14:08:26.420Z 2025-11-14T15:08:25.941Z
8385773 8385773 20251106012413_7gDnz HR0008 2025-11-07T14:08:08.479Z 2025-11-14T15:08:22.364Z
8385692 8385692 20251106010918_ekziV HR0008 2025-11-07T14:07:48.766Z 2025-11-14T15:08:19.084Z
8385635 8385635 20251106005439_K0V6D HR0008 2025-11-07T14:07:40.078Z 2025-11-14T15:08:17.510Z
8385510 8385510 20251106001229_HKYIy HR0008 2025-11-07T14:07:06.534Z 2025-11-14T15:08:15.539Z
8385506 8385506 20251106001207_he29q HR0008 2025-11-07T14:07:05.582Z 2025-11-14T15:08:15.432Z
8385325 8385325 20251105230608_38QVt HR0008 2025-11-07T14:06:19.947Z 2025-11-14T15:08:07.787Z
8385040 8385040 20251105205841_rsE6U HR0008 2025-11-07T14:05:00.396Z 2025-11-14T15:07:53.365Z
8384777 8384777 20251105174351_Wgp33 HR0008 2025-11-07T14:03:35.344Z 2025-11-14T15:07:44.000Z
8383196 8383196 20251104012551_5d12R HR0008 2025-11-06T14:24:38.932Z 2025-11-12T15:10:30.471Z
8383184 8383184 20251104004625_039PB HR0008 2025-11-06T14:24:14.494Z 2025-11-12T15:10:18.963Z
8383174 8383174 20251104002538_mCtdk HR0008 2025-11-06T14:24:08.264Z 2025-11-12T15:10:15.659Z

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