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,920 rows where station_code = "US004J" 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
9259834 9259834 20260125003928_rnJgq US004J 2026-01-26T14:18:48.671Z 2026-01-29T14:43:24.370Z
9259803 9259803 20260125002404_8Mv9P US004J 2026-01-26T14:18:38.677Z 2026-01-29T14:43:22.346Z
9256426 9256426 20260124082801_uHvh3 US004J 2026-01-25T14:17:05.787Z 2026-01-29T14:48:49.695Z
9256004 9256004 20260124053917_uDMA9 US004J 2026-01-25T14:15:32.028Z 2026-01-29T14:48:18.008Z
9255010 9255010 20260124002056_yXzER US004J 2026-01-25T14:11:38.192Z 2026-01-29T14:46:59.710Z
9253294 9253294 20260124104751_xZxGn US004J 2026-01-25T14:01:52.128Z 2026-01-29T14:40:35.120Z
9253200 9253200 20260124100848_vCVxn US004J 2026-01-25T14:01:16.622Z 2026-01-29T14:40:26.231Z
9253188 9253188 20260124100245_QnvaX US004J 2026-01-25T14:01:12.386Z 2026-01-29T14:40:24.975Z
9253093 9253093 20260124091553_aKbyG US004J 2026-01-25T14:00:39.201Z 2026-01-29T14:40:14.748Z
9252857 9252857 20260123071101_lcTMt US004J 2026-01-24T14:17:31.244Z 2026-01-29T14:53:38.052Z
9252839 9252839 20260123064820_MH23I US004J 2026-01-24T14:17:27.533Z 2026-01-29T14:53:36.490Z
9250046 9250046 20260123095512_fwhWU US004J 2026-01-24T14:00:49.778Z 2026-01-29T14:44:55.515Z
9244609 9244609 20260121091458_TXFW2 US004J 2026-01-22T14:26:06.361Z 2026-01-29T15:06:27.476Z
9244414 9244414 20260121082149_sfhbW US004J 2026-01-22T14:25:25.939Z 2026-01-29T15:06:08.153Z
9244392 9244392 20260121081240_1or5Q US004J 2026-01-22T14:25:21.428Z 2026-01-29T15:06:06.790Z
9244278 9244278 20260121071450_1L8Bd US004J 2026-01-22T14:24:49.503Z 2026-01-29T15:05:58.903Z
9244274 9244274 20260121071255_2Nw1t US004J 2026-01-22T14:24:48.223Z 2026-01-29T15:05:58.609Z
9242090 9242090 20260121002439_RHwks US004J 2026-01-22T14:16:19.408Z 2026-01-29T15:03:29.659Z
9239236 9239236 20260121100904_On23f US004J 2026-01-22T14:00:31.146Z 2026-01-29T14:53:55.979Z
9238880 9238880 20260120100739_eYpzB US004J 2026-01-21T14:30:45.942Z 2026-01-28T15:03:05.250Z
9238352 9238352 20260120082605_TO3UT US004J 2026-01-21T14:29:25.228Z 2026-01-28T15:02:30.216Z
9235834 9235834 20260120020636_E2DOf US004J 2026-01-21T14:20:31.758Z 2026-01-28T14:59:23.472Z
9214888 9214888 20260116083618_kwxEo US004J 2026-01-17T14:23:37.894Z 2026-01-24T15:14:11.578Z
9212757 9212757 20260116005129_wxDZ3 US004J 2026-01-17T14:13:40.303Z 2026-01-24T15:11:25.204Z
9191119 9191119 20260112103454_qE8K3 US004J 2026-01-13T14:24:29.148Z 2026-01-20T15:25:10.989Z
9190155 9190155 20260112080352_9Ljcc US004J 2026-01-13T14:20:56.310Z 2026-01-20T15:24:09.041Z
9189071 9189071 20260112025158_iUs5f US004J 2026-01-13T14:15:38.767Z 2026-01-20T15:22:37.611Z
9188994 9188994 20260112023333_NzwV5 US004J 2026-01-13T14:15:15.416Z 2026-01-20T15:22:33.272Z
9177618 9177618 20260110103713_ntKhd US004J 2026-01-11T14:12:30.435Z 2026-01-18T15:09:52.249Z
9177387 9177387 20260110093606_M4pTO US004J 2026-01-11T14:11:52.193Z 2026-01-18T15:09:40.334Z
9172419 9172419 20260109103800_edfc2 US004J 2026-01-10T14:13:16.582Z 2026-01-17T15:25:30.346Z
9172307 9172307 20260109095734_hfcsG US004J 2026-01-10T14:12:42.077Z 2026-01-17T15:25:18.629Z
9172305 9172305 20260109095425_KXk46 US004J 2026-01-10T14:12:40.871Z 2026-01-17T15:25:18.247Z
9172112 9172112 20260109090004_fNRtS US004J 2026-01-10T14:11:47.879Z 2026-01-17T15:25:06.731Z
9172002 9172002 20260109070738_bVGMW US004J 2026-01-10T14:11:07.558Z 2026-01-17T15:24:50.848Z
9171980 9171980 20260109063242_bDO0R US004J 2026-01-10T14:10:58.508Z 2026-01-17T15:24:47.146Z
9171891 9171891 20260109042804_JLnuW US004J 2026-01-10T14:10:17.927Z 2026-01-17T15:24:40.923Z
9171824 9171824 20260109033829_URPbs US004J 2026-01-10T14:09:51.372Z 2026-01-17T15:24:35.800Z
9128349 9128349 20260102084122_lPenD US004J 2026-01-03T14:14:41.557Z 2026-01-09T14:50:44.059Z
9117486 9117486 20251231110906_T2Hjt US004J 2026-01-01T14:31:52.124Z 2026-01-08T15:13:09.858Z
9117479 9117479 20251231110753_YKWLD US004J 2026-01-01T14:31:48.522Z 2026-01-08T15:13:09.322Z
9117437 9117437 20251231105931_aBEei US004J 2026-01-01T14:31:36.017Z 2026-01-01T14:57:55.474Z
9117362 9117362 20251231104323_xFghp US004J 2026-01-01T14:31:14.176Z 2026-01-08T15:12:54.119Z
9117150 9117150 20251231094232_9te7W US004J 2026-01-01T14:30:24.586Z 2026-01-08T15:12:41.010Z
9117118 9117118 20251231092410_IpLQs US004J 2026-01-01T14:30:13.490Z 2026-01-08T15:12:38.579Z
9105246 9105246 20251230101905_pHOBQ US004J 2025-12-31T14:24:27.472Z 2026-01-01T14:58:00.922Z
9105244 9105244 20251230101849_W2y6W US004J 2025-12-31T14:24:27.041Z 2026-01-07T15:10:39.070Z
9067713 9067713 20251226102723_OxJ4V US004J 2025-12-29T14:42:33.187Z 2026-01-03T15:39:03.100Z
9067295 9067295 20251226090303_TEDXd US004J 2025-12-29T14:41:42.658Z 2025-12-30T15:20:09.325Z
9067293 9067293 20251226090201_c9rDy US004J 2025-12-29T14:41:42.397Z 2025-12-30T15:20:09.277Z
9067280 9067280 20251226090053_az3jw US004J 2025-12-29T14:41:41.686Z 2026-01-03T15:38:36.045Z
9067092 9067092 20251226080259_UCCbO US004J 2025-12-29T14:41:11.433Z 2026-01-03T15:38:24.667Z
9067082 9067082 20251226075933_ZHxAr US004J 2025-12-29T14:41:10.591Z 2025-12-30T15:20:04.825Z
9066952 9066952 20251226072646_33jDn US004J 2025-12-29T14:40:57.766Z 2025-12-30T15:20:01.577Z
9060077 9060077 20251225232513_QFfpt US004J 2025-12-29T14:28:44.577Z 2026-01-03T15:32:32.802Z
9044775 9044775 20251223054143_1naDV US004J 2025-12-28T14:52:29.049Z 2025-12-31T15:42:40.115Z
9044411 9044411 20251223024957_DIJv2 US004J 2025-12-28T14:50:32.095Z 2025-12-31T15:42:10.588Z
9029119 9029119 20251225033518_M6kX9 US004J 2025-12-28T14:15:41.133Z 2026-01-02T15:44:16.832Z
9019739 9019739 20251220103449_AgUXY US004J 2025-12-27T15:04:59.150Z 2025-12-29T15:24:37.417Z
9019512 9019512 20251220100217_DDN1f US004J 2025-12-27T15:04:31.455Z 2025-12-27T15:04:31.455Z
9019424 9019424 20251220094850_ShUx2 US004J 2025-12-27T15:04:19.955Z 2025-12-29T15:24:33.587Z
9019421 9019421 20251220094845_5HFgV US004J 2025-12-27T15:04:18.004Z 2025-12-29T15:24:33.564Z
9019251 9019251 20251220092448_odPun US004J 2025-12-27T15:03:45.056Z 2025-12-29T15:24:30.925Z
9019209 9019209 20251220091532_IMC51 US004J 2025-12-27T15:03:29.643Z 2025-12-27T15:03:29.643Z
9018908 9018908 20251220082208_aGYnA US004J 2025-12-27T15:02:51.997Z 2025-12-29T15:24:26.551Z
9018535 9018535 20251220070826_t1Xul US004J 2025-12-27T15:02:40.209Z 2025-12-29T15:23:42.564Z
9007425 9007425 20251221094512_qCoyP US004J 2025-12-27T14:40:23.572Z 2025-12-27T14:40:23.572Z
9001964 9001964 20251222105813_ZHAY3 US004J 2025-12-27T14:23:41.052Z 2025-12-30T15:48:03.562Z
9001940 9001940 20251222105611_5WVD3 US004J 2025-12-27T14:23:37.336Z 2025-12-30T15:48:03.279Z
9001709 9001709 20251222103438_R5Iu4 US004J 2025-12-27T14:22:59.946Z 2025-12-28T15:01:08.390Z
9001645 9001645 20251222102913_Ygiyt US004J 2025-12-27T14:22:40.044Z 2025-12-30T15:48:00.135Z
9001639 9001639 20251222102839_V6CFq US004J 2025-12-27T14:22:39.566Z 2025-12-30T15:48:00.068Z
9001529 9001529 20251222101953_CIsny US004J 2025-12-27T14:22:21.044Z 2025-12-30T15:47:59.002Z
9001048 9001048 20251222094407_4NrXN US004J 2025-12-27T14:21:07.891Z 2025-12-30T15:47:54.333Z
9000983 9000983 20251222094142_lr4mr US004J 2025-12-27T14:20:48.262Z 2025-12-30T15:47:53.706Z
9000964 9000964 20251222093952_qhekE US004J 2025-12-27T14:20:46.062Z 2025-12-30T15:47:53.556Z
9000515 9000515 20251222090735_yRQuQ US004J 2025-12-27T14:19:41.788Z 2025-12-30T15:47:49.164Z
9000486 9000486 20251222090630_0NipH US004J 2025-12-27T14:19:23.995Z 2025-12-30T15:47:48.893Z
9000472 9000472 20251222090502_NTSBE US004J 2025-12-27T14:19:20.447Z 2025-12-30T15:47:48.718Z
9000444 9000444 20251222090345_1pDZ1 US004J 2025-12-27T14:19:16.469Z 2025-12-30T15:47:48.385Z
9000359 9000359 20251222085917_Lfeo9 US004J 2025-12-27T14:19:08.872Z 2025-12-30T15:47:47.902Z
9000267 9000267 20251222085302_gJGW0 US004J 2025-12-27T14:19:02.115Z 2025-12-28T15:00:21.702Z
8999899 8999899 20251222082900_tA3v7 US004J 2025-12-27T14:18:11.230Z 2025-12-30T15:47:43.417Z
8999746 8999746 20251222081343_6Q8tE US004J 2025-12-27T14:17:43.183Z 2025-12-30T15:47:40.860Z
8999711 8999711 20251222081037_3gDOU US004J 2025-12-27T14:17:38.927Z 2025-12-28T15:00:07.993Z
8999441 8999441 20251222074137_wsGYG US004J 2025-12-27T14:16:46.203Z 2025-12-28T15:00:01.899Z
8999300 8999300 20251222073003_xA2lr US004J 2025-12-27T14:16:18.520Z 2025-12-28T14:59:38.650Z
8988871 8988871 20251218110133_i3ZuP US004J 2025-12-26T14:43:13.638Z 2025-12-26T14:43:13.638Z
8988610 8988610 20251218103507_3NkJY US004J 2025-12-26T14:42:37.324Z 2025-12-27T15:21:51.559Z
8988578 8988578 20251218103229_s4p39 US004J 2025-12-26T14:42:34.599Z 2025-12-27T15:21:50.200Z
8988576 8988576 20251218103208_MjSju US004J 2025-12-26T14:42:34.374Z 2025-12-27T15:21:50.084Z
8988289 8988289 20251218100735_CVpEA US004J 2025-12-26T14:42:00.992Z 2025-12-27T15:21:32.359Z
8988128 8988128 20251218095053_qnekN US004J 2025-12-26T14:41:45.887Z 2025-12-26T14:41:45.887Z
8988091 8988091 20251218094732_M67e7 US004J 2025-12-26T14:41:33.308Z 2025-12-26T14:41:33.308Z
8988089 8988089 20251218094723_81P2X US004J 2025-12-26T14:41:33.015Z 2025-12-26T14:41:33.015Z
8987792 8987792 20251218091820_WU5xs US004J 2025-12-26T14:41:09.014Z 2025-12-27T15:21:01.280Z
8987782 8987782 20251218091621_EYeaU US004J 2025-12-26T14:41:07.875Z 2025-12-27T15:21:00.251Z
8987678 8987678 20251218085905_gHJ4K US004J 2025-12-26T14:40:48.005Z 2025-12-27T15:20:49.849Z
8987406 8987406 20251218082503_Sue50 US004J 2025-12-26T14:40:12.078Z 2025-12-27T15:20:19.933Z
8987344 8987344 20251218081149_MDWgx US004J 2025-12-26T14:40:04.742Z 2025-12-27T15:20:13.939Z

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