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

2,986 rows where station_code = "UK005J" 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
9217656 9217656 20260116185513_U4Z31 UK005J 2026-01-18T14:08:23.253Z 2026-01-25T14:57:35.477Z
9217550 9217550 20260116174249_gZs3W UK005J 2026-01-18T14:07:51.091Z 2026-01-25T14:57:25.593Z
9214508 9214508 20260116064616_Kui6v UK005J 2026-01-17T14:21:49.107Z 2026-01-24T15:13:45.330Z
9214404 9214404 20260116062817_uyKA1 UK005J 2026-01-17T14:21:21.642Z 2026-01-24T15:13:35.027Z
9214316 9214316 20260116061503_h2LSN UK005J 2026-01-17T14:21:03.397Z 2026-01-24T15:13:29.650Z
9213371 9213371 20260116031843_hYHva UK005J 2026-01-17T14:16:39.421Z 2026-01-24T15:12:11.137Z
9213111 9213111 20260116021530_tEcLJ UK005J 2026-01-17T14:15:29.255Z 2026-01-24T15:11:42.225Z
9212634 9212634 20260115235332_3kZyQ UK005J 2026-01-17T14:13:03.329Z 2026-01-24T15:11:07.975Z
9212498 9212498 20260115221847_osoZZ UK005J 2026-01-17T14:12:15.103Z 2026-01-24T15:10:58.012Z
9212468 9212468 20260115214921_9Z9yc UK005J 2026-01-17T14:12:05.241Z 2026-01-24T15:10:56.452Z
9212435 9212435 20260115212709_VRriW UK005J 2026-01-17T14:11:47.599Z 2026-01-24T15:10:52.784Z
9212324 9212324 20260115203459_iV2Ya UK005J 2026-01-17T14:11:15.713Z 2026-01-24T15:10:47.579Z
9212229 9212229 20260115200327_15dJR UK005J 2026-01-17T14:10:45.430Z 2026-01-24T15:10:42.518Z
9212122 9212122 20260115191805_mReT6 UK005J 2026-01-17T14:10:04.061Z 2026-01-24T15:10:24.955Z
9212015 9212015 20260115184450_QNszs UK005J 2026-01-17T14:09:28.105Z 2026-01-24T15:10:18.923Z
9211827 9211827 20260115175813_GpsIm UK005J 2026-01-17T14:08:40.113Z 2026-01-24T15:09:57.491Z
9202069 9202069 20260114031439_A9zEE UK005J 2026-01-15T14:20:21.979Z 2026-01-22T15:09:12.892Z
9201820 9201820 20260114025731_6xEVw UK005J 2026-01-15T14:19:48.304Z 2026-01-22T15:09:10.194Z
9201114 9201114 20260114014501_bxpUq UK005J 2026-01-15T14:17:34.501Z 2026-01-22T15:08:57.866Z
9199611 9199611 20260113203615_m7IIF UK005J 2026-01-15T14:11:40.056Z 2026-01-22T15:07:47.828Z
9199548 9199548 20260113202118_fqzUp UK005J 2026-01-15T14:11:26.348Z 2026-01-22T15:07:26.596Z
9199397 9199397 20260113195535_3YD2X UK005J 2026-01-15T14:10:41.830Z 2026-01-22T15:07:23.442Z
9199161 9199161 20260113191345_e9oQC UK005J 2026-01-15T14:09:35.057Z 2026-01-22T15:07:15.484Z
9198973 9198973 20260113184321_0Ezk5 UK005J 2026-01-15T14:08:36.260Z 2026-01-22T15:07:10.709Z
9196150 9196150 20260113045715_Tqloq UK005J 2026-01-14T14:16:52.080Z 2026-01-21T15:05:28.768Z
9171165 9171165 20260108194455_wB7Bu UK005J 2026-01-10T14:05:39.802Z 2026-01-17T15:23:34.891Z
9124268 9124268 20251231053944_wcEQs UK005J 2026-01-02T14:43:48.228Z 2026-01-08T15:11:20.345Z
9123992 9123992 20251231042120_dohfM UK005J 2026-01-02T14:39:30.812Z 2026-01-08T15:09:56.222Z
9122081 9122081 20260101042619_y1PFj UK005J 2026-01-02T14:11:01.726Z 2026-01-09T14:52:59.841Z
9121650 9121650 20260101011143_fTGQZ UK005J 2026-01-02T14:08:29.934Z 2026-01-09T14:52:25.686Z
9116915 9116915 20251231072500_yGvZT UK005J 2026-01-01T14:29:26.372Z 2026-01-08T15:12:17.113Z
9116491 9116491 20251231061436_wymme UK005J 2026-01-01T14:28:07.600Z 2026-01-08T15:11:50.201Z
9115566 9115566 20251231051556_67OgB UK005J 2026-01-01T14:25:47.594Z 2026-01-08T15:10:55.586Z
9115342 9115342 20251231050044_e1Ca7 UK005J 2026-01-01T14:25:06.435Z 2026-01-01T14:57:54.162Z
9115032 9115032 20251231044316_3Qa0c UK005J 2026-01-01T14:24:12.038Z 2026-01-01T14:57:53.945Z
9115016 9115016 20251231044054_9oOFQ UK005J 2026-01-01T14:24:07.822Z 2026-01-08T15:10:19.323Z
9114731 9114731 20251231042829_EClPK UK005J 2026-01-01T14:23:22.395Z 2026-01-08T15:10:07.883Z
9114570 9114570 20251231042119_cyrYl UK005J 2026-01-01T14:22:56.961Z 2026-01-08T15:09:56.061Z
9101338 9101338 20251230000548_LgkDa UK005J 2025-12-31T14:08:00.845Z 2025-12-31T14:29:52.423Z
9043962 9043962 20251224214353_KCJPO UK005J 2025-12-28T14:48:15.406Z 2026-01-01T15:57:25.311Z
9043007 9043007 20251224193109_FovR2 UK005J 2025-12-28T14:46:48.512Z 2025-12-29T15:07:52.457Z
9042128 9042128 20251224171126_7AdPP UK005J 2025-12-28T14:45:08.229Z 2026-01-01T15:56:34.494Z
9031395 9031395 20251225052958_7US8z UK005J 2025-12-28T14:20:49.053Z 2026-01-02T15:45:16.505Z
9031095 9031095 20251225051522_OUV5a UK005J 2025-12-28T14:20:08.156Z 2026-01-02T15:45:05.490Z
9029901 9029901 20251225042056_ojGbf UK005J 2025-12-28T14:17:30.948Z 2026-01-02T15:44:47.497Z
9029107 9029107 20251225033443_EHeWC UK005J 2025-12-28T14:15:38.926Z 2026-01-02T15:44:16.529Z
9028742 9028742 20251225031942_gG3mN UK005J 2025-12-28T14:14:43.048Z 2026-01-02T15:44:11.735Z
9028124 9028124 20251225024945_BLwy5 UK005J 2025-12-28T14:13:08.095Z 2025-12-29T14:55:13.950Z
9027721 9027721 20251225022957_maUC4 UK005J 2025-12-28T14:11:59.493Z 2025-12-29T14:55:08.657Z
9027166 9027166 20251225020350_259Dd UK005J 2025-12-28T14:10:20.460Z 2025-12-29T14:55:01.383Z
9026739 9026739 20251225013014_12MpA UK005J 2025-12-28T14:08:52.324Z 2026-01-02T15:43:01.319Z
9025842 9025842 20251225003326_45MBS UK005J 2025-12-28T14:06:01.250Z 2026-01-02T15:42:44.298Z
9025822 9025822 20251225003036_QQ2xp UK005J 2025-12-28T14:05:49.213Z 2025-12-29T14:54:10.283Z
9025295 9025295 20251224235008_X0v6s UK005J 2025-12-28T14:04:06.690Z 2026-01-02T15:42:14.939Z
9023807 9023807 20251220222153_UvH45 UK005J 2025-12-27T15:09:45.849Z 2025-12-29T15:26:22.981Z
9017803 9017803 20251220055139_LbmiQ UK005J 2025-12-27T15:01:39.162Z 2025-12-29T15:23:33.767Z
9017716 9017716 20251220054338_OiagP UK005J 2025-12-27T15:01:30.527Z 2025-12-29T15:23:33.208Z
9017468 9017468 20251220052306_ZEmq3 UK005J 2025-12-27T15:01:22.563Z 2025-12-29T15:23:31.478Z
9017164 9017164 20251220045737_J9e3F UK005J 2025-12-27T15:01:11.076Z 2025-12-29T15:23:29.013Z
9017137 9017137 20251220045602_aR1U0 UK005J 2025-12-27T15:01:10.279Z 2025-12-27T15:01:10.279Z
9017082 9017082 20251220045304_UEA7g UK005J 2025-12-27T15:01:07.742Z 2025-12-29T15:23:28.525Z
9016815 9016815 20251220043253_8NI02 UK005J 2025-12-27T15:00:23.840Z 2025-12-29T15:23:26.173Z
9016775 9016775 20251220042855_hkK6Y UK005J 2025-12-27T15:00:13.058Z 2025-12-29T15:23:25.864Z
9016414 9016414 20251220040407_Y6N0T UK005J 2025-12-27T14:59:43.640Z 2025-12-29T15:23:23.106Z
9016397 9016397 20251220040241_smlHy UK005J 2025-12-27T14:59:43.101Z 2025-12-29T15:23:23.080Z
9016378 9016378 20251220040020_PLcjV UK005J 2025-12-27T14:59:42.333Z 2025-12-29T15:23:22.769Z
9016148 9016148 20251220034422_n3JdD UK005J 2025-12-27T14:59:34.634Z 2025-12-29T15:23:21.086Z
8986908 8986908 20251218065657_fMjbw UK005J 2025-12-26T14:39:05.469Z 2025-12-27T15:19:48.491Z
8986734 8986734 20251218063055_aX0Qk UK005J 2025-12-26T14:38:38.289Z 2025-12-26T14:38:38.289Z
8986699 8986699 20251218062449_iVKof UK005J 2025-12-26T14:38:33.288Z 2025-12-26T14:38:33.288Z
8986138 8986138 20251218042900_Wm1fE UK005J 2025-12-26T14:37:04.777Z 2025-12-27T15:19:11.952Z
8986037 8986037 20251218040945_cOgkB UK005J 2025-12-26T14:36:43.483Z 2025-12-27T15:19:10.119Z
8985499 8985499 20251218022004_DC7Kg UK005J 2025-12-26T14:35:08.831Z 2025-12-27T15:19:00.465Z
8985136 8985136 20251218012316_YExIy UK005J 2025-12-26T14:32:38.106Z 2025-12-27T15:18:54.152Z
8984854 8984854 20251220000607_8dXwH UK005J 2025-12-26T14:31:26.959Z 2025-12-28T15:23:55.718Z
8983039 8983039 20251219210839_OhRb1 UK005J 2025-12-26T14:28:25.984Z 2025-12-28T15:23:17.578Z
8982399 8982399 20251219193921_7eUaS UK005J 2025-12-26T14:26:57.801Z 2025-12-27T15:17:03.450Z
8982028 8982028 20251219184405_I8Apx UK005J 2025-12-26T14:26:08.031Z 2025-12-27T15:16:44.976Z
8981395 8981395 20251219172920_C2KoM UK005J 2025-12-26T14:24:38.996Z 2025-12-28T15:21:47.538Z
8977840 8977840 20251219054915_PLzaw UK005J 2025-12-26T14:13:43.322Z 2025-12-26T14:32:01.460Z
8975764 8975764 20251219014942_2lVEw UK005J 2025-12-26T14:07:49.049Z 2025-12-28T15:17:20.106Z
8975654 8975654 20251219014043_Nb4u5 UK005J 2025-12-26T14:07:33.572Z 2025-12-28T15:17:17.222Z
8975481 8975481 20251219011846_x7omF UK005J 2025-12-26T14:07:06.241Z 2025-12-28T15:17:07.191Z
8974228 8974228 20251220021221_eVyJ1 UK005J 2025-12-26T14:04:02.483Z 2025-12-29T15:22:39.877Z
8973510 8973510 20251220012015_N3xMw UK005J 2025-12-26T14:02:28.166Z 2025-12-29T15:22:34.617Z
8973342 8973342 20251220011125_djLoE UK005J 2025-12-26T14:01:57.771Z 2025-12-27T14:56:02.110Z
8972987 8972987 20251220004927_UvL5g UK005J 2025-12-26T14:01:01.657Z 2025-12-29T15:22:31.166Z
8972639 8972639 20251217013835_3mWMX UK005J 2025-12-25T14:55:12.765Z 2025-12-25T14:55:12.765Z
8971728 8971728 20251217003002_JOkTs UK005J 2025-12-25T14:54:11.994Z 2025-12-25T14:54:11.994Z
8971526 8971526 20251217002057_PWxuC UK005J 2025-12-25T14:53:54.318Z 2025-12-25T14:53:54.318Z
8971451 8971451 20251217001558_akGok UK005J 2025-12-25T14:53:51.408Z 2025-12-25T14:53:51.408Z
8971272 8971272 20251216235653_Bpl8D UK005J 2025-12-25T14:53:42.461Z 2025-12-25T14:53:42.461Z
8971100 8971100 20251216234157_xcSD4 UK005J 2025-12-25T14:53:35.906Z 2025-12-25T14:53:35.906Z
8971065 8971065 20251216233750_ZR9OG UK005J 2025-12-25T14:53:33.932Z 2025-12-25T14:53:33.932Z
8970808 8970808 20251216231700_mLbC1 UK005J 2025-12-25T14:53:24.934Z 2025-12-25T14:53:24.934Z
8970794 8970794 20251216231521_EabLj UK005J 2025-12-25T14:53:21.192Z 2025-12-25T14:53:21.192Z
8970699 8970699 20251216230714_33PeR UK005J 2025-12-25T14:52:55.710Z 2025-12-25T14:52:55.710Z
8970650 8970650 20251216230107_iTDFL UK005J 2025-12-25T14:52:53.247Z 2025-12-25T14:52:53.247Z
8970193 8970193 20251216220512_xkBDG UK005J 2025-12-25T14:52:31.672Z 2025-12-25T14:52:31.672Z
8969938 8969938 20251216212518_c2mPg UK005J 2025-12-25T14:51:55.851Z 2025-12-25T14:51:55.851Z

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