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

166 rows where station_code = "US004V" 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
9264776 9264776 20260127130939_UknQm US004V 2026-01-28T14:07:34.403Z 2026-01-30T14:28:19.972Z
9209831 9209831 20260115110348_oP4yI US004V 2026-01-16T14:17:41.402Z 2026-01-22T15:05:37.287Z
9204556 9204556 20260114070540_IFw85 US004V 2026-01-15T14:27:35.406Z 2026-01-22T15:10:41.763Z
9178591 9178591 20260110132829_hlmxO US004V 2026-01-11T14:15:16.771Z 2026-01-18T15:11:07.633Z
9089654 9089654 20251228133343_DP73m US004V 2025-12-30T14:48:49.599Z 2026-01-05T15:12:49.922Z
9088775 9088775 20251228122156_8Yu6e US004V 2025-12-30T14:47:05.508Z 2026-01-05T15:12:12.489Z
9082204 9082204 20251229122441_IwW1n US004V 2025-12-30T14:28:21.110Z 2026-01-06T15:20:01.994Z
8967476 8967476 20251216132855_OuULC US004V 2025-12-25T14:47:36.028Z 2025-12-25T14:47:36.028Z
8966267 8966267 20251216115719_ZkGjI US004V 2025-12-25T14:45:39.608Z 2025-12-25T14:45:39.608Z
8964246 8964246 20251216080222_NSFXG US004V 2025-12-25T14:41:11.477Z 2025-12-25T14:41:11.477Z
8804812 8804812 20251213091558_s3jy3 US004V 2025-12-16T14:17:44.129Z 2025-12-23T14:20:11.659Z
8804490 8804490 20251213085338_uJ6tT US004V 2025-12-16T14:17:01.455Z 2025-12-23T14:19:56.477Z
8804379 8804379 20251213084718_8nUJY US004V 2025-12-16T14:16:56.659Z 2025-12-23T14:19:54.980Z
8802752 8802752 20251213065424_fNHDW US004V 2025-12-16T14:15:03.221Z 2025-12-23T14:19:26.217Z
8763060 8763060 20251212131800_Jcgqs US004V 2025-12-14T14:44:50.469Z 2025-12-21T14:17:25.067Z
8763027 8763027 20251212131718_g2H4C US004V 2025-12-14T14:44:48.779Z 2025-12-21T14:17:25.058Z
8762917 8762917 20251212131332_r3d01 US004V 2025-12-14T14:44:31.911Z 2025-12-21T14:17:25.025Z
8762844 8762844 20251212131011_9FUNu US004V 2025-12-14T14:44:11.640Z 2025-12-21T14:17:24.992Z
8757866 8757866 20251212073414_ljzU2 US004V 2025-12-14T14:13:25.028Z 2025-12-21T14:17:21.942Z
8724819 8724819 20251211113413_WEcpM US004V 2025-12-12T14:16:19.017Z 2025-12-20T14:23:32.374Z
8723227 8723227 20251211092807_h4lYL US004V 2025-12-12T14:11:37.098Z 2025-12-20T14:22:50.738Z
8718794 8718794 20251210125227_3UYqj US004V 2025-12-11T14:18:12.967Z 2025-12-19T15:09:15.566Z
8718231 8718231 20251210121348_q93dE US004V 2025-12-11T14:16:34.569Z 2025-12-19T15:08:59.285Z
8717648 8717648 20251210113025_b4UBR US004V 2025-12-11T14:14:36.896Z 2025-12-19T15:08:27.763Z
8716359 8716359 20251210093826_IJjc6 US004V 2025-12-11T14:10:29.308Z 2025-12-19T15:07:26.311Z
8710269 8710269 20251209102500_5v1B8 US004V 2025-12-10T14:04:31.525Z 2025-12-17T15:24:01.346Z
8702706 8702706 20251208114925_1bPXc US004V 2025-12-09T14:09:23.169Z 2025-12-17T15:31:35.354Z
8692229 8692229 20251206093711_JS4YO US004V 2025-12-07T14:02:18.845Z 2025-12-15T15:28:13.435Z
8688974 8688974 20251205132938_mGd2j US004V 2025-12-06T14:06:38.019Z 2025-12-14T16:06:02.161Z
8688903 8688903 20251205131041_bPCji US004V 2025-12-06T14:06:15.985Z 2025-12-14T16:06:00.326Z
8688550 8688550 20251205115827_k8ZY9 US004V 2025-12-06T14:04:54.763Z 2025-12-14T16:05:42.054Z
8668650 8668650 20251202080911_yEQm2 US004V 2025-12-03T14:00:42.986Z 2025-12-11T14:42:14.900Z
8627355 8627355 20251128105304_EGydU US004V 2025-11-29T14:03:24.599Z 2025-12-07T14:52:58.155Z
8626979 8626979 20251128100735_hXEfA US004V 2025-11-29T14:02:12.013Z 2025-12-07T14:52:49.513Z
8619769 8619769 20251126105706_eB2mC US004V 2025-11-28T14:10:20.177Z 2025-12-05T15:01:08.557Z
8618087 8618087 20251127113009_jkFaM US004V 2025-11-28T14:03:23.711Z 2025-12-06T14:58:34.613Z
8584212 8584212 20251123111713_QZP0B US004V 2025-11-25T14:05:40.345Z 2025-12-02T15:09:46.989Z
8417252 8417252 20251110114722_U3LxU US004V 2025-11-11T14:27:53.481Z 2025-11-18T15:21:59.920Z
8406853 8406853 20251109082106_2Tu7r US004V 2025-11-10T14:17:50.800Z 2025-11-17T14:59:16.590Z
8405903 8405903 20251109044510_PTY2Q US004V 2025-11-10T14:15:21.743Z 2025-11-17T14:59:05.084Z
8405656 8405656 20251109040327_icLnw US004V 2025-11-10T14:14:43.590Z 2025-11-17T14:59:03.873Z
8399939 8399939 20251108101459_yWGYS US004V 2025-11-09T14:19:31.171Z 2025-11-16T15:05:55.612Z
8399815 8399815 20251108095730_BfUAQ US004V 2025-11-09T14:19:11.129Z 2025-11-16T15:05:54.771Z
8398587 8398587 20251108050523_YMQh2 US004V 2025-11-09T14:15:52.934Z 2025-11-16T15:04:55.236Z
8347375 8347375 20251101095133_srVEq US004V 2025-11-02T14:46:20.769Z 2025-11-02T14:46:20.769Z
8327144 8327144 20251030104528_HsAc5 US004V 2025-11-01T12:36:45.587Z 2025-11-07T15:18:48.453Z
8325562 8325562 20251030080254_BD1mK US004V 2025-11-01T12:34:14.940Z 2025-11-07T15:17:24.978Z
8308389 8308389 20251029110116_28VBo US004V 2025-10-31T12:29:24.717Z 2025-11-06T15:16:03.806Z
8204712 8204712 20251023111200_dc7OL US004V 2025-10-25T12:28:00.069Z 2025-10-31T13:09:14.486Z
8203993 8203993 20251023100109_3ZZ3k US004V 2025-10-25T12:26:19.015Z 2025-10-31T13:09:03.417Z
8185925 8185925 20251021102025_GoUDV US004V 2025-10-23T12:36:33.011Z 2025-10-29T13:08:13.516Z
8150555 8150555 20251019110034_Y3Qus US004V 2025-10-20T12:30:50.910Z 2025-10-27T13:11:26.691Z
8139040 8139040 20251017104457_tzCI0 US004V 2025-10-19T12:32:56.330Z 2025-10-25T13:31:17.028Z
8135926 8135926 20251018074301_yalO2 US004V 2025-10-19T12:18:46.196Z 2025-10-26T13:16:10.968Z
8116294 8116294 20251016110357_8Z6Cc US004V 2025-10-17T12:19:22.077Z 2025-10-24T13:17:10.676Z
8115883 8115883 20251016101051_sNgDY US004V 2025-10-17T12:18:44.954Z 2025-10-24T13:17:08.004Z
8108366 8108366 20251016124523_kvrEi US004V 2025-10-17T12:00:51.416Z 2025-10-17T12:00:51.416Z
8088985 8088985 20251012095028_FFlQ8 US004V 2025-10-13T12:15:11.258Z 2025-10-20T13:04:08.941Z
8083947 8083947 20251012112847_R2h5I US004V 2025-10-13T12:00:51.390Z 2025-10-21T13:08:13.563Z
8080538 8080538 20251011124844_sihu2 US004V 2025-10-12T12:00:56.495Z 2025-10-20T13:02:27.330Z
8063740 8063740 20251004105907_7ZVaB US004V 2025-10-07T12:26:41.795Z 2025-10-13T12:32:41.006Z
8053529 8053529 20251003104917_v0lvy US004V 2025-10-05T12:05:47.668Z 2025-10-12T12:30:39.669Z
7027180 7027180 20250703061109_0niei US004V 2025-07-04T12:07:00.344Z 2025-07-12T12:57:21.017Z
6916517 6916517 20250618075115_VbgLS US004V 2025-06-19T12:19:48.630Z 2025-06-26T12:36:50.773Z
6911910 6911910 20250618084009_RWU7C US004V 2025-06-19T12:00:39.557Z 2025-06-27T12:39:11.722Z
6870280 6870280 20250607093106_OUc8Q US004V 2025-06-08T12:06:43.046Z 2025-06-15T12:27:22.983Z
6869769 6869769 20250607072427_QqazM US004V 2025-06-08T12:05:14.413Z 2025-06-15T12:27:08.629Z
6838918 6838918 20250531105140_ykmW3 US004V 2025-06-01T12:22:27.347Z 2025-06-08T12:32:56.485Z
6702094 6702094 20250510113028_LAC5o US004V 2025-05-11T12:13:30.757Z 2025-05-18T12:34:49.839Z
6702000 6702000 20250510111154_vx8au US004V 2025-05-11T12:13:23.730Z 2025-05-18T12:34:48.119Z
6680153 6680153 20250507085542_L82VU US004V 2025-05-08T12:18:43.193Z 2025-05-15T12:38:05.774Z
6546493 6546493 20250422042805_BuMbC US004V 2025-04-23T12:22:03.117Z 2025-04-30T12:41:39.823Z
6502718 6502718 20250411101921_W0CsN US004V 2025-04-12T12:06:46.719Z 2025-04-19T12:25:23.743Z
6502641 6502641 20250411100538_pi3yc US004V 2025-04-12T12:06:26.453Z 2025-04-19T12:25:21.393Z
6491251 6491251 20250409063744_rNTek US004V 2025-04-10T12:05:47.234Z 2025-04-17T12:23:00.733Z
6478066 6478066 20250406105922_2RqHf US004V 2025-04-08T12:22:22.730Z 2025-04-14T12:30:57.881Z
6477706 6477706 20250406090521_vgRWF US004V 2025-04-08T12:21:27.897Z 2025-04-14T12:30:47.972Z
6477491 6477491 20250406071145_IJP9G US004V 2025-04-08T12:20:54.002Z 2025-04-14T12:30:42.538Z
6429573 6429573 20250401114604_5Y3IZ US004V 2025-04-02T12:21:39.805Z 2025-04-09T12:26:41.973Z
6429571 6429571 20250401114549_u9lfP US004V 2025-04-02T12:21:38.908Z 2025-04-09T12:26:41.968Z
6393934 6393934 20250325123713_rDQNZ US004V 2025-03-27T12:21:15.463Z 2025-04-02T13:38:06.772Z
6385155 6385155 20250325041946_8EQmg US004V 2025-03-26T12:09:53.742Z 2025-04-02T13:35:23.722Z
6380427 6380427 20250324113345_gpcNk US004V 2025-03-25T12:09:54.896Z 2025-04-01T13:01:41.349Z
6376285 6376285 20250323081318_NdiTt US004V 2025-03-24T12:07:35.099Z 2025-03-31T13:06:34.561Z
6375845 6375845 20250323051620_CLclO US004V 2025-03-24T12:06:15.133Z 2025-03-31T13:06:07.271Z
6361353 6361353 20250321081707_qDVJR US004V 2025-03-22T12:16:19.533Z 2025-03-29T13:17:03.786Z
6346404 6346404 20250319105039_ws1x1 US004V 2025-03-20T12:20:30.105Z 2025-03-27T13:11:16.556Z
6345815 6345815 20250319084529_L4NGm US004V 2025-03-20T12:19:08.591Z 2025-03-27T13:10:39.287Z
6309653 6309653 20250312071421_PkSV6 US004V 2025-03-13T12:07:09.096Z 2025-03-20T12:43:50.306Z
6305913 6305913 20250310122240_oiDC0 US004V 2025-03-11T12:19:14.487Z 2025-03-17T12:34:29.441Z
6304633 6304633 20250310083223_Z93gz US004V 2025-03-11T12:15:19.719Z 2025-03-17T12:33:43.018Z
6303929 6303929 20250310031842_T1SoM US004V 2025-03-11T12:12:25.256Z 2025-03-18T12:39:50.392Z
6289581 6289581 20250308124719_ZfOwO US004V 2025-03-09T12:18:47.235Z 2025-03-16T12:31:18.438Z
6289495 6289495 20250308123736_BoQ4F US004V 2025-03-09T12:18:29.513Z 2025-03-16T12:31:17.468Z
6197359 6197359 20250228093527_0Thhv US004V 2025-03-01T14:24:03.029Z 2025-03-06T14:38:56.501Z
6196873 6196873 20250228075719_4abeu US004V 2025-03-01T14:22:17.001Z 2025-03-08T15:25:48.017Z
6186595 6186595 20250227103407_WPgcs US004V 2025-02-28T14:19:23.391Z 2025-03-07T16:59:29.111Z
6185891 6185891 20250227082818_gVXiL US004V 2025-02-28T14:16:56.403Z 2025-03-07T16:58:30.166Z
6185458 6185458 20250227060251_0vjA6 US004V 2025-02-28T14:15:22.037Z 2025-03-07T16:57:39.100Z
6184587 6184587 20250227041529_u3Pcj US004V 2025-02-28T14:12:43.076Z 2025-03-07T16:56:11.954Z

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