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

253 rows where station_code = "US004M" 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
9261154 9261154 20260126100405_zUTh3 US004M 2026-01-27T14:02:15.505Z 2026-01-29T14:31:59.974Z
9249720 9249720 20260122074104_x28I4 US004M 2026-01-23T14:16:00.379Z 2026-01-29T14:58:51.440Z
9189979 9189979 20260112071622_Csku2 US004M 2026-01-13T14:20:10.926Z 2026-01-20T15:24:00.573Z
8965001 8965001 20251216094844_uDe1y US004M 2025-12-25T14:42:52.298Z 2025-12-25T14:42:52.298Z
8963417 8963417 20251216052840_s3AcT US004M 2025-12-25T14:39:05.788Z 2025-12-25T14:39:05.788Z
8638004 8638004 20251128075650_OpV6Z US004M 2025-11-29T14:28:23.883Z 2025-12-06T15:04:06.763Z
8637917 8637917 20251128073040_DTMjd US004M 2025-11-29T14:28:09.559Z 2025-12-06T15:04:05.640Z
8500029 8500029 20251116071115_vKLin US004M 2025-11-18T14:45:27.280Z 2025-11-24T15:05:30.263Z
8486342 8486342 20251115112718_hXrlS US004M 2025-11-17T14:34:17.156Z 2025-11-23T15:20:30.658Z
8461477 8461477 20251114092430_CQ0gb US004M 2025-11-15T14:24:19.741Z 2025-11-22T15:23:27.086Z
8461038 8461038 20251114083017_7JMp8 US004M 2025-11-15T14:23:30.473Z 2025-11-22T15:23:01.895Z
8458928 8458928 20251114021639_pXX3d US004M 2025-11-15T14:18:16.842Z 2025-11-22T15:21:28.591Z
8376581 8376581 20251103112100_DIIYS US004M 2025-11-05T14:36:51.491Z 2025-11-11T15:08:46.376Z
8338673 8338673 20251031090944_hyQSS US004M 2025-11-02T14:32:55.538Z 2025-11-08T15:17:08.560Z
8326903 8326903 20251030102151_3ELDI US004M 2025-11-01T12:36:29.281Z 2025-11-07T15:18:32.290Z
8326398 8326398 20251030093830_9TeWn US004M 2025-11-01T12:35:30.022Z 2025-11-07T15:17:59.381Z
8324035 8324035 20251030051917_5qKcv US004M 2025-11-01T12:31:38.831Z 2025-11-07T15:16:53.835Z
8204395 8204395 20251023104000_4ncpL US004M 2025-10-25T12:27:19.990Z 2025-10-31T13:09:06.598Z
8203625 8203625 20251023092309_vLq2O US004M 2025-10-25T12:25:09.710Z 2025-10-31T13:09:01.384Z
8203040 8203040 20251023081740_t0ITi US004M 2025-10-25T12:23:14.764Z 2025-10-31T13:08:58.428Z
8202714 8202714 20251023072237_OYzVg US004M 2025-10-25T12:22:22.136Z 2025-10-31T13:08:56.556Z
8202611 8202611 20251023070817_GSHjO US004M 2025-10-25T12:21:50.484Z 2025-10-31T13:08:56.153Z
8202244 8202244 20251023055901_BoxFr US004M 2025-10-25T12:20:40.296Z 2025-10-31T13:08:54.645Z
8088460 8088460 20251012072520_RDGMf US004M 2025-10-13T12:13:52.204Z 2025-10-20T13:04:00.990Z
8059018 8059018 20251005103201_Y7tbj US004M 2025-10-07T12:04:02.278Z 2025-10-14T12:33:11.147Z
8053567 8053567 20251003105448_mETix US004M 2025-10-05T12:06:03.133Z 2025-10-12T12:30:41.116Z
8053358 8053358 20251003102548_20cm3 US004M 2025-10-05T12:05:05.193Z 2025-10-12T12:30:24.091Z
8022513 8022513 20250930090334_j0q0T US004M 2025-10-02T12:04:46.523Z 2025-10-09T12:35:06.189Z
8021496 8021496 20250930061117_m6yTA US004M 2025-10-01T12:48:40.692Z 2025-10-08T12:44:16.228Z
7999223 7999223 20250929100141_nmqo2 US004M 2025-09-30T12:07:06.541Z 2025-10-08T12:41:44.096Z
7998873 7998873 20250929090807_5XWd6 US004M 2025-09-30T12:05:32.116Z 2025-10-08T12:41:30.088Z
7998871 7998871 20250929090624_mgIWj US004M 2025-09-30T12:05:31.613Z 2025-10-08T12:41:30.014Z
7991081 7991081 20250927105605_KvcJ3 US004M 2025-09-29T12:10:48.351Z 2025-10-05T13:05:00.759Z
7990522 7990522 20250928092736_k9FCr US004M 2025-09-29T12:02:22.488Z 2025-10-07T12:59:26.224Z
7985005 7985005 20250927024256_foOp4 US004M 2025-09-28T12:25:22.474Z 2025-10-05T13:11:05.330Z
7977591 7977591 20250926084627_Ntmq4 US004M 2025-09-28T12:09:14.561Z 2025-10-05T13:08:33.575Z
7975704 7975704 20250927070207_22H8j US004M 2025-09-28T12:01:59.662Z 2025-10-05T13:04:12.827Z
7952919 7952919 20250925092522_TjHvm US004M 2025-09-26T12:02:18.612Z 2025-10-04T13:05:42.957Z
7836032 7836032 20250914040313_UcDQZ US004M 2025-09-16T12:22:57.772Z 2025-09-22T13:07:29.804Z
7752816 7752816 20250903093042_YMrjE US004M 2025-09-04T12:20:14.207Z 2025-09-11T12:45:27.477Z
7719229 7719229 20250830052658_93RP0 US004M 2025-09-01T12:37:54.871Z 2025-09-07T12:59:09.818Z
7697209 7697209 20250829100627_TeLvE US004M 2025-08-30T12:30:43.053Z 2025-09-06T14:13:34.833Z
7675167 7675167 20250827051830_S7Ddp US004M 2025-08-28T12:27:22.732Z 2025-09-04T12:56:53.607Z
7664469 7664469 20250827091931_IzaNA US004M 2025-08-28T12:00:19.598Z 2025-09-05T13:03:40.660Z
7652185 7652185 20250826093025_fTBp4 US004M 2025-08-27T12:00:56.455Z 2025-08-27T12:00:56.455Z
7652029 7652029 20250826080704_tlhEx US004M 2025-08-27T12:00:14.775Z 2025-09-04T12:54:57.831Z
7614816 7614816 20250822032720_mJyY4 US004M 2025-08-23T12:27:20.360Z 2025-08-30T12:59:53.258Z
7604546 7604546 20250822075755_Rj2S3 US004M 2025-08-23T12:02:24.247Z 2025-08-31T12:53:08.873Z
7593705 7593705 20250820094307_2TMFA US004M 2025-08-22T12:08:38.363Z 2025-08-29T12:55:37.502Z
7593271 7593271 20250820082559_A95Av US004M 2025-08-22T12:07:21.597Z 2025-08-29T12:55:33.560Z
7592881 7592881 20250820063139_h3vmZ US004M 2025-08-22T12:05:54.436Z 2025-08-29T12:55:23.785Z
7592000 7592000 20250821070854_cLsfo US004M 2025-08-22T12:01:44.831Z 2025-08-30T12:58:35.115Z
7566651 7566651 20250818050135_2d3Z6 US004M 2025-08-20T12:09:03.027Z 2025-08-27T13:13:19.678Z
7534897 7534897 20250816092756_jVuHN US004M 2025-08-18T12:17:47.314Z 2025-08-24T12:48:00.673Z
7521619 7521619 20250815060645_8xNUz US004M 2025-08-17T12:21:43.292Z 2025-08-23T12:48:55.247Z
7490296 7490296 20250813060627_naZAT US004M 2025-08-15T12:56:12.430Z 2025-08-21T12:47:52.452Z
7490144 7490144 20250813054512_JRyY2 US004M 2025-08-15T12:56:06.748Z 2025-08-21T12:47:51.706Z
7490101 7490101 20250813054002_RO7gW US004M 2025-08-15T12:56:03.796Z 2025-08-21T12:47:51.610Z
7489779 7489779 20250813045537_V5RrX US004M 2025-08-15T12:55:23.564Z 2025-08-21T12:47:51.024Z
7489342 7489342 20250813034356_zj2Ny US004M 2025-08-15T12:54:35.880Z 2025-08-21T12:47:49.067Z
7452068 7452068 20250812064138_fS5bx US004M 2025-08-13T12:19:12.038Z 2025-08-20T13:06:47.875Z
7401521 7401521 20250807083346_CbSOM US004M 2025-08-08T12:29:44.490Z 2025-08-15T13:39:48.532Z
7398120 7398120 20250806082219_NT9wZ US004M 2025-08-08T12:24:48.180Z 2025-08-14T12:59:17.155Z
7398034 7398034 20250806080712_g5wlf US004M 2025-08-08T12:24:44.620Z 2025-08-14T12:59:16.518Z
7397298 7397298 20250806060020_BlbBj US004M 2025-08-08T12:23:41.939Z 2025-08-14T12:59:05.258Z
7382610 7382610 20250805092607_9q719 US004M 2025-08-07T12:19:02.521Z 2025-08-13T13:00:05.058Z
7382534 7382534 20250805091814_h2xAP US004M 2025-08-07T12:19:00.143Z 2025-08-13T13:00:03.963Z
7381998 7381998 20250805083413_VO9YX US004M 2025-08-07T12:18:43.121Z 2025-08-13T12:59:57.672Z
7379121 7379121 20250805022745_nRDtZ US004M 2025-08-07T12:14:55.097Z 2025-08-13T12:59:05.245Z
7379028 7379028 20250805022343_90ilT US004M 2025-08-07T12:14:51.965Z 2025-08-13T12:59:04.029Z
7351052 7351052 20250803054236_3XLyb US004M 2025-08-05T12:19:42.249Z 2025-08-11T12:54:04.976Z
7090458 7090458 20250715082417_3rgFj US004M 2025-07-16T12:16:22.931Z 2025-07-23T12:05:04.626Z
7090333 7090333 20250715071640_3wrtP US004M 2025-07-16T12:15:45.911Z 2025-07-23T12:05:04.269Z
7048252 7048252 20250707090810_yaLWC US004M 2025-07-08T12:02:57.526Z 2025-07-16T12:42:32.487Z
7027454 7027454 20250703093040_moExF US004M 2025-07-04T12:08:12.910Z 2025-07-12T12:57:34.556Z
7027411 7027411 20250703084627_CWF0u US004M 2025-07-04T12:07:55.898Z 2025-07-12T12:57:32.779Z
7027390 7027390 20250703082406_DXoRE US004M 2025-07-04T12:07:50.776Z 2025-07-12T12:57:30.150Z
7022884 7022884 20250702092436_gXko8 US004M 2025-07-03T12:10:29.118Z 2025-07-10T12:25:55.480Z
7022505 7022505 20250702071451_lBOxW US004M 2025-07-03T12:09:23.696Z 2025-07-10T12:25:53.954Z
7015066 7015066 20250701082219_2s588 US004M 2025-07-02T12:11:25.013Z 2025-07-09T12:58:32.762Z
6988617 6988617 20250628065322_HYKRh US004M 2025-06-29T12:15:24.381Z 2025-07-06T12:42:51.477Z
6988253 6988253 20250628040231_T91aA US004M 2025-06-29T12:14:23.946Z 2025-07-06T12:42:43.700Z
6988196 6988196 20250628030855_T1WDH US004M 2025-06-29T12:14:11.805Z 2025-07-06T12:42:43.180Z
6978398 6978398 20250626092014_bY3DP US004M 2025-06-27T12:14:17.933Z 2025-07-04T12:36:18.815Z
6978371 6978371 20250626091251_48Pn5 US004M 2025-06-27T12:14:12.103Z 2025-07-04T12:36:18.335Z
6977883 6977883 20250626072419_WYJN5 US004M 2025-06-27T12:13:01.289Z 2025-07-04T12:36:08.700Z
6957390 6957390 20250623084753_Bj5qj US004M 2025-06-24T12:24:57.037Z 2025-07-01T12:54:02.019Z
6956476 6956476 20250623063243_lmgsU US004M 2025-06-24T12:22:53.990Z 2025-07-01T12:53:35.166Z
6956287 6956287 20250623055847_u36fU US004M 2025-06-24T12:22:15.882Z 2025-07-01T12:53:30.051Z
6955947 6955947 20250623034421_3f2ZO US004M 2025-06-24T12:21:22.128Z 2025-07-01T12:53:23.045Z
6949871 6949871 20250622084100_IJAoI US004M 2025-06-23T12:28:36.837Z 2025-06-30T12:36:00.139Z
6937515 6937515 20250621064025_e3ef7 US004M 2025-06-22T12:17:22.066Z 2025-06-29T12:36:52.486Z
6733488 6733488 20250516094415_ZMJ70 US004M 2025-05-17T12:08:52.173Z 2025-05-24T12:40:22.591Z
6670930 6670930 20250506084942_07xGS US004M 2025-05-07T12:19:31.384Z 2025-05-14T12:41:48.792Z
6520880 6520880 20250418083246_sWXsp US004M 2025-04-19T12:02:57.144Z 2025-04-27T12:35:13.510Z
6485187 6485187 20250408094803_5xCEK US004M 2025-04-09T12:08:41.812Z 2025-04-16T12:26:09.453Z
6458867 6458867 20250404071945_UHtm6 US004M 2025-04-05T12:13:16.235Z 2025-04-12T12:39:29.787Z
6458851 6458851 20250404065829_sigxn US004M 2025-04-05T12:13:13.329Z 2025-04-12T12:39:29.558Z
6400758 6400758 20250327094308_ccyyR US004M 2025-03-28T12:13:35.792Z 2025-04-04T12:48:14.978Z
6380116 6380116 20250324093127_lA8cm US004M 2025-03-25T12:08:43.211Z 2025-04-01T13:00:49.292Z

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