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

4,163 rows where station_code = "US002N" 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
8690715 8690715 20251205012734_b05NV US002N 2025-12-06T14:15:15.121Z 2025-12-06T14:18:00.944Z
8638003 8638003 20251128075650_OpV6Z US002N 2025-11-29T14:28:23.883Z 2025-12-06T15:04:06.763Z
8637916 8637916 20251128073040_DTMjd US002N 2025-11-29T14:28:09.559Z 2025-12-06T15:04:05.640Z
8637204 8637204 20251128051503_9ZJ3L US002N 2025-11-29T14:26:58.025Z 2025-12-06T15:03:57.661Z
8626399 8626399 20251128083203_52qQE US002N 2025-11-29T14:00:14.270Z 2025-12-06T14:50:33.434Z
8501486 8501486 20251116110635_Zn2BC US002N 2025-11-18T14:47:26.477Z 2025-11-24T15:06:37.346Z
8501350 8501350 20251116104944_I2L2i US002N 2025-11-18T14:47:20.952Z 2025-11-24T15:06:28.815Z
8500656 8500656 20251116093103_w6aA3 US002N 2025-11-18T14:46:27.764Z 2025-11-24T15:05:54.885Z
8500370 8500370 20251116084621_HNrfw US002N 2025-11-18T14:46:09.106Z 2025-11-24T15:05:40.341Z
8500343 8500343 20251116083449_doozz US002N 2025-11-18T14:46:05.129Z 2025-11-24T15:05:39.533Z
8500279 8500279 20251116082538_JT00g US002N 2025-11-18T14:45:49.672Z 2025-11-24T15:05:37.521Z
8500216 8500216 20251116081333_35EXK US002N 2025-11-18T14:45:39.472Z 2025-11-24T15:05:36.259Z
8500203 8500203 20251116080637_wCaVH US002N 2025-11-18T14:45:37.723Z 2025-11-24T15:05:35.693Z
8500125 8500125 20251116074503_3li9X US002N 2025-11-18T14:45:33.258Z 2025-11-24T15:05:32.679Z
8500052 8500052 20251116072518_fYxy3 US002N 2025-11-18T14:45:28.895Z 2025-11-24T15:05:30.723Z
8500028 8500028 20251116071115_vKLin US002N 2025-11-18T14:45:27.280Z 2025-11-24T15:05:30.263Z
8486678 8486678 20251116112950_cPyCT US002N 2025-11-18T14:00:29.263Z 2025-11-25T15:06:00.017Z
8486341 8486341 20251115112718_hXrlS US002N 2025-11-17T14:34:17.156Z 2025-11-23T15:20:30.658Z
8482230 8482230 20251116055049_fn2wv US002N 2025-11-17T14:22:55.638Z 2025-11-24T15:05:22.422Z
8482082 8482082 20251116051034_3POOG US002N 2025-11-17T14:22:25.553Z 2025-11-24T15:05:19.135Z
8480927 8480927 20251116005129_3YL2J US002N 2025-11-17T14:19:27.813Z 2025-11-24T15:04:57.282Z
8469022 8469022 20251115015155_8tLzZ US002N 2025-11-16T14:19:14.031Z 2025-11-23T15:17:33.517Z
8461896 8461896 20251114101503_QPADJ US002N 2025-11-15T14:25:02.326Z 2025-11-22T15:23:44.609Z
8461476 8461476 20251114092430_CQ0gb US002N 2025-11-15T14:24:19.740Z 2025-11-22T15:23:27.086Z
8461037 8461037 20251114083017_7JMp8 US002N 2025-11-15T14:23:30.473Z 2025-11-22T15:23:01.895Z
8460429 8460429 20251114070052_kBHRq US002N 2025-11-15T14:22:05.900Z 2025-11-22T15:22:37.011Z
8458927 8458927 20251114021639_pXX3d US002N 2025-11-15T14:18:16.832Z 2025-11-22T15:21:28.591Z
8386026 8386026 20251106021826_ESXNn US002N 2025-11-07T14:09:19.179Z 2025-11-14T15:08:32.121Z
8376580 8376580 20251103112100_DIIYS US002N 2025-11-05T14:36:51.491Z 2025-11-11T15:08:46.376Z
8376314 8376314 20251103103355_JYvPH US002N 2025-11-05T14:36:32.685Z 2025-11-11T15:08:29.239Z
8375811 8375811 20251103090636_6Puj5 US002N 2025-11-05T14:35:33.343Z 2025-11-11T15:08:19.717Z
8366183 8366183 20251102101904_9mR6z US002N 2025-11-04T14:34:47.893Z 2025-11-10T15:10:29.779Z
8358574 8358574 20251102085415_abtME US002N 2025-11-03T14:45:37.236Z 2025-11-10T15:10:21.835Z
8339779 8339779 20251031105219_qEOY3 US002N 2025-11-02T14:34:27.542Z 2025-11-08T15:17:46.928Z
8339065 8339065 20251031095406_SNPP0 US002N 2025-11-02T14:33:26.754Z 2025-11-08T15:17:27.115Z
8338672 8338672 20251031090944_hyQSS US002N 2025-11-02T14:32:55.530Z 2025-11-08T15:17:08.560Z
8327202 8327202 20251030105110_mpjxc US002N 2025-11-01T12:37:05.173Z 2025-11-07T15:18:49.769Z
8326902 8326902 20251030102151_3ELDI US002N 2025-11-01T12:36:29.280Z 2025-11-07T15:18:32.290Z
8326397 8326397 20251030093830_9TeWn US002N 2025-11-01T12:35:30.022Z 2025-11-07T15:17:59.381Z
8326161 8326161 20251030091535_sfm28 US002N 2025-11-01T12:35:18.218Z 2025-11-07T15:17:44.473Z
8326012 8326012 20251030085621_pv7rP US002N 2025-11-01T12:35:11.032Z 2025-11-07T15:17:37.948Z
8324034 8324034 20251030051917_5qKcv US002N 2025-11-01T12:31:38.831Z 2025-11-07T15:16:53.835Z
8284357 8284357 20251028043736_UYnso US002N 2025-10-29T12:45:30.574Z 2025-11-05T15:22:44.910Z
8275663 8275663 20251027071803_dXBU5 US002N 2025-10-29T12:28:16.839Z 2025-11-04T15:46:10.665Z
8227815 8227815 20251024111138_83IEO US002N 2025-10-26T12:46:38.798Z 2025-11-01T13:11:30.675Z
8227088 8227088 20251024101605_mG23A US002N 2025-10-26T12:45:21.978Z 2025-11-01T13:11:28.368Z
8226528 8226528 20251024093319_8H2D8 US002N 2025-10-26T12:45:03.924Z 2025-11-01T13:11:26.392Z
8226421 8226421 20251024092631_Nw8C6 US002N 2025-10-26T12:45:01.339Z 2025-11-01T13:11:25.607Z
8225411 8225411 20251024080341_lo4n8 US002N 2025-10-26T12:43:16.181Z 2025-11-01T13:11:21.823Z
8225237 8225237 20251024074914_p5b85 US002N 2025-10-26T12:43:08.147Z 2025-11-01T13:11:21.388Z
8217803 8217803 20251024024520_pv6r1 US002N 2025-10-26T12:34:17.393Z 2025-11-01T13:10:46.093Z
8204394 8204394 20251023104000_4ncpL US002N 2025-10-25T12:27:19.990Z 2025-10-31T13:09:06.598Z
8204335 8204335 20251023103501_r6ILq US002N 2025-10-25T12:27:15.295Z 2025-10-31T13:09:06.409Z
8203624 8203624 20251023092309_vLq2O US002N 2025-10-25T12:25:09.710Z 2025-10-31T13:09:01.384Z
8203612 8203612 20251023092110_6LTr9 US002N 2025-10-25T12:25:08.402Z 2025-10-31T13:09:01.369Z
8203489 8203489 20251023091025_YbnqP US002N 2025-10-25T12:24:42.881Z 2025-10-31T13:08:59.918Z
8203100 8203100 20251023082303_7ubuJ US002N 2025-10-25T12:23:24.317Z 2025-10-31T13:08:58.963Z
8203039 8203039 20251023081740_t0ITi US002N 2025-10-25T12:23:14.764Z 2025-10-31T13:08:58.428Z
8202784 8202784 20251023073403_g4mFe US002N 2025-10-25T12:22:30.497Z 2025-10-31T13:08:57.592Z
8202713 8202713 20251023072237_OYzVg US002N 2025-10-25T12:22:22.135Z 2025-10-31T13:08:56.556Z
8202693 8202693 20251023072047_SmOsN US002N 2025-10-25T12:22:19.392Z 2025-10-31T13:08:56.490Z
8202610 8202610 20251023070817_GSHjO US002N 2025-10-25T12:21:50.484Z 2025-10-31T13:08:56.153Z
8202384 8202384 20251023062933_kUjBy US002N 2025-10-25T12:21:02.780Z 2025-10-31T13:08:55.121Z
8202243 8202243 20251023055901_BoxFr US002N 2025-10-25T12:20:40.296Z 2025-10-31T13:08:54.645Z
8202067 8202067 20251023052850_0hg9p US002N 2025-10-25T12:20:01.132Z 2025-10-31T13:08:54.047Z
8099629 8099629 20251014061152_MIotj US002N 2025-10-15T12:19:32.472Z 2025-10-22T13:10:16.308Z
8089007 8089007 20251012095737_426Bs US002N 2025-10-13T12:15:13.006Z 2025-10-20T13:04:09.085Z
8088911 8088911 20251012093340_VnX1p US002N 2025-10-13T12:15:06.749Z 2025-10-20T13:04:07.635Z
8088793 8088793 20251012090313_63n13 US002N 2025-10-13T12:14:51.662Z 2025-10-20T13:04:06.116Z
8088459 8088459 20251012072520_RDGMf US002N 2025-10-13T12:13:52.204Z 2025-10-20T13:04:00.990Z
8088087 8088087 20251012045836_OeMeV US002N 2025-10-13T12:12:52.892Z 2025-10-20T13:03:54.038Z
8087811 8087811 20251012035120_C886e US002N 2025-10-13T12:12:05.289Z 2025-10-20T13:03:47.512Z
8083166 8083166 20251011051036_NflJU US002N 2025-10-12T12:09:43.797Z 2025-10-19T12:50:09.301Z
8075852 8075852 20251009045416_cpftw US002N 2025-10-10T12:10:34.952Z 2025-10-17T12:38:00.347Z
8059017 8059017 20251005103201_Y7tbj US002N 2025-10-07T12:04:02.278Z 2025-10-14T12:33:11.147Z
8053566 8053566 20251003105448_mETix US002N 2025-10-05T12:06:03.133Z 2025-10-12T12:30:41.116Z
8053411 8053411 20251003103325_vAzVx US002N 2025-10-05T12:05:20.602Z 2025-10-12T12:30:28.286Z
8053357 8053357 20251003102548_20cm3 US002N 2025-10-05T12:05:05.193Z 2025-10-12T12:30:24.091Z
8022512 8022512 20250930090334_j0q0T US002N 2025-10-02T12:04:46.523Z 2025-10-09T12:35:06.189Z
8022330 8022330 20250930083432_0oGgS US002N 2025-10-02T12:03:37.061Z 2025-10-09T12:34:52.796Z
8022263 8022263 20250930082403_z9FhO US002N 2025-10-02T12:03:18.381Z 2025-10-09T12:34:40.366Z
8021495 8021495 20250930061117_m6yTA US002N 2025-10-01T12:48:40.692Z 2025-10-08T12:44:16.228Z
8012192 8012192 20250929102611_YZkjO US002N 2025-10-01T12:09:47.318Z 2025-10-08T12:41:45.150Z
8011505 8011505 20250929050000_KsG12 US002N 2025-09-30T12:33:49.333Z 2025-10-07T13:01:30.058Z
7999222 7999222 20250929100141_nmqo2 US002N 2025-09-30T12:07:06.541Z 2025-10-08T12:41:44.096Z
7998872 7998872 20250929090807_5XWd6 US002N 2025-09-30T12:05:32.116Z 2025-10-08T12:41:30.088Z
7998870 7998870 20250929090624_mgIWj US002N 2025-09-30T12:05:31.613Z 2025-10-08T12:41:30.014Z
7997911 7997911 20250929063005_k0ZdW US002N 2025-09-30T12:01:03.532Z 2025-09-30T12:01:03.532Z
7997881 7997881 20250929062517_tePni US002N 2025-09-30T12:00:54.182Z 2025-10-08T12:40:52.711Z
7991080 7991080 20250927105605_KvcJ3 US002N 2025-09-29T12:10:48.351Z 2025-10-05T13:05:00.759Z
7990579 7990579 20250928101423_eXqHn US002N 2025-09-29T12:02:43.010Z 2025-10-07T12:59:27.475Z
7990521 7990521 20250928092736_k9FCr US002N 2025-09-29T12:02:22.488Z 2025-10-07T12:59:26.224Z
7990177 7990177 20250928063256_wlOOx US002N 2025-09-29T12:00:35.789Z 2025-10-07T12:59:15.964Z
7989684 7989684 20250926040704_NW2wd US002N 2025-09-28T12:36:50.834Z 2025-10-04T13:07:23.874Z
7985004 7985004 20250927024256_foOp4 US002N 2025-09-28T12:25:22.474Z 2025-10-05T13:11:05.330Z
7977590 7977590 20250926084627_Ntmq4 US002N 2025-09-28T12:09:14.561Z 2025-10-05T13:08:33.575Z
7977492 7977492 20250926082104_5anL4 US002N 2025-09-28T12:08:52.305Z 2025-10-05T13:08:30.185Z
7977222 7977222 20250926071042_BReso US002N 2025-09-28T12:07:52.634Z 2025-10-05T13:08:22.664Z
7977050 7977050 20250926054924_yYh2F US002N 2025-09-28T12:07:11.583Z 2025-10-05T13:08:19.091Z
7976597 7976597 20250927103150_G1kJQ US002N 2025-09-28T12:05:48.483Z 2025-10-05T13:04:54.221Z

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