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

>10,000 rows count all where station_code = "USL00G" 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
8688754 8688754 20251205123559_fOmNX USL00G 2025-12-06T14:05:40.101Z 2025-12-06T14:05:40.101Z
8688687 8688687 20251205122419_0V934 USL00G 2025-12-06T14:05:25.303Z 2025-12-06T14:05:25.303Z
8688635 8688635 20251205121553_IAo27 USL00G 2025-12-06T14:05:13.847Z 2025-12-06T14:05:13.847Z
8687624 8687624 20251205080623_nYRht USL00G 2025-12-06T14:01:02.846Z 2025-12-06T14:01:02.846Z
8687574 8687574 20251205073618_RHotC USL00G 2025-12-06T14:00:49.004Z 2025-12-06T14:00:49.004Z
8687565 8687565 20251205073317_AZWNZ USL00G 2025-12-06T14:00:46.585Z 2025-12-06T14:00:46.585Z
8687257 8687257 20251204062312_2fIfZ USL00G 2025-12-05T14:14:31.237Z 2025-12-06T14:22:43.251Z
8684466 8684466 20251204124659_eqRJv USL00G 2025-12-05T14:03:25.884Z 2025-12-06T14:18:00.518Z
8684423 8684423 20251204123302_Q2diI USL00G 2025-12-05T14:03:06.506Z 2025-12-06T14:18:00.507Z
8684357 8684357 20251204121708_UTLAg USL00G 2025-12-05T14:02:48.521Z 2025-12-06T14:18:00.487Z
8684228 8684228 20251204113430_b47BF USL00G 2025-12-05T14:02:13.652Z 2025-12-06T14:18:00.446Z
8684153 8684153 20251204105631_ytAL7 USL00G 2025-12-05T14:02:03.177Z 2025-12-06T14:18:00.430Z
8684110 8684110 20251204104601_nYeKg USL00G 2025-12-05T14:01:57.152Z 2025-12-06T14:18:00.418Z
8683925 8683925 20251204092429_5CHkk USL00G 2025-12-05T14:01:05.365Z 2025-12-06T14:18:00.369Z
8683855 8683855 20251204090139_2Px3w USL00G 2025-12-05T14:00:53.097Z 2025-12-06T14:18:00.351Z
8683797 8683797 20251204081707_jeH9p USL00G 2025-12-05T14:00:40.209Z 2025-12-06T14:18:00.333Z
8683793 8683793 20251204081221_IDo7q USL00G 2025-12-05T14:00:39.170Z 2025-12-06T14:18:00.332Z
8683764 8683764 20251204075020_ARYAx USL00G 2025-12-05T14:00:29.878Z 2025-12-06T14:18:00.323Z
8676778 8676778 20251202062416_GNjb3 USL00G 2025-12-03T14:25:34.632Z 2025-12-06T14:35:28.604Z
8676609 8676609 20251202060719_l120E USL00G 2025-12-03T14:25:21.717Z 2025-12-06T14:35:24.630Z
8675265 8675265 20251202042528_WJgxi USL00G 2025-12-03T14:23:25.295Z 2025-12-06T14:34:48.492Z
8674879 8674879 20251202033641_ORwe8 USL00G 2025-12-03T14:22:40.101Z 2025-12-06T14:34:22.039Z
8671902 8671902 20251201131556_LtbeP USL00G 2025-12-03T14:14:07.523Z 2025-12-06T14:31:27.623Z
8671799 8671799 20251201130112_2phFI USL00G 2025-12-03T14:13:49.369Z 2025-12-06T14:31:20.095Z
8671716 8671716 20251201125232_O2UJT USL00G 2025-12-03T14:13:26.612Z 2025-12-06T14:31:17.349Z
8671586 8671586 20251201123635_IL3Lc USL00G 2025-12-03T14:13:03.968Z 2025-12-06T14:31:11.574Z
8671447 8671447 20251201121945_UoQf2 USL00G 2025-12-03T14:12:39.457Z 2025-12-06T14:31:06.998Z
8671373 8671373 20251201120916_HMFNH USL00G 2025-12-03T14:12:17.045Z 2025-12-06T14:30:57.040Z
8671335 8671335 20251201120245_xOh9m USL00G 2025-12-03T14:12:11.458Z 2025-12-06T14:30:55.740Z
8671225 8671225 20251201113913_9DMhc USL00G 2025-12-03T14:11:49.126Z 2025-12-06T14:30:48.028Z
8671215 8671215 20251201113715_BwWAA USL00G 2025-12-03T14:11:47.581Z 2025-12-06T14:30:47.691Z
8671188 8671188 20251201113327_UPAlf USL00G 2025-12-03T14:11:41.547Z 2025-12-06T14:30:46.772Z
8671165 8671165 20251201112724_3QU73 USL00G 2025-12-03T14:11:39.120Z 2025-12-06T14:30:46.140Z
8671156 8671156 20251201112648_8yAzR USL00G 2025-12-03T14:11:28.310Z 2025-12-06T14:30:45.848Z
8671070 8671070 20251201111044_Jjb2r USL00G 2025-12-03T14:11:12.540Z 2025-12-06T14:30:42.334Z
8671003 8671003 20251201110113_trUkS USL00G 2025-12-03T14:11:02.654Z 2025-12-06T14:30:39.275Z
8670933 8670933 20251201104815_r90J7 USL00G 2025-12-03T14:10:45.550Z 2025-12-06T14:30:36.938Z
8670910 8670910 20251201104505_2DlZ1 USL00G 2025-12-03T14:10:41.679Z 2025-12-06T14:30:35.031Z
8670780 8670780 20251201101206_vFcN1 USL00G 2025-12-03T14:10:04.973Z 2025-12-06T14:30:21.711Z
8670778 8670778 20251201101119_uxclb USL00G 2025-12-03T14:10:04.598Z 2025-12-06T14:30:21.610Z
8670770 8670770 20251201101022_9NCKW USL00G 2025-12-03T14:10:02.717Z 2025-12-06T14:30:21.258Z
8670676 8670676 20251201095624_IMT8T USL00G 2025-12-03T14:09:44.511Z 2025-12-06T14:30:15.867Z
8670672 8670672 20251201095526_pTOgs USL00G 2025-12-03T14:09:43.783Z 2025-12-06T14:30:15.701Z
8670627 8670627 20251201094844_ojkIr USL00G 2025-12-03T14:09:35.723Z 2025-12-06T14:30:12.897Z
8670612 8670612 20251201094242_Xkx1G USL00G 2025-12-03T14:09:31.563Z 2025-12-06T14:30:11.847Z
8670610 8670610 20251201094220_N7b7a USL00G 2025-12-03T14:09:31.006Z 2025-12-06T14:30:11.645Z
8670601 8670601 20251201093954_10ah3 USL00G 2025-12-03T14:09:28.135Z 2025-12-06T14:30:11.095Z
8670599 8670599 20251201093948_eG5g2 USL00G 2025-12-03T14:09:27.510Z 2025-12-06T14:30:11.000Z
8670521 8670521 20251201091550_z4YQo USL00G 2025-12-03T14:09:05.709Z 2025-12-06T14:30:07.856Z
8670479 8670479 20251201090401_7U22d USL00G 2025-12-03T14:08:57.942Z 2025-12-06T14:29:59.721Z
8670397 8670397 20251201083510_czGo4 USL00G 2025-12-03T14:08:31.957Z 2025-12-06T14:29:56.357Z
8670379 8670379 20251201080522_gayAR USL00G 2025-12-03T14:08:26.759Z 2025-12-06T14:29:53.500Z
8670370 8670370 20251201074500_uy9gt USL00G 2025-12-03T14:08:22.460Z 2025-12-06T14:29:52.381Z
8670106 8670106 20251202130955_19oDI USL00G 2025-12-03T14:06:56.028Z 2025-12-06T14:24:36.719Z
8670083 8670083 20251202130413_wy8zs USL00G 2025-12-03T14:06:50.511Z 2025-12-06T14:24:35.463Z
8670072 8670072 20251202130200_f45Gy USL00G 2025-12-03T14:06:41.408Z 2025-12-06T14:24:34.888Z
8670068 8670068 20251202130052_2u0zU USL00G 2025-12-03T14:06:40.062Z 2025-12-06T14:24:34.579Z
8669964 8669964 20251202123748_GI5ze USL00G 2025-12-03T14:06:12.971Z 2025-12-06T14:24:28.774Z
8669862 8669862 20251202121835_gxOsp USL00G 2025-12-03T14:05:51.809Z 2025-12-06T14:24:23.750Z
8669708 8669708 20251202120244_EAv53 USL00G 2025-12-03T14:05:14.183Z 2025-12-06T14:24:16.770Z
8669675 8669675 20251202115630_MRdok USL00G 2025-12-03T14:04:55.564Z 2025-12-06T14:24:14.242Z
8669635 8669635 20251202114815_7kBJo USL00G 2025-12-03T14:04:46.447Z 2025-12-06T14:24:12.315Z
8669599 8669599 20251202114044_0xetL USL00G 2025-12-03T14:04:40.215Z 2025-12-06T14:24:05.420Z
8669540 8669540 20251202112857_5CZaS USL00G 2025-12-03T14:04:24.296Z 2025-12-06T14:24:00.279Z
8669517 8669517 20251202112501_lqPnv USL00G 2025-12-03T14:04:18.213Z 2025-12-06T14:23:59.238Z
8669484 8669484 20251202111957_SHK0R USL00G 2025-12-03T14:04:07.306Z 2025-12-06T14:23:57.569Z
8669465 8669465 20251202111605_yG5j2 USL00G 2025-12-03T14:04:02.343Z 2025-12-06T14:23:56.461Z
8669399 8669399 20251202110824_ZONlg USL00G 2025-12-03T14:03:35.072Z 2025-12-06T14:23:52.160Z
8669376 8669376 20251202110212_BncYY USL00G 2025-12-03T14:03:29.551Z 2025-12-06T14:23:50.981Z
8669265 8669265 20251202104203_DxcgB USL00G 2025-12-03T14:03:05.558Z 2025-12-06T14:23:46.661Z
8669222 8669222 20251202103409_v73uv USL00G 2025-12-03T14:02:54.074Z 2025-12-06T14:23:41.067Z
8669201 8669201 20251202103128_TwQJb USL00G 2025-12-03T14:02:50.763Z 2025-12-06T14:23:39.782Z
8669114 8669114 20251202101359_6T4D2 USL00G 2025-12-03T14:02:33.193Z 2025-12-06T14:23:33.186Z
8669080 8669080 20251202100924_20cSe USL00G 2025-12-03T14:02:18.882Z 2025-12-06T14:23:30.943Z
8669050 8669050 20251202100215_jkXK6 USL00G 2025-12-03T14:02:08.594Z 2025-12-06T14:23:28.869Z
8669043 8669043 20251202095659_9IKka USL00G 2025-12-03T14:02:06.605Z 2025-12-06T14:23:27.991Z
8668508 8668508 20251202071530_nS5cq USL00G 2025-12-03T14:00:10.063Z 2025-12-06T14:22:46.165Z
8668277 8668277 20251130070645_EL7Ay USL00G 2025-12-02T14:42:16.155Z 2025-12-06T14:50:29.344Z
8668247 8668247 20251130065457_RZ8DD USL00G 2025-12-02T14:42:14.450Z 2025-12-06T14:50:28.555Z
8668225 8668225 20251130065051_RefGO USL00G 2025-12-02T14:42:12.854Z 2025-12-06T14:50:27.690Z
8668192 8668192 20251130063318_2dsj7 USL00G 2025-12-02T14:42:09.641Z 2025-12-06T14:50:26.054Z
8668130 8668130 20251130061401_zr6tl USL00G 2025-12-02T14:42:03.548Z 2025-12-06T14:50:23.410Z
8668061 8668061 20251130054731_jXVna USL00G 2025-12-02T14:41:33.214Z 2025-12-06T14:50:03.239Z
8667948 8667948 20251130052311_VljAc USL00G 2025-12-02T14:41:22.354Z 2025-12-06T14:49:43.848Z
8667818 8667818 20251130041706_wpyv4 USL00G 2025-12-02T14:40:29.706Z 2025-12-06T14:49:27.514Z
8667793 8667793 20251130040617_3mIG7 USL00G 2025-12-02T14:40:24.530Z 2025-12-06T14:49:24.748Z
8666921 8666921 20251201072545_E10XP USL00G 2025-12-02T14:30:46.301Z 2025-12-06T14:42:43.590Z
8666827 8666827 20251201040811_vIWLQ USL00G 2025-12-02T14:28:11.243Z 2025-12-06T14:42:06.506Z
8660516 8660516 20251130130107_gi8kR USL00G 2025-12-02T14:08:12.259Z 2025-12-06T14:37:18.217Z
8660311 8660311 20251130122721_EblSW USL00G 2025-12-02T14:07:19.475Z 2025-12-06T14:36:59.772Z
8660155 8660155 20251130115947_mgBC1 USL00G 2025-12-02T14:06:45.105Z 2025-12-06T14:36:53.962Z
8660149 8660149 20251130115935_E61e7 USL00G 2025-12-02T14:06:43.826Z 2025-12-06T14:36:53.803Z
8660082 8660082 20251130115450_qZkdj USL00G 2025-12-02T14:06:28.137Z 2025-12-06T14:36:52.391Z
8660065 8660065 20251130115127_ohskF USL00G 2025-12-02T14:06:24.590Z 2025-12-06T14:36:51.708Z
8660045 8660045 20251130114816_veHVf USL00G 2025-12-02T14:06:21.551Z 2025-12-06T14:36:51.230Z
8660022 8660022 20251130114307_Raxf2 USL00G 2025-12-02T14:06:15.313Z 2025-12-06T14:36:50.329Z
8659697 8659697 20251130110645_Hwfbj USL00G 2025-12-02T14:05:03.960Z 2025-12-06T14:36:39.470Z
8659633 8659633 20251130105808_kiOSY USL00G 2025-12-02T14:04:41.608Z 2025-12-06T14:36:25.865Z
8659573 8659573 20251130105023_RNR5P USL00G 2025-12-02T14:04:31.749Z 2025-12-06T14:36:23.932Z
8659553 8659553 20251130104723_x64xq USL00G 2025-12-02T14:04:26.421Z 2025-12-06T14:36:23.277Z

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