participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "UK000S" 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 |
---|---|---|---|---|---|
5570003 | 5570003 | 20241120182336_22fr3 | UK000S | 2024-11-22T14:14:44.759Z | 2024-11-22T14:19:21.845Z |
5569783 | 5569783 | 20241120173150_X66Wl | UK000S | 2024-11-22T14:14:11.016Z | 2024-11-22T14:19:21.805Z |
5565470 | 5565470 | 20241120042920_9KRta | UK000S | 2024-11-21T14:18:50.199Z | 2024-11-22T14:21:47.482Z |
5565074 | 5565074 | 20241120035033_rvX54 | UK000S | 2024-11-21T14:18:28.545Z | 2024-11-22T14:21:41.348Z |
5564997 | 5564997 | 20241120034414_un24h | UK000S | 2024-11-21T14:18:18.614Z | 2024-11-22T14:21:40.203Z |
5564726 | 5564726 | 20241120032242_fX9NW | UK000S | 2024-11-21T14:17:59.726Z | 2024-11-22T14:21:35.943Z |
5564637 | 5564637 | 20241120031503_WJmj2 | UK000S | 2024-11-21T14:17:54.762Z | 2024-11-22T14:21:34.535Z |
5564426 | 5564426 | 20241120025723_V3rfT | UK000S | 2024-11-21T14:17:35.025Z | 2024-11-22T14:21:31.776Z |
5564401 | 5564401 | 20241120025250_gdKlR | UK000S | 2024-11-21T14:17:33.047Z | 2024-11-22T14:21:31.220Z |
5564238 | 5564238 | 20241120024056_lXHGV | UK000S | 2024-11-21T14:17:21.434Z | 2024-11-22T14:21:29.289Z |
5563912 | 5563912 | 20241120021523_fwa2R | UK000S | 2024-11-21T14:16:57.687Z | 2024-11-22T14:21:25.129Z |
5563815 | 5563815 | 20241120020655_3NYjF | UK000S | 2024-11-21T14:16:46.563Z | 2024-11-22T14:21:23.585Z |
5563638 | 5563638 | 20241120015409_NDtD6 | UK000S | 2024-11-21T14:16:31.285Z | 2024-11-22T14:21:20.285Z |
5563596 | 5563596 | 20241120015033_n2fMe | UK000S | 2024-11-21T14:16:26.527Z | 2024-11-22T14:21:19.611Z |
5563580 | 5563580 | 20241120014725_qG2GX | UK000S | 2024-11-21T14:16:25.361Z | 2024-11-22T14:21:19.371Z |
5563302 | 5563302 | 20241120011610_3tbmH | UK000S | 2024-11-21T14:15:52.136Z | 2024-11-22T14:21:12.594Z |
5563149 | 5563149 | 20241120005856_a8L3l | UK000S | 2024-11-21T14:15:38.500Z | 2024-11-22T14:21:10.151Z |
5563120 | 5563120 | 20241120005428_0MmQS | UK000S | 2024-11-21T14:15:37.406Z | 2024-11-22T14:21:09.868Z |
5562982 | 5562982 | 20241120003609_uhhB1 | UK000S | 2024-11-21T14:15:30.769Z | 2024-11-22T14:21:07.463Z |
5562692 | 5562692 | 20241120000409_kYvs2 | UK000S | 2024-11-21T14:15:17.226Z | 2024-11-22T14:21:02.583Z |
5562490 | 5562490 | 20241119234356_QWnVi | UK000S | 2024-11-21T14:15:01.604Z | 2024-11-22T14:20:59.423Z |
5562475 | 5562475 | 20241119234242_ZQWbH | UK000S | 2024-11-21T14:14:57.041Z | 2024-11-22T14:20:59.189Z |
5562463 | 5562463 | 20241119234035_rTPwP | UK000S | 2024-11-21T14:14:54.453Z | 2024-11-22T14:20:58.833Z |
5562390 | 5562390 | 20241119233355_M5NSf | UK000S | 2024-11-21T14:14:46.584Z | 2024-11-22T14:20:57.045Z |
5562338 | 5562338 | 20241119232748_gsc0w | UK000S | 2024-11-21T14:14:43.702Z | 2024-11-22T14:20:56.409Z |
5562185 | 5562185 | 20241119230853_SBsHs | UK000S | 2024-11-21T14:14:31.459Z | 2024-11-22T14:20:53.868Z |
5562169 | 5562169 | 20241119230641_5rV61 | UK000S | 2024-11-21T14:14:30.420Z | 2024-11-22T14:20:53.737Z |
5561577 | 5561577 | 20241119210932_5YHL8 | UK000S | 2024-11-21T14:13:29.792Z | 2024-11-22T14:20:41.218Z |
5561506 | 5561506 | 20241119205046_pkfsv | UK000S | 2024-11-21T14:13:22.755Z | 2024-11-22T14:20:39.073Z |
5561394 | 5561394 | 20241119202412_a7HnE | UK000S | 2024-11-21T14:13:12.975Z | 2024-11-22T14:20:34.466Z |
5561376 | 5561376 | 20241119201929_hp9Eg | UK000S | 2024-11-21T14:13:11.064Z | 2024-11-22T14:20:34.008Z |
5561329 | 5561329 | 20241119195748_hIfUb | UK000S | 2024-11-21T14:13:06.387Z | 2024-11-22T14:20:32.322Z |
5558488 | 5558488 | 20241120061428_t3kvy | UK000S | 2024-11-21T14:03:25.660Z | 2024-11-22T14:19:21.239Z |
5558179 | 5558179 | 20241120054237_zA8hM | UK000S | 2024-11-21T14:02:40.093Z | 2024-11-22T14:19:21.189Z |
5557793 | 5557793 | 20241120051207_YjHDn | UK000S | 2024-11-21T14:01:46.550Z | 2024-11-22T14:19:21.129Z |
5557647 | 5557647 | 20241120050344_jlK41 | UK000S | 2024-11-21T14:01:26.020Z | 2024-11-22T14:19:21.105Z |
5557527 | 5557527 | 20241120045342_7SdTj | UK000S | 2024-11-21T14:01:05.739Z | 2024-11-22T14:19:21.085Z |
5557343 | 5557343 | 20241120043954_wkyXy | UK000S | 2024-11-21T14:00:34.974Z | 2024-11-22T14:19:21.056Z |
5557287 | 5557287 | 20241120043404_uUNLx | UK000S | 2024-11-21T14:00:23.569Z | 2024-11-22T14:19:21.048Z |
5545019 | 5545019 | 20241115222019_CnKzT | UK000S | 2024-11-17T14:03:37.879Z | 2024-11-22T14:23:35.229Z |
5545010 | 5545010 | 20241115215807_9gULb | UK000S | 2024-11-17T14:03:36.442Z | 2024-11-22T14:23:35.144Z |
5544995 | 5544995 | 20241115213449_IYU3K | UK000S | 2024-11-17T14:03:34.463Z | 2024-11-22T14:23:35.037Z |
5544985 | 5544985 | 20241115205916_XR6ly | UK000S | 2024-11-17T14:03:33.649Z | 2024-11-22T14:23:35.000Z |
5543130 | 5543130 | 20241114212757_kQDJV | UK000S | 2024-11-16T14:05:35.423Z | 2024-11-22T14:23:57.063Z |
5543048 | 5543048 | 20241114191910_1KgY4 | UK000S | 2024-11-16T14:05:27.307Z | 2024-11-22T14:23:56.673Z |
5543029 | 5543029 | 20241114181349_8BQNO | UK000S | 2024-11-16T14:05:22.784Z | 2024-11-22T14:23:56.216Z |
5543017 | 5543017 | 20241114180216_wibJ0 | UK000S | 2024-11-16T14:05:18.442Z | 2024-11-22T14:23:56.118Z |
5543015 | 5543015 | 20241114180116_pfnXo | UK000S | 2024-11-16T14:05:16.839Z | 2024-11-22T14:23:56.107Z |
5542993 | 5542993 | 20241114173758_8ntN1 | UK000S | 2024-11-16T14:05:14.254Z | 2024-11-22T14:23:55.900Z |
5542989 | 5542989 | 20241114173328_SF3tt | UK000S | 2024-11-16T14:05:13.390Z | 2024-11-22T14:23:55.799Z |
5541220 | 5541220 | 20241113202056_875UL | UK000S | 2024-11-15T14:06:58.278Z | 2024-11-22T14:24:17.114Z |
5541217 | 5541217 | 20241113200953_dsIim | UK000S | 2024-11-15T14:06:57.840Z | 2024-11-22T14:24:17.069Z |
5541207 | 5541207 | 20241113194339_QBSdP | UK000S | 2024-11-15T14:06:56.636Z | 2024-11-22T14:24:16.903Z |
5537252 | 5537252 | 20241112213052_V5g2j | UK000S | 2024-11-14T14:11:27.196Z | 2024-11-21T14:26:10.701Z |
5537248 | 5537248 | 20241112212708_AQhEE | UK000S | 2024-11-14T14:11:25.518Z | 2024-11-21T14:26:10.683Z |
5532699 | 5532699 | 20241112055354_42gIk | UK000S | 2024-11-13T14:17:10.755Z | 2024-11-20T14:26:25.716Z |
5532678 | 5532678 | 20241112055201_cRjHr | UK000S | 2024-11-13T14:17:08.893Z | 2024-11-20T14:26:25.607Z |
5532540 | 5532540 | 20241112053628_7NWEH | UK000S | 2024-11-13T14:16:58.751Z | 2024-11-20T14:26:24.470Z |
5532529 | 5532529 | 20241112053424_4ovDY | UK000S | 2024-11-13T14:16:57.549Z | 2024-11-20T14:26:24.284Z |
5532473 | 5532473 | 20241112052812_4BBgp | UK000S | 2024-11-13T14:16:51.697Z | 2024-11-20T14:26:23.824Z |
5532264 | 5532264 | 20241112050113_4B6Hy | UK000S | 2024-11-13T14:16:32.298Z | 2024-11-20T14:26:21.488Z |
5532167 | 5532167 | 20241112044706_a7zrw | UK000S | 2024-11-13T14:16:24.226Z | 2024-11-20T14:26:20.546Z |
5532138 | 5532138 | 20241112044031_RkQTF | UK000S | 2024-11-13T14:16:21.530Z | 2024-11-20T14:26:20.179Z |
5531939 | 5531939 | 20241112042132_TEyhF | UK000S | 2024-11-13T14:16:03.174Z | 2024-11-20T14:26:16.386Z |
5531851 | 5531851 | 20241112041322_XybJW | UK000S | 2024-11-13T14:15:59.016Z | 2024-11-20T14:26:15.276Z |
5531797 | 5531797 | 20241112040959_4QB9e | UK000S | 2024-11-13T14:15:55.501Z | 2024-11-20T14:26:14.594Z |
5531773 | 5531773 | 20241112040839_JoyPT | UK000S | 2024-11-13T14:15:54.537Z | 2024-11-20T14:26:14.263Z |
5531652 | 5531652 | 20241112035730_bPtix | UK000S | 2024-11-13T14:15:48.836Z | 2024-11-20T14:26:13.038Z |
5531619 | 5531619 | 20241112035341_s7QvV | UK000S | 2024-11-13T14:15:46.809Z | 2024-11-20T14:26:12.784Z |
5531526 | 5531526 | 20241112034705_xDmWY | UK000S | 2024-11-13T14:15:43.905Z | 2024-11-20T14:26:12.095Z |
5531453 | 5531453 | 20241112034035_XVcr2 | UK000S | 2024-11-13T14:15:40.504Z | 2024-11-20T14:26:11.374Z |
5531355 | 5531355 | 20241112033335_rzhbH | UK000S | 2024-11-13T14:15:35.512Z | 2024-11-20T14:26:10.456Z |
5531309 | 5531309 | 20241112033136_R6Kik | UK000S | 2024-11-13T14:15:34.155Z | 2024-11-20T14:26:10.346Z |
5531290 | 5531290 | 20241112032916_Uq4oI | UK000S | 2024-11-13T14:15:33.101Z | 2024-11-20T14:26:09.986Z |
5531282 | 5531282 | 20241112032840_FEDCd | UK000S | 2024-11-13T14:15:32.770Z | 2024-11-20T14:26:09.975Z |
5531249 | 5531249 | 20241112032556_pDsI2 | UK000S | 2024-11-13T14:15:31.702Z | 2024-11-20T14:26:09.543Z |
5531172 | 5531172 | 20241112031935_CrCLa | UK000S | 2024-11-13T14:15:22.131Z | 2024-11-20T14:26:08.418Z |
5530988 | 5530988 | 20241112030429_hPE2K | UK000S | 2024-11-13T14:14:58.738Z | 2024-11-20T14:26:05.814Z |
5530973 | 5530973 | 20241112030334_xk9Lx | UK000S | 2024-11-13T14:14:57.361Z | 2024-11-20T14:26:05.737Z |
5530774 | 5530774 | 20241112024610_EQxZ1 | UK000S | 2024-11-13T14:14:37.417Z | 2024-11-20T14:26:03.449Z |
5530463 | 5530463 | 20241112022046_r4b4r | UK000S | 2024-11-13T14:14:17.297Z | 2024-11-20T14:26:00.566Z |
5530322 | 5530322 | 20241112020747_6fpxx | UK000S | 2024-11-13T14:14:08.485Z | 2024-11-20T14:25:56.967Z |
5530262 | 5530262 | 20241112020304_p8ZSp | UK000S | 2024-11-13T14:14:05.019Z | 2024-11-20T14:25:56.269Z |
5530171 | 5530171 | 20241112015357_Se1c6 | UK000S | 2024-11-13T14:13:59.895Z | 2024-11-20T14:25:55.094Z |
5529904 | 5529904 | 20241112011946_3iYkA | UK000S | 2024-11-13T14:13:21.647Z | 2024-11-20T14:25:50.891Z |
5529861 | 5529861 | 20241112011329_YBdzv | UK000S | 2024-11-13T14:13:16.930Z | 2024-11-20T14:25:50.073Z |
5529761 | 5529761 | 20241112010340_l9Aae | UK000S | 2024-11-13T14:13:09.732Z | 2024-11-20T14:25:48.059Z |
5529566 | 5529566 | 20241112003619_p22Xe | UK000S | 2024-11-13T14:12:58.641Z | 2024-11-20T14:25:46.298Z |
5529545 | 5529545 | 20241112003306_borKW | UK000S | 2024-11-13T14:12:57.245Z | 2024-11-20T14:25:46.227Z |
5529507 | 5529507 | 20241112002902_FNvhS | UK000S | 2024-11-13T14:12:55.131Z | 2024-11-20T14:25:45.774Z |
5529504 | 5529504 | 20241112002841_KYCdI | UK000S | 2024-11-13T14:12:55.010Z | 2024-11-20T14:25:45.754Z |
5529500 | 5529500 | 20241112002719_2mV38 | UK000S | 2024-11-13T14:12:54.763Z | 2024-11-20T14:25:45.719Z |
5529476 | 5529476 | 20241112002410_sD5o8 | UK000S | 2024-11-13T14:12:53.249Z | 2024-11-20T14:25:45.450Z |
5529420 | 5529420 | 20241112001740_942rh | UK000S | 2024-11-13T14:12:43.388Z | 2024-11-20T14:25:44.621Z |
5529313 | 5529313 | 20241112000048_Dp53Y | UK000S | 2024-11-13T14:12:21.467Z | 2024-11-20T14:25:42.767Z |
5529305 | 5529305 | 20241112000024_TINoe | UK000S | 2024-11-13T14:12:21.120Z | 2024-11-20T14:25:42.683Z |
5528825 | 5528825 | 20241111224803_LGUof | UK000S | 2024-11-13T14:11:28.652Z | 2024-11-20T14:25:36.402Z |
5528789 | 5528789 | 20241111223955_eiMuP | UK000S | 2024-11-13T14:11:26.827Z | 2024-11-20T14:25:35.852Z |
5528523 | 5528523 | 20241111212245_BPSHE | UK000S | 2024-11-13T14:11:03.346Z | 2024-11-20T14:25:31.852Z |
5528500 | 5528500 | 20241111211303_x7UIP | UK000S | 2024-11-13T14:10:55.437Z | 2024-11-20T14:25:31.422Z |
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);