names

81 rows where place_id = 678692

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4032674 2036337 2036337 plaintiff Gibbons Nicholas   678692 678692 Gibbons, Nicholas, of Hampshire 0
4033826 2036749 2036749 plaintiff Gybbons Nicholas yeoman 678692 678692 Gybbons, Nicholas, of Hampshire, yeoman 0
4039896 2038891 2038891 plaintiff Mascall James gent 678692 678692 Mascall, James, of Hampshire, gent 0
4140347 2074792 2074792 defendant Snowe Leonard yeoman 678692 678692 Snowe, Leonard, of Hampshire, yeoman 0
4408402 2167384 2167384 defendant Kingewell Richard gent 678692 678692 Kingewell, Richard, of Hampshire, gent 1
4426899 2173233 2173233 defendant Dunclent Joan of Hampshire 678692 678692 Joan, his wife, of Hampshire 1
4433420 2175213 2175213 defendant Burgham John de   678692 678692 Burgham, John de, of Hampshire 1
4436539 2176166 2176166 plaintiff Spenser John le   678692 678692 Spenser, John le, of Hampshire 0
4439394 2181586 2181586 defendant Keme Thomas   678692 678692 Keme, Thomas, of Hampshire 3
4440238 2181860 2181860 defendant Horwode William   678692 678692 Horwode, William, of Hampshire 0
4443986 2183086 2183086 defendant Kenne Thomas   678692 678692 Kenne, Thomas, of Hampshire 0
4449920 2184930 2184930 defendant Wymeldon William   678692 678692 Wymeldon, William, of Hampshire 4
4449926 2184931 2184931 defendant Wymeldon William   678692 678692 Wymeldon, William, of Hampshire 4
4450831 2185226 2185226 defendant atte Bere John   678692 678692 atte Bere, John, of Hampshire 1
4463883 2189381 2189381 defendant Kenne Thomas   678692 678692 Kenne, Thomas, of Hampshire 3
4479361 2194196 2194196 defendant Elye John   678692 678692 Elye, John, of Hampshire 1
4484397 2195811 2195811 defendant Fauconer William   678692 678692 Fauconer, William, of Hampshire 2
4490220 2197645 2197645 defendant Trenchard William   678692 678692 Trenchard, William, of Hampshire 2
4490248 2197650 2197650 defendant Trenchard William   678692 678692 Trenchard, William, of Hampshire 2
4496235 2199496 2199496 defendant Coche Robert   678692 678692 Coche, Robert, of Hampshire 2
4516434 2205549 2205549 defendant Colette William (legal representative) 678692 678692 Colette, William, of Hampshire, executors of 0
4516439 2205550 2205550 defendant Cok William (legal representative) 678692 678692 Cok, William, of Hampshire, executor of 0
4532766 2210520 2210520 defendant Bridde Richard   678692 678692 Bridde, Richard, of Hampshire 0
4538995 2212463 2212463 defendant Baker George   678692 678692 Baker, George, of Hampshire 0
4540951 2213076 2213076 plaintiff Wiggele William   678692 678692 Wiggele, William, of Hampshire 0
4543230 2213766 2213766 defendant Geste Richard   678692 678692 Geste, Richard, of Hampshire 0
4547290 2215086 2215086 defendant Norton John   678692 678692 Norton, John, of Hampshire 0
4548495 2215470 2215470 defendant Amereke John   678692 678692 Amereke, John, of Hampshire 4
4548496 2215470 2215470 defendant Amereke William   678692 678692 Amereke, William, of Hampshire 5
4554639 2217377 2217377 defendant Pyn Philip   678692 678692 Pyn, Philip, of Hampshire 0
4568279 2221648 2221648 defendant Amereke John   678692 678692 Amereke, John, of Hampshire 4
4568280 2221648 2221648 defendant Amereke William   678692 678692 Amereke, William, of Hampshire 5
4580149 2225278 2225278 defendant Everyngton Nicholas   678692 678692 Everyngton, Nicholas, of Hampshire 0
4581651 2225709 2225709 defendant Ryngebourn William   678692 678692 Ryngebourn, William, of Hampshire 3
4581659 2225710 2225710 defendant Ryngebourne William   678692 678692 Ryngebourne, William, of Hampshire 3
4582668 2226020 2226020 defendant Ryngebourn William   678692 678692 Ryngebourn, William, of Hampshire 0
4582672 2226021 2226021 defendant Ryngeburn William   678692 678692 Ryngeburn, William, of Hampshire 0
4585889 2227008 2227008 defendant Payn John   678692 678692 Payn, John, of Hampshire 4
4588224 2227711 2227711 defendant Twyford William   678692 678692 Twyford, William, of Hampshire 2
4588228 2227712 2227712 defendant Twyford William   678692 678692 Twyford, William, of Hampshire 2
4590697 2228445 2228445 defendant Tauk Thomas   678692 678692 Tauk, Thomas, of Hampshire 2
4595041 2229707 2229707 defendant Bryd Richard   678692 678692 Bryd, Richard, of Hampshire 0
4603243 2232218 2232218 defendant Wollance William   678692 678692 Wollance, William, of Hampshire 1
4603252 2232220 2232220 defendant Wollane William   678692 678692 Wollane, William, of Hampshire 2
4603385 2232250 2232250 defendant Brantham John   678692 678692 Brantham, John, of Hampshire 6
4603393 2232252 2232252 defendant Swayne Richard   678692 678692 Swayne, Richard, of Hampshire 4
4603394 2232252 2232252 defendant Groteham John   678692 678692 Groteham, John, of Hampshire 5
4605006 2232725 2232725 defendant Nowell John   678692 678692 Nowell, John, of Hampshire 0
4606827 2233244 2233244 defendant atte Welle Walter   678692 678692 atte Welle, Walter, of Hampshire 0
4615360 2235812 2235812 defendant Randolf Philip   678692 678692 Randolf, Philip, of Hampshire 1
4621293 2237648 2237648 plaintiff Kyrkeby John esq 678692 678692 Kyrkeby, John, of Hampshire, esq 0
4624475 2238640 2238640 plaintiff Newport alias Spicer Richard esq 678692 678692 Newport alias Spicer, Richard, of Hampshire, esq 0
4625427 2238917 2238917 defendant Gotkynglegh Richard (legal representative) 678692 678692 Gotkynglegh, Richard, of Hampshire, executors of 0
4628243 2239760 2239760 defendant Chamburleyn Robert   678692 678692 Chamburleyn, Robert, of Hampshire 0
4639755 2243134 2243134 defendant Wayte Richard   678692 678692 Wayte, Richard, of Hampshire 6
4659000 2248686 2248686 plaintiff Dakcombe John   678692 678692 Dakcombe, John, of Hampshire 0
4689415 2262249 2262249 plaintiff Uvedale John   678692 678692 Uvedale, John, of Hampshire, lately sheriff 0
4699214 2265221 2265221 plaintiff Doraunt Peter   678692 678692 Doraunt, Peter, of Hampshire 0
4730416 2274709 2274709 plaintiff Malton John clerk 678692 678692 Malton, John, of Hampshire, clerk 0
4852137 2312098 2312098 plaintiff Warbilton William esq 678692 678692 Warbilton, William, of Hampshire, esq 0
4852139 2312099 2312099 plaintiff Warbilton William esq 678692 678692 Warbilton, William, of Hampshire, esq 0
5008467 2359371 2359371 plaintiff Tailard John   678692 678692 Tailard, John, of Hampshire 0
5040418 2368738 2368738 plaintiff Bruyne Henry esq 678692 678692 Bruyne, Henry, of Hampshire, esq 0
5040420 2368739 2368739 plaintiff Bruyne Henry esq 678692 678692 Bruyne, Henry, of Hampshire, esq 0
5041858 2369163 2369163 defendant Palmer Hugh mercer 678692 678692 Palmer, Hugh, of Hampshire, mercer 0
5126747 2394299 2394299 defendant Oglond Robert gent 678692 678692 Oglond, Robert, of Hampshire, gent 1
5366245 2465104 2465104 plaintiff Brocas John   678692 678692 Brocas, John, of Hampshire, sheriff 0
5395799 2473884 2473884 plaintiff Barkeley Edward   678692 678692 Barkeley, Edward, of Hampshire, sheriff 0
5395805 2473885 2473885 plaintiff Barkeley Edward   678692 678692 Barkeley, Edward, of Hampshire, sheriff 0
5395807 2473886 2473886 plaintiff Barkeley Edward   678692 678692 Barkeley, Edward, of Hampshire, sheriff 0
5396938 2474209 2474209 plaintiff Brocas John esq & sheriff 678692 678692 Brocas, John, of Hampshire, esq & sheriff 0
5408328 2477463 2477463 defendant Frelond Edward gent 678692 678692 Frelond, Edward, of Hampshire, gent 0
5425963 2482723 2482723 plaintiff Cook John esq & formerly sheriff 678692 678692 Cook, John, of Hampshire, esq & formerly sheriff 0
5427897 2483297 2483297 defendant Whyte William (legal representative) 678692 678692 Whyte, William, of Hampshire, executor of 0
5427900 2483298 2483298 defendant Whyte William (legal representative) 678692 678692 Whyte, William, of Hampshire, executor of 0
5450635 2490073 2490073 defendant (not given) William prior of Westcarre 678692 678692 Westcarre, William, of Hampshire, prior of the canons of Montesfont 0
5453371 2490895 2490895 defendant Baily Richard gent 678692 678692 Baily, Richard, of Hampshire, gent 0
5454224 2491167 2491167 defendant White William (legal representative) 678692 678692 White, William, of Hampshire, executor of 0
5474279 2497286 2497286 plaintiff Quynby Henry   678692 678692 Quynby, Henry, of Hampshire 0
5621007 2550444 2550444 defendant Byflete John   678692 678692 Byflete, John, of Hampshire 1
5621008 2550444 2550444 defendant Bury Alexander   678692 678692 Bury, Alexander, of Hampshire 2

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);