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

349 rows where station_code = "PL000G" 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
8633187 8633187 20251127225042_zwRz6 PL000G 2025-11-29T14:19:13.012Z 2025-12-05T14:57:18.032Z
8632790 8632790 20251127215511_cOs23 PL000G 2025-11-29T14:18:23.361Z 2025-12-05T14:56:43.322Z
8632458 8632458 20251127211026_NmAh6 PL000G 2025-11-29T14:17:39.776Z 2025-12-05T14:56:21.502Z
8632455 8632455 20251127211026_LlTUb PL000G 2025-11-29T14:17:36.359Z 2025-12-05T14:56:21.455Z
8632357 8632357 20251127205415_CEQsZ PL000G 2025-11-29T14:17:18.920Z 2025-12-05T14:56:20.147Z
8632303 8632303 20251127204926_Ztxiq PL000G 2025-11-29T14:17:14.629Z 2025-12-05T14:56:19.518Z
8631740 8631740 20251127195615_shrk4 PL000G 2025-11-29T14:16:20.590Z 2025-12-05T14:56:11.351Z
8631460 8631460 20251127191049_RR34h PL000G 2025-11-29T14:15:23.463Z 2025-12-05T14:56:06.888Z
8631360 8631360 20251127185228_IXwHg PL000G 2025-11-29T14:15:09.911Z 2025-12-05T14:56:05.538Z
8588965 8588965 20251124004840_3MDH7 PL000G 2025-11-25T14:18:49.826Z 2025-12-02T15:12:03.123Z
8588752 8588752 20251124002833_Vezrd PL000G 2025-11-25T14:18:14.662Z 2025-12-02T15:11:52.230Z
8535591 8535591 20251120022449_C3B3L PL000G 2025-11-21T14:16:28.610Z 2025-11-28T14:56:51.535Z
8532609 8532609 20251119162858_YkFQj PL000G 2025-11-21T14:08:22.043Z 2025-11-28T14:53:59.485Z
8524744 8524744 20251119041605_j0UPo PL000G 2025-11-20T14:21:32.569Z 2025-11-27T15:13:03.684Z
8524626 8524626 20251119040323_k0eMo PL000G 2025-11-20T14:21:09.416Z 2025-11-27T15:13:02.356Z
8524580 8524580 20251119035822_q83bm PL000G 2025-11-20T14:21:04.232Z 2025-11-27T15:12:59.106Z
8524533 8524533 20251119035429_gchAK PL000G 2025-11-20T14:21:00.819Z 2025-11-27T15:12:57.448Z
8524338 8524338 20251119033514_U0wzh PL000G 2025-11-20T14:20:28.482Z 2025-11-27T15:12:50.092Z
8524210 8524210 20251119032504_BMPCN PL000G 2025-11-20T14:20:17.669Z 2025-11-27T15:12:47.725Z
8524133 8524133 20251119031328_D7Uvw PL000G 2025-11-20T14:20:10.699Z 2025-11-27T15:12:44.595Z
8523977 8523977 20251119030055_tddmD PL000G 2025-11-20T14:19:41.274Z 2025-11-27T15:12:35.941Z
8523458 8523458 20251119020951_gqXZm PL000G 2025-11-20T14:18:22.662Z 2025-11-27T15:12:21.172Z
8523443 8523443 20251119020736_bagyU PL000G 2025-11-20T14:18:20.766Z 2025-11-27T15:12:21.009Z
8523425 8523425 20251119020634_41qEG PL000G 2025-11-20T14:18:19.703Z 2025-11-27T15:12:20.934Z
8523159 8523159 20251119013446_a3tGb PL000G 2025-11-20T14:17:39.925Z 2025-11-27T15:12:09.333Z
8523095 8523095 20251119012715_FbiFB PL000G 2025-11-20T14:17:30.770Z 2025-11-27T15:12:08.936Z
8522962 8522962 20251119011322_SfQCU PL000G 2025-11-20T14:17:02.724Z 2025-11-27T15:12:08.235Z
8522855 8522855 20251119010353_2r6Op PL000G 2025-11-20T14:16:49.529Z 2025-11-27T15:12:07.390Z
8522632 8522632 20251119004008_NzgZ0 PL000G 2025-11-20T14:16:09.229Z 2025-11-27T15:12:05.533Z
8522612 8522612 20251119003847_3APDO PL000G 2025-11-20T14:16:07.057Z 2025-11-27T15:12:05.378Z
8522590 8522590 20251119003444_07HBt PL000G 2025-11-20T14:16:04.258Z 2025-11-27T15:12:05.110Z
8522265 8522265 20251118234804_awriz PL000G 2025-11-20T14:14:58.049Z 2025-11-27T15:11:59.283Z
8522181 8522181 20251118233019_ybzjS PL000G 2025-11-20T14:14:43.609Z 2025-11-27T15:11:56.059Z
8522124 8522124 20251118232656_2Nr2P PL000G 2025-11-20T14:14:38.052Z 2025-11-27T15:11:54.703Z
8521818 8521818 20251118223202_u2TLI PL000G 2025-11-20T14:13:32.195Z 2025-11-27T15:11:47.906Z
8521717 8521717 20251118220513_qfndZ PL000G 2025-11-20T14:13:17.773Z 2025-11-27T15:11:43.173Z
8521671 8521671 20251118215708_QAqNp PL000G 2025-11-20T14:13:11.067Z 2025-11-27T15:11:41.683Z
8521668 8521668 20251118215438_22zfu PL000G 2025-11-20T14:13:10.722Z 2025-11-27T15:11:41.657Z
8519420 8519420 20251118171746_At4cw PL000G 2025-11-20T14:06:41.713Z 2025-11-27T15:11:27.105Z
8469637 8469637 20251115031200_bBhdi PL000G 2025-11-16T14:20:45.661Z 2025-11-23T15:17:53.204Z
8458992 8458992 20251114022815_fyF3k PL000G 2025-11-15T14:18:25.827Z 2025-11-22T15:21:31.006Z
8458712 8458712 20251114012217_quVD4 PL000G 2025-11-15T14:17:38.277Z 2025-11-22T15:21:19.924Z
8458433 8458433 20251114001105_jYbes PL000G 2025-11-15T14:16:42.918Z 2025-11-22T15:21:03.211Z
8458349 8458349 20251113234838_poKqy PL000G 2025-11-15T14:16:26.603Z 2025-11-22T15:21:02.175Z
8458249 8458249 20251113231501_Znbt3 PL000G 2025-11-15T14:16:00.797Z 2025-11-22T15:21:00.842Z
8458133 8458133 20251113224029_ShUNJ PL000G 2025-11-15T14:15:42.152Z 2025-11-22T15:20:59.265Z
8457952 8457952 20251113215437_fSedF PL000G 2025-11-15T14:15:08.010Z 2025-11-22T15:20:57.089Z
8457506 8457506 20251113203554_2kOZr PL000G 2025-11-15T14:13:41.908Z 2025-11-22T15:20:51.955Z
8457028 8457028 20251113194555_gNsSr PL000G 2025-11-15T14:12:36.729Z 2025-11-22T15:20:48.653Z
8448098 8448098 20251112215542_Vw300 PL000G 2025-11-14T14:16:09.465Z 2025-11-21T15:11:24.474Z
8446868 8446868 20251112182545_E7kQ3 PL000G 2025-11-14T14:12:08.437Z 2025-11-21T15:11:14.269Z
8396579 8396579 20251107215528_fBhl3 PL000G 2025-11-09T14:09:03.598Z 2025-11-16T15:03:34.378Z
8396213 8396213 20251107195707_1k3pZ PL000G 2025-11-09T14:07:43.313Z 2025-11-16T15:03:19.136Z
8395963 8395963 20251107185648_pFu5t PL000G 2025-11-09T14:06:43.659Z 2025-11-16T15:03:01.328Z
8391595 8391595 20251107031448_S8a42 PL000G 2025-11-08T14:15:18.980Z 2025-11-15T15:00:33.375Z
8390212 8390212 20251106234641_4imPs PL000G 2025-11-08T14:10:05.300Z 2025-11-15T14:59:57.483Z
8390076 8390076 20251106232503_Q6D0u PL000G 2025-11-08T14:09:29.120Z 2025-11-15T14:59:53.408Z
8389924 8389924 20251106225926_cRNeP PL000G 2025-11-08T14:08:58.672Z 2025-11-15T14:59:49.571Z
8389235 8389235 20251106200445_MoV2T PL000G 2025-11-08T14:06:02.086Z 2025-11-15T14:59:33.427Z
8389102 8389102 20251106192351_0qdEw PL000G 2025-11-08T14:05:22.441Z 2025-11-15T14:59:31.308Z
8386122 8386122 20251106023927_YmAv0 PL000G 2025-11-07T14:09:41.409Z 2025-11-14T15:08:36.006Z
8385557 8385557 20251106002841_e3kqi PL000G 2025-11-07T14:07:15.146Z 2025-11-14T15:08:16.596Z
8385403 8385403 20251105234226_cvNL0 PL000G 2025-11-07T14:06:35.422Z 2025-11-14T15:08:08.701Z
8385380 8385380 20251105232821_8RRnG PL000G 2025-11-07T14:06:31.833Z 2025-11-14T15:08:08.185Z
8385374 8385374 20251105232643_IgVem PL000G 2025-11-07T14:06:30.559Z 2025-11-14T15:08:08.117Z
8385131 8385131 20251105215112_Yb3Al PL000G 2025-11-07T14:05:28.902Z 2025-11-14T15:08:01.560Z
8385108 8385108 20251105213729_Y34Y7 PL000G 2025-11-07T14:05:23.597Z 2025-11-14T15:07:58.935Z
8385034 8385034 20251105205710_nqMPD PL000G 2025-11-07T14:04:57.660Z 2025-11-14T15:07:53.250Z
8380685 8380685 20251105024909_q0BdF PL000G 2025-11-06T14:12:39.554Z 2025-11-13T15:14:59.662Z
8380603 8380603 20251105023409_oprAZ PL000G 2025-11-06T14:12:16.912Z 2025-11-13T15:14:56.966Z
8380488 8380488 20251105021034_HWvAt PL000G 2025-11-06T14:11:59.309Z 2025-11-13T15:14:54.227Z
8380475 8380475 20251105020910_L2Lkv PL000G 2025-11-06T14:11:56.666Z 2025-11-13T15:14:53.814Z
8380167 8380167 20251105005815_zOg4F PL000G 2025-11-06T14:10:39.494Z 2025-11-13T15:14:43.021Z
8380021 8380021 20251105002232_ZJC7v PL000G 2025-11-06T14:10:05.987Z 2025-11-13T15:14:35.598Z
8379886 8379886 20251104235819_81x1I PL000G 2025-11-06T14:09:33.361Z 2025-11-13T15:14:32.985Z
8379706 8379706 20251104231907_KTGj1 PL000G 2025-11-06T14:08:51.186Z 2025-11-13T15:14:27.665Z
8379462 8379462 20251104222345_cuB2W PL000G 2025-11-06T14:07:58.645Z 2025-11-13T15:14:14.798Z
8379181 8379181 20251104210128_uA712 PL000G 2025-11-06T14:06:51.835Z 2025-11-13T15:14:00.744Z
8378951 8378951 20251104201249_Iz0ju PL000G 2025-11-06T14:06:07.378Z 2025-11-13T15:13:53.401Z
8378656 8378656 20251104183545_K9vrO PL000G 2025-11-06T14:04:52.948Z 2025-11-13T15:13:37.261Z
8371366 8371366 20251104041459_ctENs PL000G 2025-11-05T14:14:41.617Z 2025-11-12T15:11:00.387Z
8370422 8370422 20251104015623_z3EgD PL000G 2025-11-05T14:10:54.095Z 2025-11-12T15:10:39.272Z
8370399 8370399 20251104015251_QZTUl PL000G 2025-11-05T14:10:47.441Z 2025-11-12T15:10:37.688Z
8343842 8343842 20251101031949_1QyZX PL000G 2025-11-02T14:41:41.375Z 2025-11-09T15:03:17.113Z
8342270 8342270 20251031230855_MTKRz PL000G 2025-11-02T14:38:40.629Z 2025-11-09T15:00:31.238Z
8342238 8342238 20251031230400_VWoNT PL000G 2025-11-02T14:38:39.546Z 2025-11-09T15:00:30.570Z
8341877 8341877 20251031214536_K9Yhj PL000G 2025-11-02T14:37:45.196Z 2025-11-09T15:00:18.870Z
8341713 8341713 20251031210822_ihJmr PL000G 2025-11-02T14:37:40.293Z 2025-11-09T15:00:07.950Z
8341203 8341203 20251031184831_nt5pC PL000G 2025-11-02T14:36:30.072Z 2025-11-09T14:58:52.607Z
8336184 8336184 20251031042045_tDK2x PL000G 2025-11-02T14:29:05.752Z 2025-11-08T15:15:40.586Z
8336094 8336094 20251031041545_ji0iK PL000G 2025-11-02T14:28:53.342Z 2025-11-08T15:15:37.486Z
8336019 8336019 20251031040735_2xF32 PL000G 2025-11-02T14:28:43.917Z 2025-11-08T15:15:26.131Z
8335630 8335630 20251031033747_u8NJb PL000G 2025-11-02T14:27:58.332Z 2025-11-08T15:14:57.590Z
8335560 8335560 20251031033127_wC1EW PL000G 2025-11-02T14:27:39.127Z 2025-11-08T15:14:54.101Z
8334846 8334846 20251031022924_H1kSD PL000G 2025-11-02T14:26:13.485Z 2025-11-08T15:14:08.281Z
8334431 8334431 20251031015200_IJUi8 PL000G 2025-11-02T14:25:13.916Z 2025-11-08T15:13:34.611Z
8333529 8333529 20251031002304_ZBc6L PL000G 2025-11-02T14:22:48.691Z 2025-11-08T15:12:55.838Z
8333436 8333436 20251031001431_Z3KrL PL000G 2025-11-02T14:22:40.554Z 2025-11-08T15:12:54.204Z
8333309 8333309 20251030235835_0gVFJ PL000G 2025-11-02T14:22:13.321Z 2025-11-08T15:12:51.881Z
8333276 8333276 20251030235448_kHcks PL000G 2025-11-02T14:22:10.004Z 2025-11-08T15:12:51.390Z

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