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

174 rows where station_code = "US0040" 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
8604703 8604703 20251126091000_LXhEW US0040 2025-11-27T14:00:17.571Z 2025-12-05T15:00:49.146Z
8574462 8574462 20251122065536_KILQ4 US0040 2025-11-23T14:43:36.346Z 2025-11-30T15:07:09.562Z
8517188 8517188 20251118101405_VKxzM US0040 2025-11-19T14:42:56.257Z 2025-11-26T15:08:23.678Z
8517159 8517159 20251118101000_ouUkM US0040 2025-11-19T14:42:53.566Z 2025-11-19T14:42:53.566Z
8516525 8516525 20251118072633_7yiDd US0040 2025-11-19T14:41:41.020Z 2025-11-26T15:08:08.098Z
8516260 8516260 20251118060934_xuid2 US0040 2025-11-19T14:40:41.991Z 2025-11-26T15:08:06.667Z
8483956 8483956 20251115091212_5THQW US0040 2025-11-17T14:32:06.958Z 2025-11-23T15:19:21.384Z
8451541 8451541 20251113083211_2fMHB US0040 2025-11-14T14:25:58.938Z 2025-11-21T15:13:17.416Z
8441103 8441103 20251112085635_u7pCG US0040 2025-11-13T14:30:07.689Z 2025-11-20T15:26:04.133Z
8439926 8439926 20251112045651_UFlYK US0040 2025-11-13T14:27:38.067Z 2025-11-20T15:25:38.627Z
8387583 8387583 20251106104216_bmluS US0040 2025-11-07T14:15:15.573Z 2025-11-14T15:08:53.436Z
8381649 8381649 20251105064835_xGa3U US0040 2025-11-06T14:15:44.623Z 2025-11-13T15:15:34.806Z
8372611 8372611 20251104094130_ziveQ US0040 2025-11-05T14:18:51.380Z 2025-11-12T15:11:41.101Z
8372296 8372296 20251104081437_0OJfK US0040 2025-11-05T14:17:40.877Z 2025-11-12T15:11:18.881Z
8372141 8372141 20251104073003_oHoUl US0040 2025-11-05T14:17:20.819Z 2025-11-12T15:11:14.367Z
8346054 8346054 20251101075035_IERgB US0040 2025-11-02T14:43:43.882Z 2025-11-09T15:04:56.623Z
8345581 8345581 20251101065734_L0xnB US0040 2025-11-02T14:43:15.066Z 2025-11-09T15:04:17.670Z
8338265 8338265 20251031082753_kclk1 US0040 2025-11-02T14:32:04.436Z 2025-11-08T15:16:38.159Z
8242432 8242432 20251025041938_wijxH US0040 2025-10-27T12:34:58.392Z 2025-11-02T15:05:37.843Z
8226958 8226958 20251024100801_VB37c US0040 2025-10-26T12:45:18.304Z 2025-11-01T13:11:28.093Z
8225194 8225194 20251024074709_y8ad4 US0040 2025-10-26T12:43:06.589Z 2025-11-01T13:11:21.277Z
8223398 8223398 20251024052008_5O0G3 US0040 2025-10-26T12:40:56.887Z 2025-11-01T13:11:16.614Z
8167835 8167835 20251020030047_8NkAG US0040 2025-10-22T12:34:21.087Z 2025-10-28T13:08:41.308Z
8124599 8124599 20251017062656_dsEJJ US0040 2025-10-18T12:29:37.934Z 2025-10-25T13:29:22.752Z
8114024 8114024 20251016065221_ZcrpM US0040 2025-10-17T12:15:40.066Z 2025-10-24T13:16:54.727Z
8100474 8100474 20251014101525_ZuN1G US0040 2025-10-15T12:21:48.910Z 2025-10-22T13:10:30.683Z
8093261 8093261 20251013033103_7eWWe US0040 2025-10-14T12:12:51.731Z 2025-10-21T13:09:46.435Z
8088604 8088604 20251012081353_cJS2E US0040 2025-10-13T12:14:05.974Z 2025-10-20T13:04:04.096Z
8071459 8071459 20251008103413_HNAf3 US0040 2025-10-09T12:00:29.971Z 2025-10-17T12:36:45.118Z
8052628 8052628 20251003083646_afFyJ US0040 2025-10-05T12:01:43.088Z 2025-10-12T12:29:46.754Z
8052331 8052331 20251003075153_KoeYh US0040 2025-10-05T12:00:29.161Z 2025-10-12T12:29:40.404Z
8042468 8042468 20251002031336_iU5d2 US0040 2025-10-03T12:38:29.481Z 2025-10-03T12:38:29.481Z
8031601 8031601 20251001041535_wbinN US0040 2025-10-02T12:47:50.334Z 2025-10-09T12:39:42.049Z
7997892 7997892 20250929062644_T51Q8 US0040 2025-09-30T12:00:58.253Z 2025-10-08T12:40:52.861Z
7990548 7990548 20250928094746_2CJkc US0040 2025-09-29T12:02:30.716Z 2025-10-07T12:59:26.840Z
7990437 7990437 20250928084456_Q9sVm US0040 2025-09-29T12:01:49.690Z 2025-10-07T12:59:24.767Z
7938463 7938463 20250924082807_okth2 US0040 2025-09-25T12:04:03.424Z 2025-10-03T13:02:57.648Z
7860316 7860316 20250916092020_0FvzO US0040 2025-09-18T12:27:10.712Z 2025-09-24T13:16:38.633Z
7859481 7859481 20250917093224_Hr5PI US0040 2025-09-18T12:14:59.709Z 2025-09-25T13:11:37.006Z
7858815 7858815 20250917072244_2Te60 US0040 2025-09-18T12:12:26.286Z 2025-09-25T13:11:13.901Z
7848396 7848396 20250916070810_kPgqf US0040 2025-09-17T12:16:29.780Z 2025-09-24T13:16:16.862Z
7847615 7847615 20250916045141_QADi1 US0040 2025-09-17T12:13:49.090Z 2025-09-24T13:16:04.784Z
7837052 7837052 20250914084151_K2siI US0040 2025-09-16T12:25:29.965Z 2025-09-22T13:07:48.553Z
7717589 7717589 20250831072859_ZL9l6 US0040 2025-09-01T12:25:12.287Z 2025-09-08T12:53:39.522Z
7686129 7686129 20250828061419_Grh8w US0040 2025-08-29T12:27:01.028Z 2025-09-05T13:06:13.457Z
7521746 7521746 20250815083338_LYP3D US0040 2025-08-17T12:21:55.419Z 2025-08-23T12:49:04.312Z
7492161 7492161 20250813093750_6Cl9i US0040 2025-08-15T12:59:54.458Z 2025-08-21T12:48:07.805Z
7401275 7401275 20250807075828_wCmj1 US0040 2025-08-08T12:29:25.733Z 2025-08-15T13:39:43.355Z
7400776 7400776 20250807054041_d8rYP US0040 2025-08-08T12:28:25.468Z 2025-08-15T13:39:05.260Z
7381626 7381626 20250805075346_zyhzQ US0040 2025-08-07T12:17:53.064Z 2025-08-13T12:59:52.988Z
7264669 7264669 20250729045157_X1fK3 US0040 2025-07-31T12:12:48.392Z 2025-08-06T12:35:27.259Z
7253301 7253301 20250729072356_1ZD33 US0040 2025-07-31T12:01:26.850Z 2025-08-07T12:48:05.491Z
7235140 7235140 20250728060843_UMtF3 US0040 2025-07-30T12:00:27.528Z 2025-08-06T12:34:25.032Z
7119003 7119003 20250720065518_j5kT5 US0040 2025-07-21T12:00:35.555Z 2025-07-28T12:48:29.356Z
7104990 7104990 20250719071613_E1lZ5 US0040 2025-07-20T12:08:17.059Z 2025-07-27T12:46:25.396Z
7090471 7090471 20250715083208_acqcO US0040 2025-07-16T12:16:24.738Z 2025-07-23T12:05:04.677Z
6842236 6842236 20250601022255_jleB2 US0040 2025-06-02T12:14:20.864Z 2025-06-09T12:45:54.349Z
6722977 6722977 20250514090552_48CU0 US0040 2025-05-15T12:14:13.860Z 2025-05-22T12:36:34.857Z
6722858 6722858 20250514074218_WAFBF US0040 2025-05-15T12:13:57.540Z 2025-05-22T12:36:31.118Z
6660550 6660550 20250505084625_7izU3 US0040 2025-05-06T12:20:30.605Z 2025-05-13T12:39:02.586Z
6586632 6586632 20250427062705_OMGcA US0040 2025-04-28T12:24:14.510Z 2025-05-05T12:31:34.616Z
6553336 6553336 20250423055817_SpnMD US0040 2025-04-24T12:22:21.950Z 2025-05-01T12:38:49.736Z
6536768 6536768 20250422055750_Fd82I US0040 2025-04-23T12:00:32.586Z 2025-05-01T12:37:58.285Z
6361597 6361597 20250321084811_SILhx US0040 2025-03-22T12:16:53.282Z 2025-03-29T13:17:12.330Z
6330716 6330716 20250317095040_FQacG US0040 2025-03-18T12:08:33.021Z 2025-03-25T12:54:54.258Z
6282122 6282122 20250307105029_04t3Y US0040 2025-03-08T14:20:52.146Z 2025-03-15T12:36:23.830Z
6281479 6281479 20250307082810_SSXWS US0040 2025-03-08T14:19:28.544Z 2025-03-15T12:36:09.972Z
6233754 6233754 20250303105431_frUYN US0040 2025-03-05T14:14:26.757Z 2025-03-11T13:35:19.820Z
6220671 6220671 20250227040751_zaZLk US0040 2025-03-03T14:54:17.824Z 2025-03-07T16:56:08.354Z
5922945 5922945 20250104093145_0CeYh US0040 2025-01-06T14:23:55.985Z 2025-01-12T14:31:28.811Z
5922752 5922752 20250104083507_5fo39 US0040 2025-01-06T14:23:31.092Z 2025-01-12T14:31:19.961Z
5911459 5911459 20250104112655_xR24o US0040 2025-01-06T14:00:33.258Z 2025-01-13T14:25:03.068Z
5911455 5911455 20250104112546_2Gliv US0040 2025-01-06T14:00:32.231Z 2025-01-13T14:25:02.633Z
5907646 5907646 20250103103951_tzvIu US0040 2025-01-05T14:26:19.394Z 2025-01-11T14:45:17.674Z
5905471 5905471 20250103065510_PhnQ5 US0040 2025-01-05T14:23:20.265Z 2025-01-11T14:44:22.483Z
5800394 5800394 20241214110221_309vs US0040 2024-12-16T14:14:42.928Z 2024-12-22T14:29:54.657Z
5778020 5778020 20241213092315_bhQNy US0040 2024-12-14T14:11:19.721Z 2024-12-21T14:40:21.211Z
5774804 5774804 20241213044316_LBCr0 US0040 2024-12-14T14:07:44.317Z 2024-12-21T14:38:50.184Z
5768513 5768513 20241212105918_25xIe US0040 2024-12-13T14:09:25.945Z 2024-12-20T14:38:22.438Z
5767715 5767715 20241212074412_dPPpj US0040 2024-12-13T14:07:11.913Z 2024-12-20T14:38:05.312Z
5732568 5732568 20241208081927_M6d2M US0040 2024-12-09T14:08:30.409Z 2024-12-16T14:39:56.988Z
5718611 5718611 20241207071518_10Ook US0040 2024-12-08T14:08:32.246Z 2024-12-15T14:38:09.458Z
5718474 5718474 20241207063659_5S9U3 US0040 2024-12-08T14:08:05.739Z 2024-12-15T14:38:08.330Z
5671839 5671839 20241203100524_BI368 US0040 2024-12-04T14:13:34.055Z 2024-12-12T14:38:05.799Z
5664062 5664062 20241202103847_qHXxA US0040 2024-12-03T14:15:27.821Z 2024-12-11T14:31:15.955Z
5661999 5661999 20241202061027_TbEKj US0040 2024-12-03T14:11:15.325Z 2024-12-11T14:31:11.456Z
5649119 5649119 20241201064815_IGzZa US0040 2024-12-02T14:09:05.848Z 2024-12-10T14:31:57.995Z
5648717 5648717 20241201051936_ykVbX US0040 2024-12-02T14:07:48.718Z 2024-12-10T14:31:54.921Z
5624185 5624185 20241128091340_vMPsJ US0040 2024-11-29T14:08:25.464Z 2024-12-07T14:40:32.734Z
5601037 5601037 20241125065239_k9pYf US0040 2024-11-26T14:04:13.105Z 2024-12-04T14:29:49.885Z
5594115 5594115 20241124094109_MsIjQ US0040 2024-11-25T14:04:43.301Z 2024-12-03T14:27:36.191Z
5593142 5593142 20241124052330_YBgPx US0040 2024-11-25T14:01:31.515Z 2024-12-03T14:27:33.622Z
5544418 5544418 20241116105612_q2w6v US0040 2024-11-17T14:01:04.848Z 2024-11-25T14:22:38.978Z
5544339 5544339 20241116100802_3aP5u US0040 2024-11-17T14:00:53.783Z 2024-11-25T14:22:38.512Z
5433862 5433862 20241030072302_0GjeN US0040 2024-11-01T12:00:22.038Z 2024-11-08T14:22:43.467Z
5433080 5433080 20241029062038_K8gGh US0040 2024-10-31T12:21:45.170Z 2024-11-06T14:27:29.928Z
5423158 5423158 20241029073710_z4EVo US0040 2024-10-31T12:00:25.704Z 2024-11-07T14:26:24.158Z
5421516 5421516 20241028105202_qFe2i US0040 2024-10-30T12:20:03.642Z 2024-11-06T14:27:07.579Z
5421441 5421441 20241028063824_7SOKE US0040 2024-10-30T12:19:56.299Z 2024-11-05T14:27:18.687Z
5367333 5367333 20241023062610_MXkNk US0040 2024-10-25T12:21:50.874Z 2024-10-31T12:30:12.400Z

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