participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,189 rows where station_code = "US004J" 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 |
---|---|---|---|---|---|
5571377 | 5571377 | 20241120233432_yL17l | US004J | 2024-11-22T14:16:59.175Z | 2024-11-22T14:19:22.114Z |
5571374 | 5571374 | 20241120233403_EBmjY | US004J | 2024-11-22T14:16:58.931Z | 2024-11-22T14:19:22.113Z |
5564048 | 5564048 | 20241120022543_OfSRp | US004J | 2024-11-21T14:17:06.264Z | 2024-11-22T14:21:26.675Z |
5559127 | 5559127 | 20241120092708_zFtmG | US004J | 2024-11-21T14:05:26.303Z | 2024-11-22T14:19:21.370Z |
5559115 | 5559115 | 20241120092552_T92uq | US004J | 2024-11-21T14:05:24.051Z | 2024-11-22T14:19:21.367Z |
5558856 | 5558856 | 20241120083133_BFdAG | US004J | 2024-11-21T14:04:39.143Z | 2024-11-22T14:19:21.315Z |
5558368 | 5558368 | 20241120055950_IiMBv | US004J | 2024-11-21T14:03:08.351Z | 2024-11-22T14:19:21.219Z |
5557576 | 5557576 | 20241120045839_ZzVdS | US004J | 2024-11-21T14:01:13.982Z | 2024-11-22T14:19:21.093Z |
5557132 | 5557132 | 20241119040529_k7Iyb | US004J | 2024-11-20T14:12:20.301Z | 2024-11-22T14:22:22.432Z |
5554332 | 5554332 | 20241119081910_Xrnl7 | US004J | 2024-11-20T14:01:41.227Z | 2024-11-22T14:19:37.415Z |
5554287 | 5554287 | 20241119074728_gVmT2 | US004J | 2024-11-20T14:01:23.826Z | 2024-11-22T14:19:35.240Z |
5554225 | 5554225 | 20241119071600_Xfrvm | US004J | 2024-11-20T14:01:11.507Z | 2024-11-22T14:19:34.016Z |
5554218 | 5554218 | 20241119071224_yzQWV | US004J | 2024-11-20T14:01:10.088Z | 2024-11-22T14:19:33.870Z |
5554161 | 5554161 | 20241119064207_d9y57 | US004J | 2024-11-20T14:00:54.203Z | 2024-11-22T14:19:31.385Z |
5554135 | 5554135 | 20241119062541_iEPvf | US004J | 2024-11-20T14:00:49.604Z | 2024-11-22T14:19:30.732Z |
5554084 | 5554084 | 20241119060442_oPEjN | US004J | 2024-11-20T14:00:41.388Z | 2024-11-22T14:19:29.146Z |
5554011 | 5554011 | 20241119052532_t3Ror | US004J | 2024-11-20T14:00:23.714Z | 2024-11-22T14:19:26.880Z |
5552378 | 5552378 | 20241117095358_lR3hE | US004J | 2024-11-19T14:07:00.687Z | 2024-11-22T14:22:30.219Z |
5549497 | 5549497 | 20241117050425_pvkxh | US004J | 2024-11-18T14:11:45.399Z | 2024-11-22T14:23:21.504Z |
5549473 | 5549473 | 20241117050001_kVrJ5 | US004J | 2024-11-18T14:11:39.910Z | 2024-11-22T14:23:21.271Z |
5549443 | 5549443 | 20241117045449_7be0V | US004J | 2024-11-18T14:11:37.125Z | 2024-11-22T14:23:21.023Z |
5549418 | 5549418 | 20241117044810_xFzTC | US004J | 2024-11-18T14:11:34.190Z | 2024-11-22T14:23:20.848Z |
5549302 | 5549302 | 20241117041542_zOO2l | US004J | 2024-11-18T14:11:25.938Z | 2024-11-22T14:23:20.074Z |
5549270 | 5549270 | 20241117040631_yVisK | US004J | 2024-11-18T14:11:23.787Z | 2024-11-22T14:23:19.931Z |
5546341 | 5546341 | 20241117102851_n61VE | US004J | 2024-11-18T14:02:53.043Z | 2024-11-22T14:22:31.235Z |
5546306 | 5546306 | 20241117101845_exrvK | US004J | 2024-11-18T14:02:46.156Z | 2024-11-22T14:22:30.965Z |
5546171 | 5546171 | 20241117093514_iAs2d | US004J | 2024-11-18T14:02:22.002Z | 2024-11-22T14:22:29.845Z |
5546129 | 5546129 | 20241117092111_ZC2Fb | US004J | 2024-11-18T14:02:11.079Z | 2024-11-22T14:22:29.374Z |
5546092 | 5546092 | 20241117090729_cf3qL | US004J | 2024-11-18T14:01:59.818Z | 2024-11-22T14:22:28.920Z |
5546058 | 5546058 | 20241117090127_aOxt3 | US004J | 2024-11-18T14:01:52.126Z | 2024-11-22T14:22:28.644Z |
5545978 | 5545978 | 20241117083104_TOF68 | US004J | 2024-11-18T14:01:37.433Z | 2024-11-22T14:22:27.745Z |
5545970 | 5545970 | 20241117082528_mmjhj | US004J | 2024-11-18T14:01:35.914Z | 2024-11-22T14:22:27.659Z |
5545958 | 5545958 | 20241117081547_8da0D | US004J | 2024-11-18T14:01:33.968Z | 2024-11-22T14:22:27.562Z |
5545946 | 5545946 | 20241117081248_MkB2g | US004J | 2024-11-18T14:01:32.031Z | 2024-11-22T14:22:27.507Z |
5545930 | 5545930 | 20241117080055_HT8mv | US004J | 2024-11-18T14:01:29.240Z | 2024-11-22T14:22:27.391Z |
5545916 | 5545916 | 20241117075425_aSW3M | US004J | 2024-11-18T14:01:26.589Z | 2024-11-22T14:22:27.264Z |
5545862 | 5545862 | 20241117072910_n103l | US004J | 2024-11-18T14:01:13.755Z | 2024-11-22T14:22:26.851Z |
5545838 | 5545838 | 20241117072057_ikgJW | US004J | 2024-11-18T14:01:08.975Z | 2024-11-22T14:22:26.608Z |
5545826 | 5545826 | 20241117071209_YWhPn | US004J | 2024-11-18T14:01:03.560Z | 2024-11-22T14:22:26.445Z |
5545808 | 5545808 | 20241117070630_4fne5 | US004J | 2024-11-18T14:01:00.412Z | 2024-11-22T14:22:26.311Z |
5545685 | 5545685 | 20241117061248_KUxlX | US004J | 2024-11-18T14:00:38.681Z | 2024-11-22T14:22:25.457Z |
5545622 | 5545622 | 20241117054540_fYknb | US004J | 2024-11-18T14:00:28.452Z | 2024-11-22T14:22:25.170Z |
5545245 | 5545245 | 20241116031832_Gr5L5 | US004J | 2024-11-17T14:04:18.655Z | 2024-11-22T14:23:38.702Z |
5545241 | 5545241 | 20241116031415_oCOx6 | US004J | 2024-11-17T14:04:18.029Z | 2024-11-22T14:23:38.636Z |
5545182 | 5545182 | 20241116020454_UvfRC | US004J | 2024-11-17T14:04:00.203Z | 2024-11-22T14:23:37.084Z |
5544277 | 5544277 | 20241116092849_X4YZS | US004J | 2024-11-17T14:00:44.014Z | 2024-11-22T14:23:01.159Z |
5544255 | 5544255 | 20241116091701_gx2j3 | US004J | 2024-11-17T14:00:37.814Z | 2024-11-22T14:23:01.022Z |
5544252 | 5544252 | 20241116091256_9sI06 | US004J | 2024-11-17T14:00:37.473Z | 2024-11-22T14:23:01.014Z |
5544231 | 5544231 | 20241116085551_ul2Sa | US004J | 2024-11-17T14:00:31.755Z | 2024-11-22T14:23:00.842Z |
5544212 | 5544212 | 20241116083302_Eo9pr | US004J | 2024-11-17T14:00:28.824Z | 2024-11-22T14:23:00.731Z |
5544091 | 5544091 | 20241116054325_0STrN | US004J | 2024-11-17T14:00:10.428Z | 2024-11-22T14:22:59.269Z |
5544072 | 5544072 | 20241116051902_ijZxB | US004J | 2024-11-17T14:00:07.302Z | 2024-11-22T14:22:59.168Z |
5544064 | 5544064 | 20241114043801_7hzv1 | US004J | 2024-11-16T14:10:39.011Z | 2024-11-22T14:24:20.281Z |
5542029 | 5542029 | 20241114053020_G9bdd | US004J | 2024-11-15T14:08:48.805Z | 2024-11-22T14:24:21.817Z |
5541801 | 5541801 | 20241114044220_h8NwX | US004J | 2024-11-15T14:08:30.894Z | 2024-11-22T14:24:20.282Z |
5541614 | 5541614 | 20241114031227_tJ6Pf | US004J | 2024-11-15T14:07:57.092Z | 2024-11-22T14:24:19.613Z |
5541589 | 5541589 | 20241114030006_DrVJF | US004J | 2024-11-15T14:07:55.017Z | 2024-11-22T14:24:19.551Z |
5541518 | 5541518 | 20241114022202_kICLh | US004J | 2024-11-15T14:07:46.651Z | 2024-11-22T14:24:19.293Z |
5541420 | 5541420 | 20241114014303_RmKzy | US004J | 2024-11-15T14:07:36.210Z | 2024-11-22T14:24:18.677Z |
5541350 | 5541350 | 20241114004933_gGC2R | US004J | 2024-11-15T14:07:29.944Z | 2024-11-22T14:24:18.294Z |
5541338 | 5541338 | 20241114003631_TfwzL | US004J | 2024-11-15T14:07:28.586Z | 2024-11-22T14:24:18.153Z |
5541334 | 5541334 | 20241114003408_iarLw | US004J | 2024-11-15T14:07:28.070Z | 2024-11-22T14:24:18.093Z |
5540210 | 5540210 | 20241114102303_cCCgV | US004J | 2024-11-15T14:03:07.572Z | 2024-11-22T14:23:49.503Z |
5540182 | 5540182 | 20241114101817_xVMaH | US004J | 2024-11-15T14:03:05.112Z | 2024-11-22T14:23:49.390Z |
5540061 | 5540061 | 20241114095716_eau5H | US004J | 2024-11-15T14:02:46.363Z | 2024-11-22T14:23:48.762Z |
5540014 | 5540014 | 20241114094829_fWYXT | US004J | 2024-11-15T14:02:32.292Z | 2024-11-22T14:23:47.863Z |
5539991 | 5539991 | 20241114094426_ILKQ2 | US004J | 2024-11-15T14:02:29.560Z | 2024-11-22T14:23:47.695Z |
5539948 | 5539948 | 20241114093508_fGa2k | US004J | 2024-11-15T14:02:22.976Z | 2024-11-22T14:23:47.438Z |
5539943 | 5539943 | 20241114093258_3ZAeu | US004J | 2024-11-15T14:02:22.328Z | 2024-11-22T14:23:47.418Z |
5539879 | 5539879 | 20241114092042_0lYRC | US004J | 2024-11-15T14:02:15.629Z | 2024-11-22T14:23:47.034Z |
5539773 | 5539773 | 20241114085553_4HQhD | US004J | 2024-11-15T14:01:54.680Z | 2024-11-22T14:23:46.353Z |
5539754 | 5539754 | 20241114085244_c63fG | US004J | 2024-11-15T14:01:50.728Z | 2024-11-22T14:23:46.229Z |
5539709 | 5539709 | 20241114084225_Nq37N | US004J | 2024-11-15T14:01:43.634Z | 2024-11-22T14:23:45.906Z |
5539674 | 5539674 | 20241114083405_JOTZA | US004J | 2024-11-15T14:01:39.695Z | 2024-11-22T14:23:45.739Z |
5539651 | 5539651 | 20241114082258_CCUP2 | US004J | 2024-11-15T14:01:36.444Z | 2024-11-22T14:23:45.523Z |
5539633 | 5539633 | 20241114081828_AjiJm | US004J | 2024-11-15T14:01:34.754Z | 2024-11-22T14:23:45.437Z |
5539494 | 5539494 | 20241114073101_VbzbP | US004J | 2024-11-15T14:01:08.940Z | 2024-11-22T14:23:44.491Z |
5539442 | 5539442 | 20241114070920_2G1x2 | US004J | 2024-11-15T14:01:00.967Z | 2024-11-22T14:23:43.784Z |
5539427 | 5539427 | 20241114070327_HbnKA | US004J | 2024-11-15T14:00:58.553Z | 2024-11-22T14:23:43.724Z |
5539412 | 5539412 | 20241114070055_OT333 | US004J | 2024-11-15T14:00:56.088Z | 2024-11-22T14:23:43.574Z |
5539408 | 5539408 | 20241114065519_vi8ah | US004J | 2024-11-15T14:00:55.735Z | 2024-11-22T14:23:43.568Z |
5539322 | 5539322 | 20241114061519_tFCCF | US004J | 2024-11-15T14:00:40.698Z | 2024-11-22T14:23:43.050Z |
5538999 | 5538999 | 20241113053203_PA6tv | US004J | 2024-11-14T14:14:07.968Z | 2024-11-21T14:26:31.006Z |
5538871 | 5538871 | 20241113050720_GIvH8 | US004J | 2024-11-14T14:14:01.397Z | 2024-11-21T14:26:29.351Z |
5538837 | 5538837 | 20241113050412_Fgde3 | US004J | 2024-11-14T14:13:59.607Z | 2024-11-21T14:26:29.040Z |
5538593 | 5538593 | 20241113041653_iDsYI | US004J | 2024-11-14T14:13:42.146Z | 2024-11-21T14:26:27.404Z |
5538510 | 5538510 | 20241113040200_VK8nX | US004J | 2024-11-14T14:13:34.857Z | 2024-11-21T14:26:26.895Z |
5538477 | 5538477 | 20241113035408_MSkqI | US004J | 2024-11-14T14:13:31.258Z | 2024-11-21T14:26:26.501Z |
5538232 | 5538232 | 20241113024316_R3NSJ | US004J | 2024-11-14T14:13:06.665Z | 2024-11-21T14:26:21.927Z |
5538221 | 5538221 | 20241113024055_6XO1E | US004J | 2024-11-14T14:13:05.305Z | 2024-11-21T14:26:21.759Z |
5538195 | 5538195 | 20241113023423_P80Iy | US004J | 2024-11-14T14:13:02.406Z | 2024-11-21T14:26:21.627Z |
5537771 | 5537771 | 20241113003225_tmcdn | US004J | 2024-11-14T14:12:29.337Z | 2024-11-21T14:26:15.879Z |
5537644 | 5537644 | 20241112235742_ZNZdE | US004J | 2024-11-14T14:12:20.673Z | 2024-11-21T14:26:15.029Z |
5533937 | 5533937 | 20241113102850_CFN6O | US004J | 2024-11-14T14:03:18.640Z | 2024-11-22T14:24:11.758Z |
5533689 | 5533689 | 20241113094510_IPnZt | US004J | 2024-11-14T14:02:38.208Z | 2024-11-22T14:24:10.708Z |
5533599 | 5533599 | 20241113093031_KpAgj | US004J | 2024-11-14T14:02:28.938Z | 2024-11-22T14:24:10.360Z |
5533556 | 5533556 | 20241113092029_QY36i | US004J | 2024-11-14T14:02:23.505Z | 2024-11-22T14:24:10.092Z |
5533344 | 5533344 | 20241113083704_55D3w | US004J | 2024-11-14T14:01:45.212Z | 2024-11-22T14:24:08.558Z |
5533260 | 5533260 | 20241113080959_UiIXR | US004J | 2024-11-14T14:01:37.229Z | 2024-11-22T14:24:07.816Z |
5533240 | 5533240 | 20241113075809_pCSgP | US004J | 2024-11-14T14:01:33.099Z | 2024-11-22T14:24:07.717Z |
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);