names

36 rows where place_id = 590127

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3599994 1867651 1867651 defendant Combe Thomas husbandman 590127 590127 Combe, Thomas, of Edelmeton, Middx, husbandman 3
3621523 1874275 1874275 plaintiff Noode Edmund (legal representative) 590127 590127 Noode, Edmund, of Edelmeton, Middx, yeoman, executors of 0
3630341 1904330 1904330 defendant Bonde Nicholas gent 590127 590127 Bonde, Nicholas, of Edelmeton, Middx, gent 2
3630358 1904331 1904331 defendant Bond Nicholas gent 590127 590127 Bond, Nicholas, of Edelmeton, Middx, gent 8
3634996 1905743 1905743 defendant Fox Richard yeoman 590127 590127 Fox, Richard, of Edelmeton, Middx, yeoman 0
3696013 1924992 1924992 defendant Bone Rose widow 590127 590127 Bone, Rose, of Edelmeton, Middx, widow 3
3747390 1941098 1941098 defendant Wilson Thomas glover 590127 590127 Wilson, Thomas, of Edelmeton, Middx, glover 4
3765411 1946843 1946843 defendant Burnham John mealman 590127 590127 Burnham, John, of Edelmeton, Middx, mealman 0
4209344 2098822 2098822 defendant Burton Thomas bricklayer 590127 590127 Burton, Thomas, of Edelmeton, Middx, bricklayer 1
4264733 2117847 2117847 defendant Partridge Robert esq 590127 590127 Partridge, Robert, of Edelmeton , Middx, esq 0
4646444 2245024 2245024 defendant Larke Henry   590127 590127 Larke, Henry, of Edelmeton, Middx 0
4646450 2245025 2245025 defendant Larke Henry   590127 590127 Larke, Henry, of Edelmeton, Middx 0
4718730 2271197 2271197 defendant Mogun John, sen husbandman 590127 590127 Mogun, John, sen, of Edelmeton, Middx, husbandman 1
4924104 2333978 2333978 defendant Charleton Thomas   590127 590127 Charleton, Thomas, of Edelmeton, Middx, knight 0
4949960 2341955 2341955 defendant Charleton Thomas   590127 590127 Charleton, Thomas, of Edelmeton, Middx, knight 0
4974784 2349428 2349428 defendant Charleton Thomas   590127 590127 Charleton, Thomas, of Edelmeton, Middx, knight 0
5125236 2393858 2393858 defendant Langeford Richard maltman 590127 590127 Langeford, Richard, of Edelmeton, Middx, maltman 0
5135397 2396860 2396860 defendant Severne Robert   590127 590127 Severne, Robert, of Edelmeton, Middx, malt man 0
5161676 2404518 2404518 defendant Fox John yeoman 590127 590127 Fox, John, of Edelmeton, Middx, yeoman 0
5191378 2413219 2413219 defendant Saberne Robert   590127 590127 Saberne, Robert, of Edelmeton, Middx 0
5234356 2425637 2425637 defendant Langeford Richrd maltman 590127 590127 Langeford, Richrd, of Edelmeton, Middx, maltman 0
5332689 2454846 2454846 defendant Fox or Foy John yeoman 590127 590127 Fox or Foy, John, of Edelmeton, Middx, yeoman 0
5332692 2454847 2454847 defendant Fox John yeoman 590127 590127 Fox, John, of Edelmeton, Middx, yeoman 0
5341103 2457408 2457408 defendant Furneys William husbandman 590127 590127 Furneys, William, of Edelmeton, Middx, husbandman 4
5383046 2470221 2470221 defendant Hastyng Nicholas shoemaker 590127 590127 Hastyng, Nicholas, of Edelmeton, Middx, shoemaker 2
5413821 2479058 2479058 defendant Wynship Thomas laborer 590127 590127 Wynship, Thomas, of Edelmeton, Middx, laborer 3
5429203 2483662 2483662 defendant Wynship Thomas laborer 590127 590127 Wynship, Thomas, of Edelmeton, Middx, laborer 2
5436945 2485981 2485981 defendant Vernoun William gent 590127 590127 Vernoun, William, of Edelmeton, Middx, gent 0
5451515 2490329 2490329 defendant Vernoun William gent 590127 590127 Vernoun, William, of Edelmeton, Middx, gent 0
5463520 2494004 2494004 defendant Vernoun William gent 590127 590127 Vernoun, William, of Edelmeton, Middx, gent 0
5463522 2494005 2494005 defendant Vernoun William gent 590127 590127 Vernoun, William, of Edelmeton, Middx, gent 0
5486574 2500881 2500881 defendant Vernoun William gent 590127 590127 Vernoun, William, of Edelmeton, Middx, gent 0
5525266 2512494 2512494 defendant Masse William maltman 590127 590127 Masse, William, of Edelmeton, Middx, maltman 4
5551520 2520482 2520482 defendant Fox Richard maltman 590127 590127 Fox, Richard, of Edelmeton, Middx, maltman 0
5578497 2528345 2528345 defendant Leeke John (legal representative) 590127 590127 Leeke, John, of Edelmeton, Middx, gent, executors of 0
5586413 2530790 2530790 plaintiff Leeke John (legal representative) 590127 590127 Leeke, John, of Edelmeton, Middx, executors of 0

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