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,024 rows where station_code = "US005J" 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
9612175 9612175 20260406074647_GFcr7 US005J 2026-04-07T12:01:00.506Z 2026-04-07T12:01:00.506Z
9612145 9612145 20260406073238_moLBO US005J 2026-04-07T12:00:56.370Z 2026-04-07T12:00:56.370Z
9612048 9612048 20260406054215_bCnJn US005J 2026-04-07T12:00:33.697Z 2026-04-07T12:00:33.697Z
9611782 9611782 20260405032411_zzzlc US005J 2026-04-06T12:15:59.803Z 2026-04-07T12:16:30.221Z
9609996 9609996 20260405114123_LpaAX US005J 2026-04-06T12:05:11.986Z 2026-04-07T12:13:19.164Z
9609831 9609831 20260405102504_5ItCO US005J 2026-04-06T12:04:10.969Z 2026-04-07T12:13:19.095Z
9609817 9609817 20260405101746_7uGRC US005J 2026-04-06T12:04:01.617Z 2026-04-07T12:13:19.088Z
9609489 9609489 20260405073139_ufpZf US005J 2026-04-06T12:02:02.804Z 2026-04-07T12:13:18.964Z
9609462 9609462 20260405065215_FGZOI US005J 2026-04-06T12:01:50.709Z 2026-04-07T12:13:18.951Z
9609444 9609444 20260405063209_IZVlQ US005J 2026-04-06T12:01:47.022Z 2026-04-07T12:13:18.943Z
9609318 9609318 20260405042549_SDKZ7 US005J 2026-04-06T12:01:11.754Z 2026-04-07T12:13:18.900Z
9609305 9609305 20260405041702_vbdEZ US005J 2026-04-06T12:01:03.386Z 2026-04-07T12:13:18.895Z
9607619 9607619 20260404111653_S6t2J US005J 2026-04-05T12:03:13.652Z 2026-04-07T12:14:45.038Z
9607468 9607468 20260404094412_YcQQg US005J 2026-04-05T12:02:25.985Z 2026-04-07T12:14:37.959Z
9607382 9607382 20260404082813_OO3l2 US005J 2026-04-05T12:01:55.515Z 2026-04-07T12:14:33.775Z
9605707 9605707 20260403113257_An0mN US005J 2026-04-04T12:03:31.643Z 2026-04-07T12:17:07.827Z
9605613 9605613 20260403110801_Vz6LZ US005J 2026-04-04T12:03:04.590Z 2026-04-07T12:17:04.524Z
9605537 9605537 20260403103443_mHNoh US005J 2026-04-04T12:02:49.209Z 2026-04-07T12:17:01.702Z
9605021 9605021 20260403034038_PL4iM US005J 2026-04-04T12:00:20.203Z 2026-04-07T12:16:34.775Z
9603596 9603596 20260402111305_IkkAv US005J 2026-04-03T12:03:44.988Z 2026-04-07T12:19:20.843Z
9593550 9593550 20260329114836_XobxX US005J 2026-03-30T12:04:21.271Z 2026-04-07T12:27:14.065Z
9593537 9593537 20260329114448_n4ytM US005J 2026-03-30T12:04:18.889Z 2026-04-07T12:27:13.699Z
9593504 9593504 20260329112821_PuQxx US005J 2026-03-30T12:04:12.117Z 2026-04-07T12:27:12.546Z
9593459 9593459 20260329105550_K2acE US005J 2026-03-30T12:04:01.188Z 2026-04-07T12:27:10.675Z
9590855 9590855 20260328113455_R0tt1 US005J 2026-03-29T12:03:23.899Z 2026-04-06T12:38:37.470Z
9590849 9590849 20260328113254_55P0k US005J 2026-03-29T12:03:23.283Z 2026-04-06T12:38:37.225Z
9590623 9590623 20260328102722_4VOOj US005J 2026-03-29T12:03:01.712Z 2026-04-06T12:38:27.771Z
9590592 9590592 20260328101629_5ooX6 US005J 2026-03-29T12:02:58.310Z 2026-04-06T12:38:26.089Z
9590496 9590496 20260328093825_sOPJT US005J 2026-03-29T12:02:47.670Z 2026-04-06T12:38:12.540Z
9590439 9590439 20260328091321_bN9zO US005J 2026-03-29T12:02:39.255Z 2026-04-06T12:38:09.727Z
9590287 9590287 20260328080236_oP2ti US005J 2026-03-29T12:02:22.244Z 2026-04-06T12:37:59.777Z
9590253 9590253 20260328075216_Wg0aH US005J 2026-03-29T12:02:19.838Z 2026-04-06T12:37:58.556Z
9590231 9590231 20260328073920_UgVu3 US005J 2026-03-29T12:02:16.134Z 2026-04-06T12:37:57.476Z
9590212 9590212 20260328073247_EDJ4Z US005J 2026-03-29T12:02:13.851Z 2026-04-06T12:37:56.542Z
9589559 9589559 20260328034616_nUzxs US005J 2026-03-29T12:01:25.624Z 2026-04-06T12:37:27.565Z
9582975 9582975 20260326103103_F1AlF US005J 2026-03-27T12:07:22.265Z 2026-04-04T12:40:38.627Z
9582521 9582521 20260326081420_LkM4X US005J 2026-03-27T12:06:01.819Z 2026-04-04T12:40:06.218Z
9582455 9582455 20260326074146_aple1 US005J 2026-03-27T12:05:50.650Z 2026-04-04T12:40:01.897Z
9582308 9582308 20260326064107_VJa5n US005J 2026-03-27T12:05:20.366Z 2026-04-04T12:39:49.620Z
9582299 9582299 20260326062755_0oFMN US005J 2026-03-27T12:05:18.486Z 2026-04-04T12:39:49.201Z
9582265 9582265 20260326055507_7yawr US005J 2026-03-27T12:05:09.683Z 2026-04-04T12:39:47.424Z
9582249 9582249 20260326054541_22col US005J 2026-03-27T12:05:06.287Z 2026-04-04T12:39:45.258Z
9582237 9582237 20260326053400_OCM9N US005J 2026-03-27T12:05:03.606Z 2026-04-04T12:39:44.066Z
9582127 9582127 20260326044038_wVkZC US005J 2026-03-27T12:04:42.164Z 2026-04-04T12:39:38.446Z
9582071 9582071 20260326043023_333Bg US005J 2026-03-27T12:04:31.491Z 2026-04-04T12:39:36.683Z
9582052 9582052 20260326042439_YnhXh US005J 2026-03-27T12:04:29.631Z 2026-04-04T12:39:36.283Z
9578508 9578508 20260325120742_k6E3J US005J 2026-03-26T12:07:46.967Z 2026-04-03T12:38:06.256Z
9578333 9578333 20260325112402_aE6hD US005J 2026-03-26T12:07:21.047Z 2026-04-03T12:37:59.075Z
9578311 9578311 20260325111744_sGfy4 US005J 2026-03-26T12:07:17.439Z 2026-04-03T12:37:57.968Z
9578277 9578277 20260325110636_TIYj2 US005J 2026-03-26T12:07:11.908Z 2026-04-03T12:37:52.203Z
9578271 9578271 20260325110421_FCdIh US005J 2026-03-26T12:07:10.844Z 2026-04-03T12:37:45.992Z
9578170 9578170 20260325103756_eh7By US005J 2026-03-26T12:06:53.491Z 2026-04-03T12:37:41.895Z
9578134 9578134 20260325101900_GWhxX US005J 2026-03-26T12:06:48.757Z 2026-04-03T12:37:38.593Z
9578115 9578115 20260325100337_FrW1c US005J 2026-03-26T12:06:46.570Z 2026-04-03T12:37:37.878Z
9577726 9577726 20260325081725_xv1Qv US005J 2026-03-26T12:05:55.954Z 2026-04-03T12:37:24.676Z
9577703 9577703 20260325081019_WMI3u US005J 2026-03-26T12:05:54.094Z 2026-04-03T12:37:23.330Z
9577647 9577647 20260325075809_d44rI US005J 2026-03-26T12:05:45.265Z 2026-04-03T12:37:12.076Z
9577587 9577587 20260325073504_akdCp US005J 2026-03-26T12:05:34.913Z 2026-04-03T12:37:09.376Z
9577566 9577566 20260325072548_Zv3dn US005J 2026-03-26T12:05:32.152Z 2026-04-03T12:37:06.949Z
9577563 9577563 20260325072504_4CQv3 US005J 2026-03-26T12:05:31.651Z 2026-04-03T12:37:06.769Z
9577523 9577523 20260325070449_2Nj1N US005J 2026-03-26T12:05:24.962Z 2026-04-03T12:37:05.110Z
9577434 9577434 20260325061149_EyoEL US005J 2026-03-26T12:05:08.469Z 2026-04-03T12:37:01.623Z
9573122 9573122 20260324112310_ZmnUL US005J 2026-03-25T12:07:14.003Z 2026-04-02T12:35:56.813Z
9572903 9572903 20260324104809_7cf4T US005J 2026-03-25T12:06:40.726Z 2026-04-02T12:35:43.124Z
9572818 9572818 20260324102924_3L956 US005J 2026-03-25T12:06:23.178Z 2026-04-02T12:35:39.251Z
9572812 9572812 20260324102819_6pzg3 US005J 2026-03-25T12:06:22.147Z 2026-04-02T12:35:38.999Z
9572794 9572794 20260324102226_WSsJR US005J 2026-03-25T12:06:19.644Z 2026-04-02T12:35:38.363Z
9572589 9572589 20260324093526_JD4WH US005J 2026-03-25T12:05:39.598Z 2026-04-02T12:35:30.965Z
9572582 9572582 20260324093411_xEVZ5 US005J 2026-03-25T12:05:38.357Z 2026-04-02T12:35:30.646Z
9572524 9572524 20260324092212_hKLGp US005J 2026-03-25T12:05:27.561Z 2026-04-02T12:35:28.587Z
9572487 9572487 20260324091307_TTEes US005J 2026-03-25T12:05:19.253Z 2026-04-02T12:35:26.709Z
9572468 9572468 20260324091104_bgRUz US005J 2026-03-25T12:05:16.752Z 2026-04-02T12:35:26.096Z
9572466 9572466 20260324090721_aYp5S US005J 2026-03-25T12:05:16.267Z 2026-04-02T12:35:25.952Z
9572272 9572272 20260324082446_rfsrR US005J 2026-03-25T12:04:30.723Z 2026-04-02T12:35:11.855Z
9572194 9572194 20260324080245_iSOXR US005J 2026-03-25T12:04:12.120Z 2026-04-02T12:35:07.256Z
9572079 9572079 20260324072342_CBtGv US005J 2026-03-25T12:03:41.836Z 2026-04-02T12:35:02.109Z
9572029 9572029 20260324071059_83rnS US005J 2026-03-25T12:03:33.708Z 2026-04-02T12:35:00.206Z
9572023 9572023 20260324070339_VNNyn US005J 2026-03-25T12:03:32.290Z 2026-04-02T12:34:59.815Z
9572014 9572014 20260324070202_opgmj US005J 2026-03-25T12:03:30.180Z 2026-04-02T12:34:59.269Z
9564239 9564239 20260323101612_KZycS US005J 2026-03-24T12:07:41.923Z 2026-03-31T12:27:05.728Z
9563150 9563150 20260323072102_pjqM2 US005J 2026-03-24T12:05:15.524Z 2026-03-31T12:26:36.463Z
9563128 9563128 20260323070553_HZwIn US005J 2026-03-24T12:05:10.772Z 2026-03-31T12:26:35.734Z
9556755 9556755 20260322113317_wVjAi US005J 2026-03-23T12:05:11.244Z 2026-03-30T12:29:10.200Z
9556738 9556738 20260322112803_ZZQUJ US005J 2026-03-23T12:05:10.064Z 2026-03-30T12:29:09.476Z
9556562 9556562 20260322110735_W7FDN US005J 2026-03-23T12:04:56.969Z 2026-03-30T12:29:04.871Z
9556285 9556285 20260322095804_ZLDxj US005J 2026-03-23T12:04:37.357Z 2026-03-30T12:28:56.687Z
9556135 9556135 20260322092210_h64Ab US005J 2026-03-23T12:04:23.565Z 2026-03-30T12:28:45.729Z
9556093 9556093 20260322091556_z6PM8 US005J 2026-03-23T12:04:20.751Z 2026-03-30T12:28:44.660Z
9556084 9556084 20260322091501_ZI4P8 US005J 2026-03-23T12:04:20.095Z 2026-03-30T12:28:44.272Z
9556077 9556077 20260322091340_WPGrP US005J 2026-03-23T12:04:19.632Z 2026-03-30T12:28:44.042Z
9555748 9555748 20260322074653_CtLmf US005J 2026-03-23T12:03:51.503Z 2026-03-30T12:28:33.897Z
9555471 9555471 20260322050054_6d4jb US005J 2026-03-23T12:03:27.773Z 2026-03-30T12:28:26.891Z
9555416 9555416 20260322045132_KvXe4 US005J 2026-03-23T12:03:24.729Z 2026-03-30T12:28:26.179Z
9546274 9546274 20260321114916_8bQEq US005J 2026-03-22T12:11:25.073Z 2026-03-29T12:19:49.038Z
9546248 9546248 20260321114657_B2J5l US005J 2026-03-22T12:11:23.748Z 2026-03-29T12:19:48.831Z
9545875 9545875 20260321111542_GIZOO US005J 2026-03-22T12:10:28.670Z 2026-03-29T12:19:45.254Z
9545743 9545743 20260321110343_8239m US005J 2026-03-22T12:10:08.212Z 2026-03-29T12:19:42.918Z
9545674 9545674 20260321105735_eZGcg US005J 2026-03-22T12:09:58.529Z 2026-03-29T12:19:42.335Z
9545596 9545596 20260321105038_LxcER US005J 2026-03-22T12:09:49.080Z 2026-03-29T12:19:41.661Z
9545588 9545588 20260321104856_H1dZ2 US005J 2026-03-22T12:09:47.896Z 2026-03-29T12:19:41.499Z

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