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

153 rows where station_code = "ZA000F" 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
9267455 9267455 20260127013057_uFWEG ZA000F 2026-01-28T14:21:44.219Z 2026-01-29T14:35:01.978Z
9267446 9267446 20260127011153_Nd953 ZA000F 2026-01-28T14:21:41.977Z 2026-01-29T14:35:01.302Z
9267427 9267427 20260127005222_4umwq ZA000F 2026-01-28T14:21:39.153Z 2026-01-29T14:34:59.880Z
9267386 9267386 20260127001621_laQ8c ZA000F 2026-01-28T14:21:24.921Z 2026-01-29T14:34:56.369Z
9262640 9262640 20260125223248_Du3eo ZA000F 2026-01-27T14:14:32.846Z 2026-01-29T14:38:30.708Z
9262629 9262629 20260125215205_4uO7M ZA000F 2026-01-27T14:14:29.619Z 2026-01-29T14:38:29.766Z
9259954 9259954 20260125012749_VETK8 ZA000F 2026-01-26T14:19:32.676Z 2026-01-29T14:43:36.869Z
9248686 9248686 20260122014336_p7wS5 ZA000F 2026-01-23T14:13:25.601Z 2026-01-29T14:57:40.833Z
9248625 9248625 20260122012113_yd0BN ZA000F 2026-01-23T14:13:18.463Z 2026-01-29T14:57:37.450Z
9248609 9248609 20260122010857_izIqf ZA000F 2026-01-23T14:13:15.529Z 2026-01-29T14:57:36.530Z
9248518 9248518 20260122002655_XluCX ZA000F 2026-01-23T14:12:58.565Z 2026-01-29T14:57:24.610Z
9248352 9248352 20260121230537_TL3cQ ZA000F 2026-01-23T14:12:37.944Z 2026-01-29T14:57:15.138Z
9241835 9241835 20260120230329_6mV25 ZA000F 2026-01-22T14:14:52.573Z 2026-01-29T15:03:05.164Z
9235466 9235466 20260120011719_Xywag ZA000F 2026-01-21T14:18:59.279Z 2026-01-28T14:58:56.520Z
9235072 9235072 20260120002421_wutWi ZA000F 2026-01-21T14:17:22.800Z 2026-01-28T14:58:28.185Z
9228466 9228466 20260118223012_GKodJ ZA000F 2026-01-20T14:17:55.248Z 2026-01-27T15:02:02.825Z
9218225 9218225 20260117015625_yNv5A ZA000F 2026-01-18T14:11:07.192Z 2026-01-25T14:58:17.448Z
9218189 9218189 20260117013747_S56y8 ZA000F 2026-01-18T14:10:55.342Z 2026-01-25T14:58:03.624Z
9195006 9195006 20260112235817_4otRw ZA000F 2026-01-14T14:11:40.647Z 2026-01-21T15:04:35.060Z
9194876 9194876 20260112230934_iP7MW ZA000F 2026-01-14T14:11:06.283Z 2026-01-21T15:04:33.504Z
9188020 9188020 20260111200057_SjDe3 ZA000F 2026-01-13T14:10:04.133Z 2026-01-20T15:21:07.117Z
9188015 9188015 20260111195952_oRn7O ZA000F 2026-01-13T14:10:02.526Z 2026-01-20T15:21:06.787Z
9180133 9180133 20260110191843_2SDDO ZA000F 2026-01-12T14:05:55.437Z 2026-01-19T15:15:47.876Z
9167387 9167387 20260108011139_fGz5I ZA000F 2026-01-09T14:07:31.694Z 2026-01-16T15:11:15.656Z
9167332 9167332 20260108003036_XrdbN ZA000F 2026-01-09T14:07:14.797Z 2026-01-16T15:11:04.532Z
9167287 9167287 20260108000917_ptXJl ZA000F 2026-01-09T14:07:01.755Z 2026-01-16T15:11:00.520Z
9167095 9167095 20260107224128_RrpFz ZA000F 2026-01-09T14:06:14.939Z 2026-01-16T15:10:49.586Z
9158788 9158788 20260106003043_SJRQm ZA000F 2026-01-07T14:07:18.178Z 2026-01-13T15:07:46.475Z
9150449 9150449 20260105021357_4XkKy ZA000F 2026-01-06T14:10:05.162Z 2026-01-13T15:13:33.621Z
9111275 9111275 20251231005758_8Wdyk ZA000F 2026-01-01T14:10:50.897Z 2026-01-08T15:06:26.891Z
9111074 9111074 20251231003452_J4zn0 ZA000F 2026-01-01T14:10:03.635Z 2026-01-08T15:06:14.308Z
9101568 9101568 20251230005506_oc7zZ ZA000F 2025-12-31T14:09:23.790Z 2026-01-07T15:06:35.518Z
9101549 9101549 20251230005141_AxJAs ZA000F 2025-12-31T14:09:15.472Z 2026-01-07T15:06:34.223Z
9101129 9101129 20251229224625_QZ7A2 ZA000F 2025-12-31T14:06:43.067Z 2026-01-07T15:06:02.433Z
9083124 9083124 20251227230209_8qU7i ZA000F 2025-12-30T14:31:44.139Z 2026-01-05T15:07:37.821Z
9082954 9082954 20251227221610_nC3YQ ZA000F 2025-12-30T14:31:13.185Z 2026-01-05T15:07:32.490Z
9078544 9078544 20251229020900_0EfWb ZA000F 2025-12-30T14:13:29.936Z 2026-01-06T15:16:31.655Z
9077872 9077872 20251229011301_jLLQn ZA000F 2025-12-30T14:10:00.786Z 2026-01-06T15:15:56.315Z
9077491 9077491 20251229003655_cOg7A ZA000F 2025-12-30T14:08:17.608Z 2026-01-06T15:15:32.447Z
9076529 9076529 20251228222744_S2PRi ZA000F 2025-12-30T14:04:03.991Z 2025-12-31T14:31:37.457Z
9076276 9076276 20251228213815_Ryo85 ZA000F 2025-12-30T14:02:44.677Z 2026-01-06T15:14:22.224Z
9076210 9076210 20251228212817_vPBfV ZA000F 2025-12-30T14:02:21.819Z 2026-01-06T15:14:18.592Z
9049915 9049915 20251226212519_uCs8I ZA000F 2025-12-29T14:00:38.760Z 2026-01-04T15:23:09.070Z
9044276 9044276 20251223003417_uRq4X ZA000F 2025-12-28T14:49:22.029Z 2025-12-31T15:42:08.268Z
9025329 9025329 20251224235356_kcpjY ZA000F 2025-12-28T14:04:15.289Z 2026-01-02T15:42:16.113Z
9023714 9023714 20251220213456_9XLUo ZA000F 2025-12-27T15:09:25.622Z 2025-12-29T15:26:21.940Z
9005578 9005578 20251221021309_nQ6Gv ZA000F 2025-12-27T14:34:54.200Z 2025-12-27T14:34:54.200Z
9005520 9005520 20251221015634_gQEF0 ZA000F 2025-12-27T14:34:45.740Z 2025-12-27T14:34:45.740Z
9005186 9005186 20251221000919_hdhsV ZA000F 2025-12-27T14:33:21.845Z 2025-12-27T14:33:21.845Z
9005173 9005173 20251221000252_oDRV1 ZA000F 2025-12-27T14:33:20.625Z 2025-12-27T14:33:20.625Z
9005162 9005162 20251220235738_d4W3E ZA000F 2025-12-27T14:33:18.479Z 2025-12-27T14:33:18.479Z
8993967 8993967 20251219000405_8uIzh ZA000F 2025-12-26T14:53:56.500Z 2025-12-27T15:28:45.715Z
8993945 8993945 20251219000156_VmQYF ZA000F 2025-12-26T14:53:54.544Z 2025-12-27T15:28:43.126Z
8993892 8993892 20251218235352_yHF4i ZA000F 2025-12-26T14:53:50.604Z 2025-12-27T15:28:27.832Z
8985340 8985340 20251218015649_6kiL7 ZA000F 2025-12-26T14:34:29.682Z 2025-12-27T15:18:58.106Z
8984967 8984967 20251220001705_Ben6x ZA000F 2025-12-26T14:31:37.916Z 2025-12-28T15:23:57.365Z
8983282 8983282 20251219213536_8E4st ZA000F 2025-12-26T14:28:51.501Z 2025-12-28T15:23:37.160Z
8973947 8973947 20251220014939_yz1um ZA000F 2025-12-26T14:03:28.630Z 2025-12-29T15:22:37.859Z
8972017 8972017 20251217004849_vnvPs ZA000F 2025-12-25T14:54:40.857Z 2025-12-25T14:54:40.857Z
8951704 8951704 20251215015735_BfLje ZA000F 2025-12-24T15:09:12.255Z 2025-12-24T15:09:12.255Z
8951500 8951500 20251215014542_VpHBA ZA000F 2025-12-24T15:08:48.230Z 2025-12-24T15:08:48.230Z
8950946 8950946 20251215011619_Udnf7 ZA000F 2025-12-24T15:07:41.574Z 2025-12-24T15:07:41.574Z
8950364 8950364 20251215005030_ys3Jm ZA000F 2025-12-24T15:07:29.110Z 2025-12-24T15:07:29.110Z
8949792 8949792 20251215002500_2SsCy ZA000F 2025-12-24T15:06:17.358Z 2025-12-24T15:06:17.358Z
8949662 8949662 20251215002015_QtsGR ZA000F 2025-12-24T15:06:15.035Z 2025-12-24T15:06:15.035Z
8947851 8947851 20251214225450_Zd2W0 ZA000F 2025-12-24T15:04:26.160Z 2025-12-24T15:04:26.160Z
8947201 8947201 20251214222309_PbKYl ZA000F 2025-12-24T15:04:16.715Z 2025-12-24T15:04:16.715Z
8946871 8946871 20251214220518_BkWKb ZA000F 2025-12-24T15:04:11.229Z 2025-12-24T15:04:11.229Z
8944106 8944106 20251214201552_y1fBu ZA000F 2025-12-24T15:00:20.490Z 2025-12-24T15:00:20.490Z
8893291 8893291 20251214021442_j9CtV ZA000F 2025-12-22T14:11:55.459Z 2025-12-23T14:27:49.623Z
8890175 8890175 20251214015053_43k51 ZA000F 2025-12-22T14:11:40.569Z 2025-12-23T14:27:45.055Z
8889745 8889745 20251214014723_8LiN4 ZA000F 2025-12-22T14:11:39.022Z 2025-12-23T14:27:44.327Z
8889288 8889288 20251214014319_WrlFo ZA000F 2025-12-22T14:11:36.469Z 2025-12-23T14:27:43.439Z
8888115 8888115 20251214013343_znGTP ZA000F 2025-12-22T14:11:31.806Z 2025-12-23T14:27:41.287Z
8886748 8886748 20251214012234_2B3ZW ZA000F 2025-12-22T14:11:20.931Z 2025-12-23T14:27:39.329Z
8874234 8874234 20251214011118_q7vWV ZA000F 2025-12-21T14:11:09.497Z 2025-12-23T14:27:37.092Z
8873976 8873976 20251214010918_UDqD3 ZA000F 2025-12-21T14:11:06.631Z 2025-12-23T14:27:36.781Z
8872667 8872667 20251214010026_AXX2R ZA000F 2025-12-21T14:10:54.543Z 2025-12-23T14:27:35.351Z
8872439 8872439 20251214005903_sze9K ZA000F 2025-12-21T14:10:52.961Z 2025-12-23T14:27:35.178Z
8868853 8868853 20251214003440_WdjNA ZA000F 2025-12-21T14:10:14.551Z 2025-12-21T14:17:15.397Z
8868248 8868248 20251214003031_jrdBg ZA000F 2025-12-21T14:10:09.022Z 2025-12-23T14:27:29.687Z
8867908 8867908 20251214002814_58lbg ZA000F 2025-12-21T14:10:07.682Z 2025-12-23T14:27:29.213Z
8853730 8853730 20251214002408_379iI ZA000F 2025-12-19T14:22:49.167Z 2025-12-23T14:27:27.070Z
8853664 8853664 20251214002326_nYii3 ZA000F 2025-12-19T14:22:46.111Z 2025-12-23T14:27:26.059Z
8853599 8853599 20251214002239_4Kh7m ZA000F 2025-12-19T14:22:44.462Z 2025-12-23T14:27:25.479Z
8853371 8853371 20251214002024_P7MDt ZA000F 2025-12-19T14:22:39.029Z 2025-12-23T14:27:21.752Z
8852256 8852256 20251214000959_iW9Ds ZA000F 2025-12-19T14:21:45.767Z 2025-12-23T14:27:02.895Z
8852191 8852191 20251214000859_m3MFy ZA000F 2025-12-19T14:21:43.930Z 2025-12-23T14:27:01.486Z
8851899 8851899 20251214000619_Nv2IU ZA000F 2025-12-19T14:21:37.934Z 2025-12-23T14:26:57.607Z
8851181 8851181 20251213235933_VHcF6 ZA000F 2025-12-19T14:20:58.196Z 2025-12-23T14:26:42.897Z
8850472 8850472 20251213235224_8Fv3m ZA000F 2025-12-19T14:20:36.546Z 2025-12-23T14:26:33.533Z
8850450 8850450 20251213235159_6imbJ ZA000F 2025-12-19T14:20:35.416Z 2025-12-23T14:26:33.421Z
8850289 8850289 20251213235052_8uYEP ZA000F 2025-12-19T14:20:10.723Z 2025-12-23T14:26:32.281Z
8849000 8849000 20251213234015_fvKyR ZA000F 2025-12-19T14:18:51.974Z 2025-12-23T14:26:13.441Z
8848164 8848164 20251213233154_bFQBs ZA000F 2025-12-19T14:18:09.733Z 2025-12-23T14:25:56.264Z
8845997 8845997 20251213230915_ai73u ZA000F 2025-12-19T14:15:48.747Z 2025-12-23T14:25:31.106Z
8845475 8845475 20251213230333_pviB8 ZA000F 2025-12-19T14:15:38.394Z 2025-12-23T14:25:27.622Z
8845396 8845396 20251213230246_dAIMM ZA000F 2025-12-19T14:15:36.004Z 2025-12-23T14:25:26.567Z
8844458 8844458 20251213225007_lcRh6 ZA000F 2025-12-19T14:14:32.238Z 2025-12-23T14:25:22.621Z
8842842 8842842 20251213224243_3b0Cu ZA000F 2025-12-18T14:44:09.837Z 2025-12-23T14:25:21.532Z

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