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,244 rows where station_code = "US0037" 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
9268456 9268456 20260128102304_5hA82 US0037 2026-01-29T14:03:12.660Z 2026-01-29T14:03:12.660Z
9263524 9263524 20260127085806_eLhxB US0037 2026-01-28T14:01:09.495Z 2026-01-29T14:30:16.551Z
9263424 9263424 20260127074935_C201r US0037 2026-01-28T14:00:29.214Z 2026-01-29T14:30:16.494Z
9256360 9256360 20260124074650_IA1ap US0037 2026-01-25T14:16:47.624Z 2026-01-29T14:48:44.974Z
9256353 9256353 20260124073821_PBPwU US0037 2026-01-25T14:16:45.934Z 2026-01-29T14:48:44.467Z
9256326 9256326 20260124072430_r338d US0037 2026-01-25T14:16:41.385Z 2026-01-29T14:48:41.629Z
9256217 9256217 20260124062250_kqDpi US0037 2026-01-25T14:16:15.024Z 2026-01-29T14:48:29.627Z
9256124 9256124 20260124060109_sjTGY US0037 2026-01-25T14:15:58.333Z 2026-01-29T14:48:24.474Z
9255671 9255671 20260124042919_7byS4 US0037 2026-01-25T14:14:15.117Z 2026-01-29T14:47:50.380Z
9253162 9253162 20260124094810_mr8ff US0037 2026-01-25T14:01:03.725Z 2026-01-29T14:40:22.306Z
9253113 9253113 20260124092605_3ip36 US0037 2026-01-25T14:00:45.524Z 2026-01-29T14:40:18.090Z
9253103 9253103 20260124092100_FQTkQ US0037 2026-01-25T14:00:43.056Z 2026-01-29T14:40:15.595Z
9253069 9253069 20260124090308_ieZwJ US0037 2026-01-25T14:00:29.533Z 2026-01-29T14:40:13.559Z
9252976 9252976 20260123084449_tiZ0z US0037 2026-01-24T14:18:04.640Z 2026-01-29T14:53:45.717Z
9252925 9252925 20260123081521_EUs7g US0037 2026-01-24T14:17:48.955Z 2026-01-29T14:53:42.596Z
9252914 9252914 20260123080130_2603U US0037 2026-01-24T14:17:45.444Z 2026-01-29T14:53:41.823Z
9252800 9252800 20260123063319_aq0HI US0037 2026-01-24T14:17:13.660Z 2026-01-29T14:53:32.796Z
9252736 9252736 20260123055924_nayVB US0037 2026-01-24T14:16:58.198Z 2026-01-29T14:53:22.056Z
9252734 9252734 20260123055748_SR0l0 US0037 2026-01-24T14:16:57.768Z 2026-01-29T14:53:21.869Z
9251861 9251861 20260122233459_9iYxj US0037 2026-01-24T14:13:25.705Z 2026-01-29T14:52:13.853Z
9244678 9244678 20260121094003_1rVIa US0037 2026-01-22T14:26:30.084Z 2026-01-29T15:06:30.642Z
9244641 9244641 20260121092356_OLDWq US0037 2026-01-22T14:26:15.099Z 2026-01-29T15:06:28.468Z
9244531 9244531 20260121085620_w2kB4 US0037 2026-01-22T14:25:56.686Z 2026-01-29T15:06:24.605Z
9244362 9244362 20260121080208_c5qA1 US0037 2026-01-22T14:25:16.154Z 2026-01-29T15:06:03.336Z
9244339 9244339 20260121074222_t0y4Z US0037 2026-01-22T14:25:11.839Z 2026-01-29T15:06:02.258Z
9244319 9244319 20260121073453_OMHgB US0037 2026-01-22T14:25:09.102Z 2026-01-29T15:06:01.198Z
9244310 9244310 20260121072818_694xm US0037 2026-01-22T14:25:07.558Z 2026-01-29T15:06:00.734Z
9244294 9244294 20260121072209_Q6I9b US0037 2026-01-22T14:24:54.699Z 2026-01-29T15:05:59.771Z
9244144 9244144 20260121062202_8yYVh US0037 2026-01-22T14:24:17.089Z 2026-01-29T15:05:53.498Z
9239612 9239612 20260121112258_3mst2 US0037 2026-01-22T14:02:17.169Z 2026-01-29T14:54:32.093Z
9239570 9239570 20260121111100_J3j32 US0037 2026-01-22T14:01:58.430Z 2026-01-29T14:54:29.938Z
9239402 9239402 20260121104050_gk2fJ US0037 2026-01-22T14:01:20.517Z 2026-01-29T14:54:13.931Z
9239379 9239379 20260121103711_222tV US0037 2026-01-22T14:01:14.544Z 2026-01-29T14:54:12.518Z
9239213 9239213 20260121100243_WyXd6 US0037 2026-01-22T14:00:22.844Z 2026-01-29T14:53:54.185Z
9239161 9239161 20260121095047_FqIrL US0037 2026-01-22T14:00:09.381Z 2026-01-29T14:53:51.360Z
9239125 9239125 20260116105058_YcmQb US0037 2026-01-21T14:53:20.514Z 2026-01-24T15:15:10.883Z
9239120 9239120 20260116095106_Q2p2o US0037 2026-01-21T14:53:08.390Z 2026-01-24T15:14:40.538Z
9239118 9239118 20260116092006_kE9RO US0037 2026-01-21T14:53:04.929Z 2026-01-24T15:14:31.036Z
9239112 9239112 20260116085106_lUhbf US0037 2026-01-21T14:53:02.125Z 2026-01-24T15:14:24.983Z
9239110 9239110 20260116083751_l51Q3 US0037 2026-01-21T14:52:59.373Z 2026-01-24T15:14:11.674Z
9239106 9239106 20260116080000_gku3i US0037 2026-01-21T14:52:36.981Z 2026-01-24T15:14:04.768Z
9238986 9238986 20260119070452_E62iX US0037 2026-01-21T14:39:57.096Z 2026-01-27T15:06:11.643Z
9238979 9238979 20260119050635_Boj82 US0037 2026-01-21T14:39:14.824Z 2026-01-27T15:05:26.119Z
9238969 9238969 20260119040042_EZ9mp US0037 2026-01-21T14:38:38.246Z 2026-01-27T15:04:48.608Z
9238941 9238941 20260120092323_b6eNh US0037 2026-01-21T14:31:45.595Z 2026-01-28T15:02:42.847Z
9238934 9238934 20260120084815_qiHW5 US0037 2026-01-21T14:31:36.897Z 2026-01-28T15:02:36.190Z
9238923 9238923 20260120061509_8r6L1 US0037 2026-01-21T14:31:14.939Z 2026-01-28T15:01:45.471Z
9238914 9238914 20260119232125_wi9KV US0037 2026-01-21T14:31:11.090Z 2026-01-28T14:58:09.673Z
9238850 9238850 20260120095935_KkHng US0037 2026-01-21T14:30:43.365Z 2026-01-28T15:03:04.217Z
9238780 9238780 20260120094645_JAzmU US0037 2026-01-21T14:30:32.853Z 2026-01-28T15:02:50.200Z
9238602 9238602 20260120091245_C93Am US0037 2026-01-21T14:30:02.664Z 2026-01-28T15:02:40.552Z
9238140 9238140 20260120073503_oY6YU US0037 2026-01-21T14:28:47.239Z 2026-01-28T15:02:09.631Z
9237895 9237895 20260120061937_HWHID US0037 2026-01-21T14:28:00.669Z 2026-01-28T15:01:57.784Z
9237207 9237207 20260120045036_8cuvP US0037 2026-01-21T14:25:41.254Z 2026-01-28T15:01:02.866Z
9237168 9237168 20260120044615_SS9Ue US0037 2026-01-21T14:25:26.035Z 2026-01-21T14:25:26.035Z
9235807 9235807 20260120020110_ZMtfO US0037 2026-01-21T14:20:25.965Z 2026-01-28T14:59:21.689Z
9235001 9235001 20260120000532_hZ34T US0037 2026-01-21T14:17:07.632Z 2026-01-28T14:58:24.316Z
9234792 9234792 20260119232419_LlA1D US0037 2026-01-21T14:16:08.367Z 2026-01-28T14:58:13.478Z
9231843 9231843 20260119100249_D87nH US0037 2026-01-20T14:34:30.531Z 2026-01-27T15:07:02.031Z
9231311 9231311 20260119071424_ZnSTe US0037 2026-01-20T14:32:18.278Z 2026-01-27T15:06:22.742Z
9230811 9230811 20260119051337_RIpWt US0037 2026-01-20T14:29:54.652Z 2026-01-27T15:05:28.258Z
9226025 9226025 20260119104951_gsCIv US0037 2026-01-20T14:00:30.390Z 2026-01-28T14:54:29.312Z
9223286 9223286 20260118000627_fTEOR US0037 2026-01-19T14:18:34.320Z 2026-01-26T15:02:01.014Z
9215824 9215824 20260116110703_U6zRk US0037 2026-01-17T14:27:00.548Z 2026-01-24T15:15:14.409Z
9214919 9214919 20260116084546_nQQ0b US0037 2026-01-17T14:23:47.050Z 2026-01-24T15:14:21.656Z
9214880 9214880 20260116083353_IjqmG US0037 2026-01-17T14:23:36.050Z 2026-01-24T15:14:11.223Z
9214839 9214839 20260116082137_6RUiI US0037 2026-01-17T14:23:28.313Z 2026-01-24T15:14:09.712Z
9214445 9214445 20260116063652_1c2b7 US0037 2026-01-17T14:21:35.228Z 2026-01-24T15:13:38.086Z
9214291 9214291 20260116061000_RkFCO US0037 2026-01-17T14:20:59.735Z 2026-01-24T15:13:28.821Z
9214016 9214016 20260116051842_6NFDW US0037 2026-01-17T14:19:39.983Z 2026-01-24T15:12:57.940Z
9213899 9213899 20260116045735_TSfxF US0037 2026-01-17T14:19:02.107Z 2026-01-24T15:12:50.673Z
9213061 9213061 20260116020527_Ob5cV US0037 2026-01-17T14:15:13.576Z 2026-01-24T15:11:39.030Z
9197194 9197194 20260113102607_o3UW0 US0037 2026-01-14T14:21:50.882Z 2026-01-21T15:06:15.052Z
9196995 9196995 20260113095135_grtq9 US0037 2026-01-14T14:20:59.198Z 2026-01-21T15:06:12.206Z
9196168 9196168 20260113050715_0kq34 US0037 2026-01-14T14:16:56.931Z 2026-01-21T15:05:29.046Z
9196090 9196090 20260113043226_dKikl US0037 2026-01-14T14:16:31.749Z 2026-01-21T15:05:26.075Z
9195838 9195838 20260113030321_nZyrd US0037 2026-01-14T14:15:10.777Z 2026-01-21T15:04:48.518Z
9190087 9190087 20260112074816_v2JaN US0037 2026-01-13T14:20:40.447Z 2026-01-20T15:24:06.449Z
9190040 9190040 20260112073751_AKYGE US0037 2026-01-13T14:20:29.967Z 2026-01-20T15:24:04.364Z
9189575 9189575 20260112051002_DPO2W US0037 2026-01-13T14:18:19.568Z 2026-01-20T15:23:28.564Z
9171755 9171755 20260109025216_nZKE7 US0037 2026-01-10T14:09:20.578Z 2026-01-17T15:24:24.221Z
9168531 9168531 20260108111923_n65Oq US0037 2026-01-09T14:11:21.269Z 2026-01-16T15:12:49.910Z
9168473 9168473 20260108110705_cvMWn US0037 2026-01-09T14:11:10.272Z 2026-01-16T15:12:46.657Z
9168266 9168266 20260108102449_n6iJL US0037 2026-01-09T14:10:43.848Z 2026-01-16T15:12:25.725Z
9168039 9168039 20260108093833_GTG8r US0037 2026-01-09T14:10:11.890Z 2026-01-16T15:12:16.096Z
9167659 9167659 20260108035502_n3jLQ US0037 2026-01-09T14:08:42.343Z 2026-01-16T15:11:34.914Z
9167596 9167596 20260108031634_mcQ3o US0037 2026-01-09T14:08:24.694Z 2026-01-16T15:11:29.293Z
9163909 9163909 20260107111349_HWQ1n US0037 2026-01-08T14:10:59.680Z 2026-01-13T15:03:53.262Z
9114954 9114954 20251231043713_G26zl US0037 2026-01-01T14:23:52.894Z 2026-01-08T15:10:16.189Z
9066121 9066121 20251226055347_4qsAp US0037 2025-12-29T14:39:38.862Z 2026-01-03T15:37:32.564Z
9066119 9066119 20251226055347_YHOUg US0037 2025-12-29T14:39:38.514Z 2025-12-30T15:19:25.654Z
9066028 9066028 20251226054422_fLtqu US0037 2025-12-29T14:39:18.396Z 2026-01-03T15:37:29.218Z
9065864 9065864 20251226053645_o7vT8 US0037 2025-12-29T14:39:08.541Z 2026-01-03T15:37:22.694Z
9065828 9065828 20251226053340_osgNJ US0037 2025-12-29T14:39:06.227Z 2026-01-03T15:37:20.640Z
9065683 9065683 20251226052410_32gj3 US0037 2025-12-29T14:38:58.639Z 2026-01-03T15:37:11.432Z
9063389 9063389 20251226030931_7KHoc US0037 2025-12-29T14:35:18.895Z 2026-01-03T15:35:15.828Z
9062939 9062939 20251226024514_jMenh US0037 2025-12-29T14:34:20.230Z 2026-01-03T15:34:49.256Z
9062288 9062288 20251226020331_lVO3W US0037 2025-12-29T14:32:58.903Z 2026-01-03T15:34:14.717Z
9059851 9059851 20251225230406_upE3o US0037 2025-12-29T14:28:06.634Z 2025-12-29T14:51:12.390Z
9038554 9038554 20251224110746_nu2M3 US0037 2025-12-28T14:39:31.332Z 2026-01-01T15:55:28.354Z

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