names

59 rows where place_id = 655167

✎ 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
3935191 2002079 2002079 defendant Sibthorpe alias Dyer William   655167 655167 Sibthorpe alias Dyer, William, of Newport Pagnell 1
4470404 2191393 2191393 plaintiff Brokkele William (legal representative) 655167 655167 Brokkele, William, of Newport Pagnell, executors of 0
4554221 2217247 2217247 defendant Prene Walter butcher 655167 655167 Prene, Walter, of Newport Pagnell, butcher 0
4568249 2221641 2221641 defendant Pountfreyt John   655167 655167 Pountfreyt, John, of Newport Pagnell 0
4568251 2221641 2221641 defendant Milnere John   655167 655167 Milnere, John, of Newport Pagnell 2
4586589 2227215 2227215 defendant Chircche Richard   655167 655167 Chircche, Richard, of Newport Pagnell 0
4587684 2227553 2227553 defendant Chicche Richard   655167 655167 Chicche, Richard, of Newport Pagnell 0
4600911 2231510 2231510 defendant Stoteville Thomas   655167 655167 Stoteville, Thomas, of Newport Pagnell 0
4604928 2232703 2232703 defendant Belasise John mercer 655167 655167 Belasise, John, of Newport Pagnell, mercer 0
4612777 2235062 2235062 defendant Trikelowe Simon   655167 655167 Trikelowe, Simon, of Newport Pagnell 0
4631914 2240867 2240867 plaintiff Toures Richard   655167 655167 Toures, Richard, of Newport Pagnell 0
4639691 2243124 2243124 defendant Trikelowe Simon   655167 655167 Trikelowe, Simon, of Newport Pagnell 2
4639698 2243125 2243125 defendant Trikelowe Simon   655167 655167 Trikelowe, Simon, of Newport Pagnell 2
4645919 2244878 2244878 defendant Woder Richard   655167 655167 Woder, Richard, of Newport Pagnell 0
4668239 2255777 2255777 defendant Chicche Richard butcher 655167 655167 Chicche, Richard, of Newport Pagnell, butcher 0
4671228 2256656 2256656 defendant Bakere John husbandman 655167 655167 Bakere, John, of Newport Pagnell, husbandman 1
4692947 2263304 2263304 defendant Prone or Prove Walter butcher 655167 655167 Prone or Prove, Walter, of Newport Pagnell, butcher 0
4695831 2264180 2264180 defendant Toures Rihcard gent 655167 655167 Toures, Rihcard, of Newport Pagnell, gent 0
4695833 2264180 2264180 defendant Morecroft Henry gent 655167 655167 Morecroft, Henry, of Newport Pagnell, gent 2
4704220 2266696 2266696 defendant Ferrour Adam tailor 655167 655167 Ferrour, Adam, of Newport Pagnell, tailor 0
4709731 2268402 2268402 defendant Prene Walter butcher 655167 655167 Prene, Walter, of Newport Pagnell, butcher 2
4710244 2268557 2268557 plaintiff Prudde John husbandman 655167 655167 Prudde, John, of Newport Pagnell, husbandman 0
4710245 2268557 2268557 defendant Somenour Thomas husbandman 655167 655167 Somenour, Thomas, of Newport Pagnell, husbandman 0
4714467 2269856 2269856 plaintiff Toures Richard   655167 655167 Toures, Richard, of Newport Pagnell 0
4714470 2269856 2269856 defendant Clerk Robert   655167 655167 Clerk, Robert, of Newport Pagnell, holy water clerk 1
4714471 2269857 2269857 plaintiff Toures Richard   655167 655167 Toures, Richard, of Newport Pagnell 0
4714474 2269857 2269857 defendant Clerk Robert   655167 655167 Clerk, Robert, of Newport Pagnell, holy water clerk 1
4716410 2270450 2270450 defendant Belassis Richard mercer 655167 655167 Belassis, Richard, of Newport Pagnell, mercer 0
4718365 2271084 2271084 defendant Cretelyng John mercer 655167 655167 Cretelyng, John, of Newport Pagnell, mercer 0
4718366 2271084 2271084 defendant Pyryton John laborer 655167 655167 Pyryton, John, of Newport Pagnell, laborer 1
4718686 2271184 2271184 defendant Walrad John fuller 655167 655167 Walrad, John, of Newport Pagnell, fuller 0
4720279 2271685 2271685 defendant Proudfoot John butcher 655167 655167 Proudfoot, John, of Newport Pagnell, butcher 0
4721895 2272180 2272180 defendant Toures Richard husbandman 655167 655167 Toures, Richard, of Newport Pagnell, husbandman 1
4723059 2272522 2272522 defendant Taillour Adam yeoman 655167 655167 Taillour, Adam, of Newport Pagnell, yeoman 0
4736939 2276682 2276682 plaintiff Towres Richard   655167 655167 Towres, Richard, of Newport Pagnell 0
4736943 2276683 2276683 plaintiff Towres Richard   655167 655167 Towres, Richard, of Newport Pagnell 0
4740417 2277712 2277712 defendant Brythe John fisher 655167 655167 Brythe, John, of Newport Pagnell, fisher 0
4749528 2280342 2280342 defendant Makepes William chapman 655167 655167 Makepes, William, of Newport Pagnell, chapman 1
4766951 2285650 2285650 defendant Parys John butcher 655167 655167 Parys, John, of Newport Pagnell, butcher 1
4803439 2297263 2297263 defendant Parysshe John butcher 655167 655167 Parysshe, John, of Newport Pagnell, butcher 0
4810964 2299546 2299546 defendant Hobbes Henry husbandman 655167 655167 Hobbes, Henry, of Newport Pagnell, husbandman 1
4813587 2300357 2300357 plaintiff Potter Nicholas husbandman 655167 655167 Potter, Nicholas, of Newport Pagnell, husbandman 1
4835651 2307142 2307142 defendant Smyth Ralph smith 655167 655167 Smyth, Ralph, of Newport Pagnell, smith 0
4836133 2307281 2307281 defendant Taillour Adam tailor 655167 655167 Taillour, Adam, of Newport Pagnell, tailor 1
4836135 2307281 2307281 defendant Prudde Margaret widow 655167 655167 Prudde, Margaret, of Newport Pagnell, widow 3
4837877 2307776 2307776 defendant Potter William husbandman 655167 655167 Potter, William, of Newport Pagnell, husbandman 1
4909007 2329361 2329361 defendant Adam Robert husbandman 655167 655167 Adam, Robert, of Newport Pagnell, husbandman 0
4999693 2356785 2356785 defendant Astwode John gent 655167 655167 Astwode, John, of Newport Pagnell, gent 0
4999694 2356786 2356786 plaintiff Levenoth Simon   655167 655167 Levenoth, Simon, of Newport Pagnell 0
5162211 2404680 2404680 defendant Strenger William chapman 655167 655167 Strenger, William, of Newport Pagnell, chapman 0
5162219 2404680 2404680 defendant Barker John tanner 655167 655167 Barker, John, of Newport Pagnell, tanner 8
5162220 2404680 2404680 defendant Barker Robert yeoman 655167 655167 Barker, Robert, of Newport Pagnell, yeoman 9
5162232 2404682 2404682 defendant Deyster Robert butcher 655167 655167 Deyster, Robert, of Newport Pagnell, butcher 4
5162238 2404683 2404683 defendant Deyster Robert butcher 655167 655167 Deyster, Robert, of Newport Pagnell, butcher 4
5176383 2408779 2408779 defendant Deyster Robert butcher 655167 655167 Deyster, Robert, of Newport Pagnell, butcher 4
5188826 2412461 2412461 defendant Chambur John husbandman 655167 655167 Chambur, John, of Newport Pagnell alias Worcester, husbandman 3
5202903 2416612 2416612 defendant Chambre Robert chapman 655167 655167 Chambre, Robert, of Newport Pagnell, chapman 0
5299143 2444729 2444729 defendant Chamber Robert mercer 655167 655167 Chamber, Robert, of Newport Pagnell, mercer 0
5306822 2447035 2447035 defendant Sheyle John yeoman 655167 655167 Sheyle, John, of Newport Pagnell, yeoman 1

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