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

7,013 rows where station_code = "US002A" 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
8683943 8683943 20251204094050_Mh41d US002A 2025-12-05T14:01:13.316Z 2025-12-06T14:18:00.375Z
8683926 8683926 20251204092802_99dTJ US002A 2025-12-05T14:01:05.770Z 2025-12-06T14:18:00.369Z
8683879 8683879 20251204091017_i202K US002A 2025-12-05T14:00:59.054Z 2025-12-06T14:18:00.358Z
8674720 8674720 20251202031059_dpqE6 US002A 2025-12-03T14:22:14.715Z 2025-12-06T14:34:16.538Z
8674055 8674055 20251202012234_wx2Wg US002A 2025-12-03T14:20:51.984Z 2025-12-06T14:33:47.515Z
8671802 8671802 20251201130146_xsWJI US002A 2025-12-03T14:13:50.345Z 2025-12-06T14:31:20.186Z
8671760 8671760 20251201125618_Tf25p US002A 2025-12-03T14:13:40.130Z 2025-12-06T14:31:18.994Z
8671647 8671647 20251201124528_f1q4C US002A 2025-12-03T14:13:15.083Z 2025-12-06T14:31:14.678Z
8671504 8671504 20251201122658_f9Yac US002A 2025-12-03T14:12:47.802Z 2025-12-06T14:31:09.142Z
8671465 8671465 20251201122200_uWkpB US002A 2025-12-03T14:12:41.798Z 2025-12-06T14:31:07.750Z
8671437 8671437 20251201121907_56Q0J US002A 2025-12-03T14:12:28.671Z 2025-12-06T14:31:06.687Z
8671419 8671419 20251201121526_ZG02b US002A 2025-12-03T14:12:25.988Z 2025-12-06T14:31:04.953Z
8671361 8671361 20251201120613_GBzL3 US002A 2025-12-03T14:12:15.092Z 2025-12-06T14:30:56.684Z
8671338 8671338 20251201120349_ANjx9 US002A 2025-12-03T14:12:12.172Z 2025-12-06T14:30:55.992Z
8671319 8671319 20251201120011_5kvRC US002A 2025-12-03T14:12:09.170Z 2025-12-06T14:30:54.744Z
8671279 8671279 20251201115119_9WpAi US002A 2025-12-03T14:12:03.063Z 2025-12-06T14:30:50.656Z
8671277 8671277 20251201115105_8lZ3M US002A 2025-12-03T14:12:02.694Z 2025-12-06T14:30:50.485Z
8671263 8671263 20251201114936_6YNd2 US002A 2025-12-03T14:11:57.382Z 2025-12-06T14:30:49.830Z
8671239 8671239 20251201114445_r8P7m US002A 2025-12-03T14:11:53.201Z 2025-12-06T14:30:48.561Z
8671115 8671115 20251201111358_PEQqh US002A 2025-12-03T14:11:16.825Z 2025-12-06T14:30:44.036Z
8670822 8670822 20251201102207_T5OuG US002A 2025-12-03T14:10:17.575Z 2025-12-06T14:30:25.512Z
8670769 8670769 20251201100854_c6CsK US002A 2025-12-03T14:10:02.059Z 2025-12-06T14:30:21.104Z
8670757 8670757 20251201100819_r0MfT US002A 2025-12-03T14:10:00.782Z 2025-12-06T14:30:20.684Z
8670670 8670670 20251201095510_ksmS6 US002A 2025-12-03T14:09:41.602Z 2025-12-06T14:30:15.410Z
8670630 8670630 20251201095015_Pjrtt US002A 2025-12-03T14:09:36.486Z 2025-12-06T14:30:13.077Z
8670628 8670628 20251201094848_vfzml US002A 2025-12-03T14:09:36.119Z 2025-12-06T14:30:13.020Z
8670538 8670538 20251201091932_vSjF3 US002A 2025-12-03T14:09:09.056Z 2025-12-06T14:30:08.476Z
8670483 8670483 20251201090535_sZOMA US002A 2025-12-03T14:08:59.047Z 2025-12-06T14:29:59.919Z
8670399 8670399 20251201083733_MyLh3 US002A 2025-12-03T14:08:32.552Z 2025-12-06T14:29:56.443Z
8670380 8670380 20251201081007_SWFWP US002A 2025-12-03T14:08:27.913Z 2025-12-06T14:29:53.845Z
8668227 8668227 20251130065243_rwdDp US002A 2025-12-02T14:42:13.176Z 2025-12-06T14:50:27.824Z
8668198 8668198 20251130063738_Vrruf US002A 2025-12-02T14:42:10.574Z 2025-12-06T14:50:26.430Z
8668043 8668043 20251130054410_QjLkr US002A 2025-12-02T14:41:31.995Z 2025-12-06T14:50:01.043Z
8667433 8667433 20251130011850_bhq7i US002A 2025-12-02T14:38:08.428Z 2025-12-06T14:47:39.092Z
8666908 8666908 20251201070908_4VAFN US002A 2025-12-02T14:30:43.513Z 2025-12-06T14:42:43.075Z
8659917 8659917 20251130113007_7ujdB US002A 2025-12-02T14:05:49.052Z 2025-12-06T14:36:47.144Z
8659826 8659826 20251130111950_Cc3yk US002A 2025-12-02T14:05:25.946Z 2025-12-06T14:36:43.622Z
8659794 8659794 20251130111634_3uerq US002A 2025-12-02T14:05:20.115Z 2025-12-06T14:36:42.208Z
8659603 8659603 20251130105433_9a30C US002A 2025-12-02T14:04:37.422Z 2025-12-06T14:36:24.851Z
8659566 8659566 20251130104912_sbQFO US002A 2025-12-02T14:04:30.494Z 2025-12-06T14:36:23.707Z
8659508 8659508 20251130103846_rXAJp US002A 2025-12-02T14:04:14.138Z 2025-12-06T14:36:22.306Z
8659194 8659194 20251130094411_Pnfnw US002A 2025-12-02T14:02:53.818Z 2025-12-06T14:36:10.269Z
8659076 8659076 20251130092923_FGU8p US002A 2025-12-02T14:02:27.876Z 2025-12-06T14:36:05.538Z
8658853 8658853 20251130083645_CoINm US002A 2025-12-02T14:01:13.064Z 2025-12-06T14:35:43.482Z
8658821 8658821 20251130082649_29i4y US002A 2025-12-02T14:01:00.750Z 2025-12-06T14:35:42.190Z
8658809 8658809 20251130081234_Zyms1 US002A 2025-12-02T14:00:56.987Z 2025-12-06T14:35:41.888Z
8626297 8626297 20251126084655_R6h5Y US002A 2025-11-28T14:38:36.456Z 2025-12-04T15:12:11.309Z
8626222 8626222 20251126081838_GsyrV US002A 2025-11-28T14:38:12.665Z 2025-12-04T15:12:01.340Z
8626198 8626198 20251126081048_r3mUw US002A 2025-11-28T14:38:08.989Z 2025-12-04T15:11:59.442Z
8626194 8626194 20251126080928_MCUt1 US002A 2025-11-28T14:38:08.164Z 2025-12-04T15:11:59.360Z
8626134 8626134 20251126074811_AqTpm US002A 2025-11-28T14:37:47.020Z 2025-12-04T15:11:53.428Z
8626113 8626113 20251126073753_ts93G US002A 2025-11-28T14:37:42.403Z 2025-12-04T15:11:52.743Z
8626104 8626104 20251126073601_iTIHZ US002A 2025-11-28T14:37:40.958Z 2025-12-04T15:11:52.591Z
8626101 8626101 20251126073527_RaTMo US002A 2025-11-28T14:37:40.503Z 2025-12-04T15:11:52.456Z
8626087 8626087 20251126072929_gDklc US002A 2025-11-28T14:37:38.916Z 2025-12-04T15:11:52.156Z
8625999 8625999 20251126065551_EQadT US002A 2025-11-28T14:37:30.358Z 2025-12-04T15:11:49.712Z
8625991 8625991 20251126065251_ftSY2 US002A 2025-11-28T14:37:28.970Z 2025-12-04T15:11:49.470Z
8625982 8625982 20251126064928_F22gd US002A 2025-11-28T14:37:28.338Z 2025-12-04T15:11:49.140Z
8625964 8625964 20251126064608_sk26p US002A 2025-11-28T14:37:27.696Z 2025-12-04T15:11:45.344Z
8625915 8625915 20251126062446_ATgHv US002A 2025-11-28T14:37:23.811Z 2025-12-04T15:11:42.971Z
8625914 8625914 20251126062427_f9lf9 US002A 2025-11-28T14:37:23.666Z 2025-12-04T15:11:42.899Z
8625841 8625841 20251126055421_bR8UZ US002A 2025-11-28T14:37:15.658Z 2025-12-04T15:11:38.598Z
8625829 8625829 20251126054418_RLJvk US002A 2025-11-28T14:37:12.347Z 2025-12-04T15:11:36.586Z
8625813 8625813 20251126053644_3nLCq US002A 2025-11-28T14:37:10.169Z 2025-12-04T15:11:35.318Z
8625794 8625794 20251126052448_nzLhH US002A 2025-11-28T14:36:36.093Z 2025-12-04T15:11:33.128Z
8625787 8625787 20251126051914_wO2Fh US002A 2025-11-28T14:36:30.869Z 2025-12-04T15:11:32.461Z
8625765 8625765 20251126050149_Yh51C US002A 2025-11-28T14:36:23.649Z 2025-12-04T15:11:28.544Z
8625737 8625737 20251126044151_vkyCk US002A 2025-11-28T14:36:17.022Z 2025-12-04T15:11:25.320Z
8625694 8625694 20251126042124_NUqr0 US002A 2025-11-28T14:36:08.751Z 2025-12-04T15:10:56.944Z
8625680 8625680 20251126041415_xLBaP US002A 2025-11-28T14:36:05.942Z 2025-12-04T15:10:44.733Z
8625634 8625634 20251126034753_QSXb3 US002A 2025-11-28T14:35:27.101Z 2025-12-04T15:10:11.482Z
8625591 8625591 20251126032512_yZD6p US002A 2025-11-28T14:35:17.431Z 2025-12-04T15:09:49.566Z
8625409 8625409 20251126003147_bbTrw US002A 2025-11-28T14:33:18.990Z 2025-12-04T15:08:03.684Z
8620142 8620142 20251126115419_Ix3Vd US002A 2025-11-28T14:11:53.057Z 2025-12-05T15:01:31.982Z
8620062 8620062 20251126114013_wfP73 US002A 2025-11-28T14:11:31.026Z 2025-12-05T15:01:25.602Z
8620043 8620043 20251126113826_IYHYK US002A 2025-11-28T14:11:29.121Z 2025-12-05T15:01:25.302Z
8619908 8619908 20251126111410_P8Clh US002A 2025-11-28T14:10:57.704Z 2025-12-05T15:01:11.466Z
8619906 8619906 20251126111405_ZMbpX US002A 2025-11-28T14:10:57.274Z 2025-12-05T15:01:11.407Z
8619674 8619674 20251126104544_q7YfH US002A 2025-11-28T14:09:56.208Z 2025-12-05T15:01:04.445Z
8619644 8619644 20251126104003_sMFqR US002A 2025-11-28T14:09:50.519Z 2025-12-05T15:01:03.769Z
8619513 8619513 20251126102035_OkOps US002A 2025-11-28T14:09:15.700Z 2025-12-05T15:01:00.617Z
8619462 8619462 20251126101326_Lf1ck US002A 2025-11-28T14:08:57.327Z 2025-12-05T15:00:59.219Z
8619285 8619285 20251126094239_KxpWI US002A 2025-11-28T14:08:14.852Z 2025-12-05T15:00:55.510Z
8619239 8619239 20251126093356_X6oak US002A 2025-11-28T14:08:03.761Z 2025-12-05T15:00:54.235Z
8619229 8619229 20251126093210_23F72 US002A 2025-11-28T14:07:55.395Z 2025-12-05T15:00:53.872Z
8617393 8617393 20251127091857_de4UP US002A 2025-11-28T14:00:40.917Z 2025-12-06T14:57:58.259Z
8593779 8593779 20251125124957_2sOfS US002A 2025-11-26T14:03:21.771Z 2025-12-04T15:05:24.163Z
8593714 8593714 20251125123213_TwodY US002A 2025-11-26T14:03:13.578Z 2025-12-04T15:05:23.082Z
8593664 8593664 20251125121918_BBKmQ US002A 2025-11-26T14:03:00.185Z 2025-12-04T15:05:22.159Z
8593589 8593589 20251125120259_UU2Gz US002A 2025-11-26T14:02:45.556Z 2025-12-04T15:05:20.583Z
8593553 8593553 20251125115558_ssn7n US002A 2025-11-26T14:02:31.956Z 2025-12-04T15:05:19.850Z
8593263 8593263 20251125105503_BHxZy US002A 2025-11-26T14:01:35.767Z 2025-12-04T15:05:14.763Z
8593156 8593156 20251125102420_S8kny US002A 2025-11-26T14:01:07.394Z 2025-12-04T15:05:12.567Z
8589166 8589166 20251124011051_Dg2Gk US002A 2025-11-25T14:19:21.708Z 2025-12-02T15:12:10.399Z
8584572 8584572 20251123124206_Sy7qP US002A 2025-11-25T14:06:49.451Z 2025-12-02T15:09:50.483Z
8584569 8584569 20251123124110_2Gg8h US002A 2025-11-25T14:06:48.974Z 2025-12-02T15:09:50.452Z
8584442 8584442 20251123121347_mfBTa US002A 2025-11-25T14:06:21.849Z 2025-12-02T15:09:48.718Z
8584260 8584260 20251123112931_8R9Oc US002A 2025-11-25T14:05:46.690Z 2025-12-02T15:09:47.375Z
8584228 8584228 20251123111926_fj4lb US002A 2025-11-25T14:05:42.792Z 2025-12-02T15:09:47.166Z
8583844 8583844 20251123095533_EGoBK US002A 2025-11-25T14:04:12.592Z 2025-12-02T15:09:43.163Z

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