participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
751 rows where station_code = "US002W" sorted by created_at descending
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 |
---|---|---|---|---|---|
5134564 | 5134564 | 20240916103350_XpfMm | US002W | 2024-09-19T12:17:51.050Z | 2024-09-19T12:17:51.050Z |
5134531 | 5134531 | 20240916100654_Jxsk9 | US002W | 2024-09-19T12:17:48.749Z | 2024-09-19T12:17:48.749Z |
5134469 | 5134469 | 20240916092817_YCgTl | US002W | 2024-09-19T12:17:45.699Z | 2024-09-19T12:17:45.699Z |
5134339 | 5134339 | 20240916082109_FUEyi | US002W | 2024-09-19T12:17:37.694Z | 2024-09-19T12:17:37.694Z |
5134274 | 5134274 | 20240916074517_MkswV | US002W | 2024-09-19T12:17:34.833Z | 2024-09-19T12:17:34.833Z |
5134269 | 5134269 | 20240916074013_9Y3On | US002W | 2024-09-19T12:17:34.516Z | 2024-09-19T12:17:34.516Z |
5134178 | 5134178 | 20240916061356_Zfigg | US002W | 2024-09-19T12:17:27.685Z | 2024-09-19T12:17:27.685Z |
5133176 | 5133176 | 20240916030411_3vuEO | US002W | 2024-09-19T12:16:46.339Z | 2024-09-19T12:16:46.339Z |
5129898 | 5129898 | 20240917053941_aaRPe | US002W | 2024-09-19T12:12:14.375Z | 2024-09-19T12:12:14.375Z |
5118276 | 5118276 | 20240915090428_UUEQm | US002W | 2024-09-18T12:08:35.006Z | 2024-09-19T12:19:21.751Z |
5118259 | 5118259 | 20240915090147_br7LY | US002W | 2024-09-18T12:08:34.132Z | 2024-09-19T12:19:21.638Z |
5109235 | 5109235 | 20240913091811_Fk4xK | US002W | 2024-09-17T12:14:33.723Z | 2024-09-19T12:20:52.617Z |
5108477 | 5108477 | 20240913055327_YPAYx | US002W | 2024-09-17T12:13:47.022Z | 2024-09-19T12:20:48.937Z |
5107216 | 5107216 | 20240913034718_t19o0 | US002W | 2024-09-17T12:13:10.787Z | 2024-09-19T12:20:46.913Z |
5082485 | 5082485 | 20240911101501_k7jrv | US002W | 2024-09-15T12:18:16.299Z | 2024-09-19T12:21:47.997Z |
5082316 | 5082316 | 20240911095251_H48f3 | US002W | 2024-09-15T12:18:11.113Z | 2024-09-19T12:21:47.765Z |
5082081 | 5082081 | 20240911092001_IQLqv | US002W | 2024-09-15T12:18:02.648Z | 2024-09-19T12:21:47.173Z |
5081839 | 5081839 | 20240911085008_irlTN | US002W | 2024-09-15T12:17:50.703Z | 2024-09-19T12:21:46.558Z |
5081101 | 5081101 | 20240911063459_sentB | US002W | 2024-09-15T12:17:23.865Z | 2024-09-19T12:21:44.624Z |
5081032 | 5081032 | 20240911060704_n6uYs | US002W | 2024-09-15T12:17:21.168Z | 2024-09-19T12:21:44.404Z |
5080969 | 5080969 | 20240911054753_Qlvwl | US002W | 2024-09-15T12:17:18.817Z | 2024-09-19T12:21:44.150Z |
5080956 | 5080956 | 20240911053814_hbEXQ | US002W | 2024-09-15T12:17:18.242Z | 2024-09-19T12:21:44.109Z |
5080850 | 5080850 | 20240911050536_M30AF | US002W | 2024-09-15T12:17:15.744Z | 2024-09-19T12:21:43.889Z |
5078417 | 5078417 | 20240911015646_dZTAo | US002W | 2024-09-15T12:15:38.527Z | 2024-09-19T12:21:40.386Z |
5068145 | 5068145 | 20240910110120_GPeDN | US002W | 2024-09-14T12:19:09.758Z | 2024-09-18T12:15:25.660Z |
5068037 | 5068037 | 20240910104603_yVCRt | US002W | 2024-09-14T12:19:07.464Z | 2024-09-18T12:15:25.416Z |
5067483 | 5067483 | 20240910093749_iXqXQ | US002W | 2024-09-14T12:18:45.558Z | 2024-09-18T12:15:24.216Z |
5067353 | 5067353 | 20240910092033_NrPbZ | US002W | 2024-09-14T12:18:40.433Z | 2024-09-18T12:15:23.880Z |
5067026 | 5067026 | 20240910084630_98A5n | US002W | 2024-09-14T12:18:27.217Z | 2024-09-18T12:15:23.217Z |
5066379 | 5066379 | 20240910071856_X3QBt | US002W | 2024-09-14T12:17:53.914Z | 2024-09-18T12:15:21.748Z |
5066331 | 5066331 | 20240910071401_3y151 | US002W | 2024-09-14T12:17:50.572Z | 2024-09-18T12:15:21.613Z |
5066263 | 5066263 | 20240910070255_3VD1O | US002W | 2024-09-14T12:17:47.559Z | 2024-09-18T12:15:21.488Z |
5065446 | 5065446 | 20240910041159_XmBjN | US002W | 2024-09-14T12:17:05.974Z | 2024-09-18T12:15:19.459Z |
5056640 | 5056640 | 20240908105557_jiAZ2 | US002W | 2024-09-13T12:17:36.653Z | 2024-09-16T12:21:26.310Z |
5056292 | 5056292 | 20240908100708_54nig | US002W | 2024-09-13T12:17:29.599Z | 2024-09-16T12:21:24.192Z |
5056032 | 5056032 | 20240908093245_IrE2Y | US002W | 2024-09-13T12:17:26.852Z | 2024-09-16T12:21:23.049Z |
5055208 | 5055208 | 20240908072123_rDQse | US002W | 2024-09-13T12:17:07.649Z | 2024-09-16T12:21:18.418Z |
5055131 | 5055131 | 20240908065442_S5xpW | US002W | 2024-09-13T12:17:05.644Z | 2024-09-16T12:21:17.989Z |
5054619 | 5054619 | 20240908032254_TXt1L | US002W | 2024-09-13T12:16:49.577Z | 2024-09-16T12:21:16.321Z |
5054290 | 5054290 | 20240908023649_3p8Wh | US002W | 2024-09-13T12:16:36.198Z | 2024-09-16T12:21:14.747Z |
5049348 | 5049348 | 20240909104112_gDA0H | US002W | 2024-09-13T12:12:02.916Z | 2024-09-17T12:19:10.195Z |
5049323 | 5049323 | 20240909103635_fZRrT | US002W | 2024-09-13T12:11:58.959Z | 2024-09-17T12:19:09.912Z |
5049206 | 5049206 | 20240909102057_aZU2K | US002W | 2024-09-13T12:11:45.753Z | 2024-09-17T12:19:09.497Z |
5048785 | 5048785 | 20240909090732_sGk07 | US002W | 2024-09-13T12:11:15.547Z | 2024-09-17T12:19:08.278Z |
5048282 | 5048282 | 20240909073813_sipJQ | US002W | 2024-09-13T12:10:25.023Z | 2024-09-17T12:19:06.320Z |
5047920 | 5047920 | 20240909062750_NIbTy | US002W | 2024-09-13T12:09:58.862Z | 2024-09-17T12:19:04.948Z |
5047372 | 5047372 | 20240909034423_EWlm2 | US002W | 2024-09-13T12:08:53.354Z | 2024-09-17T12:19:02.211Z |
5042387 | 5042387 | 20240906104743_bKNbw | US002W | 2024-09-12T12:17:01.701Z | 2024-09-14T12:23:17.192Z |
5041772 | 5041772 | 20240906090323_b8ub7 | US002W | 2024-09-12T12:16:48.265Z | 2024-09-14T12:23:14.491Z |
5041631 | 5041631 | 20240906084204_XvuhD | US002W | 2024-09-12T12:16:45.767Z | 2024-09-14T12:23:14.233Z |
5040976 | 5040976 | 20240906064812_2TjMD | US002W | 2024-09-12T12:16:30.790Z | 2024-09-14T12:23:11.135Z |
5034614 | 5034614 | 20240907072848_ykck9 | US002W | 2024-09-12T12:11:07.933Z | 2024-09-15T12:21:35.282Z |
5034060 | 5034060 | 20240907052208_7GTr2 | US002W | 2024-09-12T12:10:28.212Z | 2024-09-15T12:21:32.712Z |
5033917 | 5033917 | 20240907042415_VqpKJ | US002W | 2024-09-12T12:10:08.712Z | 2024-09-15T12:21:32.246Z |
5001615 | 5001615 | 20240902055519_SXJfQ | US002W | 2024-09-08T12:16:45.140Z | 2024-09-10T12:19:33.731Z |
5001607 | 5001607 | 20240902055425_2fAQm | US002W | 2024-09-08T12:16:42.878Z | 2024-09-10T12:19:33.723Z |
4992811 | 4992811 | 20240902085959_Z6DEm | US002W | 2024-09-08T12:00:52.726Z | 2024-09-11T12:20:17.645Z |
4984242 | 4984242 | 20240901093414_MZ475 | US002W | 2024-09-07T12:01:36.397Z | 2024-09-10T12:19:04.888Z |
4983706 | 4983706 | 20240901075059_buzro | US002W | 2024-09-07T12:00:39.884Z | 2024-09-10T12:19:02.463Z |
4983669 | 4983669 | 20240901073444_I5SZC | US002W | 2024-09-07T12:00:35.278Z | 2024-09-10T12:19:02.302Z |
4983545 | 4983545 | 20240901070443_rk0ai | US002W | 2024-09-07T12:00:14.882Z | 2024-09-10T12:19:01.659Z |
4955322 | 4955322 | 20240811043002_58zqn | US002W | 2024-09-03T12:19:08.648Z | 2024-09-06T12:29:33.350Z |
4905372 | 4905372 | 20240808093119_k01nt | US002W | 2024-08-28T12:21:22.795Z | 2024-08-28T12:21:22.795Z |
4905345 | 4905345 | 20240808092408_XjHxg | US002W | 2024-08-28T12:21:21.767Z | 2024-08-28T12:21:21.767Z |
4905137 | 4905137 | 20240808083428_wNbLD | US002W | 2024-08-28T12:21:07.656Z | 2024-08-28T12:21:07.656Z |
4905082 | 4905082 | 20240808082316_NoGee | US002W | 2024-08-28T12:21:01.914Z | 2024-08-28T12:21:01.914Z |
4904824 | 4904824 | 20240808072550_FBgjZ | US002W | 2024-08-28T12:20:45.956Z | 2024-08-28T12:20:45.956Z |
4904787 | 4904787 | 20240808071913_ym8YB | US002W | 2024-08-28T12:20:44.456Z | 2024-08-28T12:20:44.456Z |
4904686 | 4904686 | 20240808065242_jmhE1 | US002W | 2024-08-28T12:20:41.131Z | 2024-08-28T12:20:41.131Z |
4904621 | 4904621 | 20240808062645_hJAyu | US002W | 2024-08-28T12:20:38.480Z | 2024-08-28T12:20:38.480Z |
4904615 | 4904615 | 20240808062442_aKSYl | US002W | 2024-08-28T12:20:38.163Z | 2024-08-28T12:20:38.163Z |
4904047 | 4904047 | 20240808034418_6CoJ3 | US002W | 2024-08-28T12:20:03.229Z | 2024-08-28T12:20:03.229Z |
4903934 | 4903934 | 20240808033018_jUkrk | US002W | 2024-08-28T12:19:58.368Z | 2024-08-28T12:19:58.368Z |
4903352 | 4903352 | 20240808025314_LytwA | US002W | 2024-08-28T12:19:37.447Z | 2024-08-28T12:19:37.447Z |
4903327 | 4903327 | 20240808025135_3A7ot | US002W | 2024-08-28T12:19:35.824Z | 2024-08-28T12:19:35.824Z |
4903113 | 4903113 | 20240808024142_DBGc0 | US002W | 2024-08-28T12:19:29.746Z | 2024-08-28T12:19:29.746Z |
4902668 | 4902668 | 20240808022345_Jjz49 | US002W | 2024-08-28T12:19:22.624Z | 2024-08-28T12:19:22.624Z |
4894441 | 4894441 | 20240807100131_TNreN | US002W | 2024-08-28T12:12:22.815Z | 2024-08-28T12:12:22.815Z |
4894216 | 4894216 | 20240807093748_yBeTt | US002W | 2024-08-28T12:12:11.849Z | 2024-08-28T12:12:11.849Z |
4894059 | 4894059 | 20240807091939_m634o | US002W | 2024-08-28T12:12:05.347Z | 2024-08-28T12:12:05.347Z |
4892609 | 4892609 | 20240809040930_fuXHr | US002W | 2024-08-28T12:10:24.758Z | 2024-08-30T12:22:20.168Z |
4885511 | 4885511 | 20240808102735_FHksp | US002W | 2024-08-28T12:00:46.921Z | 2024-08-30T12:15:36.716Z |
4885220 | 4885220 | 20240807083317_mssUd | US002W | 2024-08-20T12:16:22.598Z | 2024-08-27T12:17:00.838Z |
4885204 | 4885204 | 20240807083013_Va7qK | US002W | 2024-08-20T12:16:22.018Z | 2024-08-27T12:17:00.337Z |
4885147 | 4885147 | 20240807080625_J9ifE | US002W | 2024-08-20T12:16:19.857Z | 2024-08-27T12:16:58.464Z |
4885124 | 4885124 | 20240807080049_GbKgI | US002W | 2024-08-20T12:16:18.719Z | 2024-08-27T12:16:57.180Z |
4884813 | 4884813 | 20240807062957_e7D1l | US002W | 2024-08-20T12:16:02.707Z | 2024-08-27T12:16:34.629Z |
4884779 | 4884779 | 20240807061208_r14Gf | US002W | 2024-08-20T12:16:00.845Z | 2024-08-27T12:16:32.892Z |
4884773 | 4884773 | 20240807060238_UTzGe | US002W | 2024-08-20T12:16:00.527Z | 2024-08-27T12:16:32.597Z |
4884753 | 4884753 | 20240807055124_ForvK | US002W | 2024-08-20T12:15:59.746Z | 2024-08-27T12:16:31.830Z |
4884732 | 4884732 | 20240807053738_2DTJS | US002W | 2024-08-20T12:15:58.605Z | 2024-08-27T12:16:31.091Z |
4884708 | 4884708 | 20240807052240_xFYQu | US002W | 2024-08-20T12:15:57.366Z | 2024-08-27T12:16:29.870Z |
4879097 | 4879097 | 20240807084429_3JgMv | US002W | 2024-08-20T12:00:09.110Z | 2024-08-28T12:11:42.676Z |
4868677 | 4868677 | 20240806070004_CuiX1 | US002W | 2024-08-18T12:24:22.424Z | 2024-08-19T12:28:54.996Z |
4868437 | 4868437 | 20240806063616_lKBBC | US002W | 2024-08-18T12:24:10.289Z | 2024-08-19T12:28:45.834Z |
4868211 | 4868211 | 20240806060817_sRm1e | US002W | 2024-08-18T12:24:02.684Z | 2024-08-19T12:28:41.678Z |
4868064 | 4868064 | 20240806053030_7ifNi | US002W | 2024-08-18T12:23:58.001Z | 2024-08-19T12:28:33.236Z |
4867987 | 4867987 | 20240806051026_Y7jOf | US002W | 2024-08-18T12:23:55.817Z | 2024-08-19T12:28:31.869Z |
4867927 | 4867927 | 20240806044541_EXTMn | US002W | 2024-08-18T12:23:53.984Z | 2024-08-19T12:28:30.672Z |
4860335 | 4860335 | 20240806103443_SQDy5 | US002W | 2024-08-18T12:02:39.882Z | 2024-08-27T12:02:41.562Z |
Advanced export
JSON shape: default, array, newline-delimited
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);