names

133 rows where place_id = 587307

✎ 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
3591032 1864821 1864821 plaintiff Glover Thomas   587307 587307 (Glover, Thomas, of Walyngford 1
3592519 1865275 1865275 plaintiff Glover Thomas   587307 587307 Glover, Thomas, of Walyngford 0
3637393 1906502 1906502 defendant Smyth John cordwainer 587307 587307 Smyth, John, of Walyngford, cordwainer 3
3669743 1916484 1916484 defendant Porter John mercer 587307 587307 Porter, John, of Walyngford, mercer 0
3710372 1929562 1929562 defendant Hamond Richard tailor 587307 587307 Hamond, Richard, of Walyngford, tailor 0
3755023 1943519 1943519 plaintiff Walker Robert   587307 587307 Walker, Robert, of Walyngford 0
3755691 1943739 1943739 defendant Lynes Philip tanner 587307 587307 Lynes, Philip, of Walyngford, tanner 0
3755692 1943739 1943739 defendant Launcelotte Robert miller 587307 587307 Launcelotte, Robert, of Walyngford, miller 1
3761390 1945574 1945574 defendant Frenche Robert yeoman 587307 587307 Frenche, Robert, of Walyngford, yeoman 0
3790471 1954842 1954842 defendant Osbalston Lambert beer brewer 587307 587307 Osbalston, Lambert, of Walyngford, beer brewer 0
3893629 1988097 1988097 plaintiff Pollyngton Thomas mercer 587307 587307 Pollyngton, Thomas, of Walyngford, mercer 0
3901347 1990671 1990671 defendant Watson Thomas butcher 587307 587307 Watson, Thomas, of Walyngford, butcher 0
4412920 2168917 2168917 defendant Iremonger Richard le   587307 587307 Iremonger, Richard le, of Walyngford 0
4413195 2168999 2168999 plaintiff atte Ruyussh John   587307 587307 atte Ruyussh, John, of Walyngford 0
4415765 2169818 2169818 plaintiff Iremonger Richard le   587307 587307 Iremonger, Richard le, of Walyngford 0
4415766 2169818 2169818 defendant Absolon Alexander   587307 587307 Absolon, Alexander, of Walyngford 0
4415769 2169820 2169820 plaintiff Irenmongere Richard le   587307 587307 Irenmongere, Richard le, of Walyngford 0
4418215 2170580 2170580 defendant Harewell William de   587307 587307 Harewell, William de, of Walyngford 0
4424450 2172488 2172488 plaintiff Iremonger Richard le   587307 587307 Iremonger, Richard le, of Walyngford 0
4424451 2172488 2172488 defendant Absolon Alexander   587307 587307 Absolon, Alexander, of Walyngford 0
4437267 2176404 2176404 defendant Harewell William de   587307 587307 Harewell, William de, of Walyngford 0
4437827 2181154 2181154 defendant Broun John   587307 587307 Broun, John, of Walyngford 0
4438735 2181406 2181406 plaintiff atte Feld Richard   587307 587307 atte Feld, Richard, of Walyngford, on his own account 0
4446728 2183893 2183893 defendant Cary William   587307 587307 Cary, William, of Walyngford 0
4452268 2185696 2185696 plaintiff James John   587307 587307 James, John, of Walyngford 0
4452270 2185697 2185697 plaintiff James John   587307 587307 James, John, of Walyngford 0
4459235 2187932 2187932 defendant Baker John   587307 587307 Baker, John, of Walyngford 1
4459236 2187932 2187932 defendant Londeneys John   587307 587307 Londeneys, John, of Walyngford 2
4463860 2189373 2189373 defendant Bakere John   587307 587307 Bakere, John, of Walyngford 0
4485045 2196022 2196022 defendant Derby Richard   587307 587307 Derby, Richard, of Walyngford 1
4485050 2196023 2196023 defendant Derby Richard   587307 587307 Derby, Richard, of Walyngford 1
4501808 2201162 2201162 defendant Benshene John   587307 587307 Benshene, John, of Walyngford 0
4516906 2205692 2205692 plaintiff Coterell John   587307 587307 Coterell, John, of Walyngford 0
4519846 2206558 2206558 defendant Lytle John   587307 587307 Lytle, John, of Walyngford 2
4522621 2207413 2207413 defendant Turnour Richard   587307 587307 Turnour, Richard, of Walyngford 1
4525124 2208201 2208201 plaintiff Hyndon Walter   587307 587307 Hyndon, Walter, of Walyngford 0
4525125 2208201 2208201 defendant Baker Richard   587307 587307 Baker, Richard, of Walyngford 0
4537828 2212111 2212111 defendant Smyth Thomas   587307 587307 Smyth, Thomas, of Walyngford 2
4538977 2212458 2212458 defendant Corynyssh Peter   587307 587307 Corynyssh, Peter, of Walyngford 0
4539880 2212735 2212735 defendant Smyth Thomas   587307 587307 Smyth, Thomas, of Walyngford 0
4551216 2216322 2216322 defendant Ruyhale John   587307 587307 Ruyhale, John, of Walyngford 1
4580996 2225534 2225534 defendant Beryman William   587307 587307 Beryman, William, of Walyngford 0
4581755 2225734 2225734 defendant Lepere John   587307 587307 Lepere, John, of Walyngford 2
4603266 2232223 2232223 defendant James Walter   587307 587307 James, Walter, of Walyngford, servant of Christian James 1
4610407 2234331 2234331 defendant Bakere Roger   587307 587307 Bakere, Roger, of Walyngford 0
4613779 2235327 2235327 plaintiff Derby John   587307 587307 Derby, John, of Walyngford 0
4637632 2242554 2242554 defendant dyer Richard   587307 587307 dyer, Richard, of Walyngford 1
4646496 2245040 2245040 defendant Canyell Thomas   587307 587307 Canyell, Thomas, of Walyngford 0
4666410 2250970 2250970 defendant Dynby John   587307 587307 Dynby, John, of Walyngford 0
4666411 2250970 2250970 defendant Chapman Richard   587307 587307 Chapman, Richard, of Walyngford, linen draper 1
4673926 2257461 2257461 plaintiff Derby John   587307 587307 Derby, John, of Walyngford, on his own account 0
4680051 2259368 2259368 plaintiff Gailer John   587307 587307 Gailer, John, of Walyngford 1
4711995 2269062 2269062 defendant Flynt William Barber 587307 587307 Flynt, William, of Walyngford, Barber 0
4742647 2278354 2278354 defendant Holand John spicer 587307 587307 Holand, John, of Walyngford, spicer 0
4786953 2291982 2291982 defendant Browode John husbandman 587307 587307 Browode, John, of Walyngford, husbandman 0
4846890 2310535 2310535 defendant Motte William husbandman 587307 587307 Motte, William, of Walyngford, husbandman 0
4874983 2319122 2319122 defendant Motte William husbandman 587307 587307 Motte, William, of Walyngford, husbandman 0
4890676 2323838 2323838 defendant Peytevyn Stephen   587307 587307 Peytevyn, Stephen, of Walyngford, Berks chapman 1
4896414 2325545 2325545 defendant Dowese John husbandman 587307 587307 Dowese, John, of Walyngford, husbandman 0
4926939 2334854 2334854 defendant Peytevyn Stephen chapman 587307 587307 Peytevyn, Stephen, of Walyngford, chapman 1
4929325 2335590 2335590 plaintiff Stoke John   587307 587307 Stoke, John, of Walyngford, prior 0
4971820 2348500 2348500 defendant Cloute William yeoman 587307 587307 Cloute, William, of Walyngford, yeoman 0
4980524 2351114 2351114 defendant Warfeld John gent 587307 587307 Warfeld, John, of Walyngford, gent 2
4986070 2352755 2352755 defendant Warfeld John gent 587307 587307 Warfeld, John, of Walyngford, gent 1
4986422 2352865 2352865 defendant Warfeld John   587307 587307 Warfeld, John, of Walyngford 0
5004181 2358114 2358114 defendant Warefeld John husbandman 587307 587307 Warefeld, John, of Walyngford, husbandman 1
5021262 2363118 2363118 defendant Denby Hugh chapman 587307 587307 Denby, Hugh, of Walyngford, chapman 0
5035442 2367224 2367224 defendant Bodynton William yeoman 587307 587307 Bodynton, William, of Walyngford, yeoman 0
5035444 2367224 2367224 defendant Absolon Thomas yeoman 587307 587307 Absolon, Thomas, of Walyngford, yeoman 2
5038687 2368218 2368218 defendant (not given) John prior of Wellys 587307 587307 Wellys, John, of Walyngford, prior of the house & church of Holy Trinity 0
5048279 2371120 2371120 defendant Pernecote Thomas (legal representative) 587307 587307 Pernecote, Thomas, of Walyngford, chapman, executor of 0
5048285 2371121 2371121 defendant Pernecote Thomas (legal representative) 587307 587307 Pernecote, Thomas, of Walyngford, chapman, executor of 0
5049262 2371411 2371411 defendant Wellys William   587307 587307 Wellys, William, of Walyngford, Berks, prior 0
5051260 2371990 2371990 defendant Pleyour Thomas husbandman 587307 587307 Pleyour, Thomas, of Walyngford, husbandman 0
5066461 2376496 2376496 defendant Absolon Thomas yeoman 587307 587307 Absolon, Thomas, of Walyngford, yeoman 0
5076371 2379433 2379433 defendant Dowese John cordwainer 587307 587307 Dowese, John, of Walyngford, cordwainer 1
5076372 2379433 2379433 defendant West Robert carpenter 587307 587307 West, Robert, of Walyngford, carpenter 2
5076854 2379571 2379571 defendant Bottesford John yeoman 587307 587307 Bottesford, John, of Walyngford, yeoman 0
5076857 2379572 2379572 defendant Bottesford John yeoman 587307 587307 Bottesford, John, of Walyngford, yeoman 0
5090073 2383468 2383468 defendant Chone John husbandman 587307 587307 Chone, John, of Walyngford, husbandman 0
5090075 2383468 2383468 defendant Abselon Thomas husbandman 587307 587307 Abselon, Thomas, of Walyngford, husbandman 2
5092297 2384126 2384126 defendant Rumwode William butcher 587307 587307 Rumwode, William, of Walyngford, butcher 0
5092298 2384126 2384126 defendant Pede Thomas husbandman 587307 587307 Pede, Thomas, of Walyngford, husbandman 1
5096058 2385279 2385279 defendant Morpath Stephen clerk 587307 587307 Morpath, Stephen, of Walyngford, clerk 0
5108324 2388872 2388872 defendant Alsolon Thomas husbandman 587307 587307 Alsolon, Thomas, of Walyngford, husbandman 0
5108325 2388872 2388872 defendant Forde Nicholas yeoman 587307 587307 Forde, Nicholas, of Walyngford, yeoman 1
5108326 2388872 2388872 defendant Broun John skinner 587307 587307 Broun, John, of Walyngford, skinner 2
5117702 2391614 2391614 plaintiff Prys or Pryce Richard chapman 587307 587307 Prys or Pryce, Richard, of Walyngford, chapman 0
5123146 2393204 2393204 defendant Warfeld John   587307 587307 Warfeld, John, of Walyngford 0
5126003 2394090 2394090 defendant Dons or Dous John chapman 587307 587307 Dons or Dous, John, of Walyngford, chapman 0
5138172 2397675 2397675 defendant Bayly Thomas yeoman 587307 587307 Bayly, Thomas, of Walyngford, yeoman 0
5158921 2403727 2403727 defendant Bayly Thomas yeoman 587307 587307 Bayly, Thomas, of Walyngford, yeoman 0
5230200 2424451 2424451 defendant Pleystowe John fisher 587307 587307 Pleystowe, John, of Walyngford, fisher 3
5251364 2430524 2430524 defendant Berewell Richard yeoman 587307 587307 Berewell, Richard, of Walyngford, yeoman 0
5277088 2438386 2438386 plaintiff Adams Hugh yeoman 587307 587307 Adams, Hugh, of Walyngford, yeoman 0
5296598 2443992 2443992 defendant Massay or Maffay Henry butcher 587307 587307 Massay or Maffay, Henry, of Walyngford, butcher 0
5296599 2443992 2443992 defendant Gaye William   587307 587307 Gaye, William, of Walyngford, tallow chandler 1
5344391 2458425 2458425 defendant Botun Maud widow 587307 587307 Botun, Maud, of Walyngford, widow 1
5344392 2458425 2458425 defendant Bokelond Richard smith 587307 587307 Bokelond, Richard, of Walyngford, smith 2
5352092 2460762 2460762 defendant Glaswas William gent 587307 587307 Glaswas, William, of Walyngford, gent 0

Next page

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);