names

71 rows where place_id = 611918

✎ 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
3663381 1914471 1914471 defendant Bacon Richard mercer 611918 611918 Bacon, Richard, of Holte marker, mercer 0
3690689 1923254 1923254 plaintiff Gresham John gent 611918 611918 Gresham, John, of Holte, gent 0
3725396 1934236 1934236 defendant Stoberd John husbandman 611918 611918 Stoberd, John, of Holte, husbandman 0
3729506 1935474 1935474 defendant Harle Robert husbandman 611918 611918 Harle, Robert, of Holte, husbandman 2
3734933 1937163 1937163 defendant Barbour Thomas husbandman 611918 611918 Barbour, Thomas, of Holte, husbandman 7
3734934 1937163 1937163 defendant Bacon Richard husbandman 611918 611918 Bacon, Richard, of Holte, husbandman 8
3761177 1945499 1945499 defendant Harpour Giles smith 611918 611918 Harpour, Giles, of Holte, smith 0
3765080 1946743 1946743 defendant Budden William husbandman 611918 611918 Budden, William, of Holte, Wymborne Mynster, husbandman 0
3766997 1947344 1947344 defendant Rufford Richard yeoman 611918 611918 Rufford, Richard, of Holte, yeoman 1
3811642 1961539 1961539 defendant Perry Philip miller 611918 611918 Perry, Philip, of Holte, miller 0
3817078 1963256 1963256 defendant Budden William husbandman 611918 611918 Budden, William, of Holte, Wynborne Mynster, husbandman 0
3870222 1980288 1980288 defendant Bramstell William glover 611918 611918 Bramstell, William, of Holte, glover 1
3870225 1980289 1980289 defendant Bramstell William glover 611918 611918 Bramstell, William, of Holte, glover 1
3886247 1985653 1985653 defendant Jagge Robert husbandman 611918 611918 Jagge, Robert, of Holte, husbandman 0
3892616 1987777 1987777 plaintiff Nevell Thomas esq 611918 611918 Nevell, Thomas, of Holte, esq 0
3892625 1987781 1987781 plaintiff Nevyll Thomas esq 611918 611918 Nevyll, Thomas, of Holte, esq 0
3996730 2023592 2023592 defendant Woodcok John yeoman 611918 611918 Woodcok, John, of Holte, yeoman 0
4022092 2032631 2032631 defendant Clangewood Henry (legal representative) 611918 611918 Clangewood, Henry, of Holte, Wymborne Mynster, yeoman, executors of 0
4049387 2042225 2042225 defendant Nowell Thomas (legal representative) 611918 611918 Nowell, Thomas, of Holte, knight, executor of 0
4067734 2048770 2048770 defendant Hanson Lancelot   611918 611918 Hanson, Lancelot, of Holte, burgess 2
4078833 2052727 2052727 defendant Tuddenham Thomas butcher 611918 611918 Tuddenham, Thomas, of Holte, butcher 0
4084512 2054737 2054737 defendant Barnes John husbandman 611918 611918 Barnes, John, of Holte, husbandman 1
4091023 2057078 2057078 defendant Tuddenham or Tudnam Thomas butcher 611918 611918 Tuddenham or Tudnam, Thomas, of Holte, butcher 0
4094894 2058505 2058505 defendant Gogney William husbandman 611918 611918 Gogney, William, of Holte, husbandman 0
4094905 2058509 2058509 defendant Gogney William husbandman 611918 611918 Gogney, William, of Holte, husbandman 0
4097763 2059530 2059530 defendant Royden John esq 611918 611918 Royden, John, of Holte, esq 3
4097767 2059531 2059531 defendant Roydon John esq 611918 611918 Roydon, John, of Holte, esq 2
4099181 2060031 2060031 defendant Evered Thomas tinker 611918 611918 Evered, Thomas, of Holte, tinker 0
4135348 2072963 2072963 defendant Whytney Anthony gent 611918 611918 Whytney, Anthony, of Holte, gent 1
4153659 2079373 2079373 defendant Gogney William pedder 611918 611918 Gogney, William, of Holte, pedder 0
4154810 2079777 2079777 defendant Whytney Anthony gent 611918 611918 Whytney, Anthony, of Holte, gent 0
4159420 2081362 2081362 defendant Whytney Anthony gent 611918 611918 Whytney, Anthony, of Holte, gent 1
4178089 2087806 2087806 defendant Gogney William   611918 611918 Gogney, William, of Holte, "pedder" or peddler 0
4183165 2089594 2089594 defendant Whitney Anthony gent 611918 611918 Whitney, Anthony, of Holte, gent 0
4192833 2093055 2093055 defendant Browne Thomas yeoman 611918 611918 Browne, Thomas, of Holte, yeoman 5
4206806 2097924 2097924 defendant Whytney Anthony gent 611918 611918 Whytney, Anthony, of Holte, gent 0
4242828 2110592 2110592 defendant Patricke Gilbert husbandman 611918 611918 Patricke, Gilbert, of Holte, husbandman 1
4252758 2113908 2113908 defendant Cooke Edmund carpenter 611918 611918 Cooke, Edmund, of Holte, carpenter 2
4288875 2126075 2126075 defendant Brigges Christopher shoemaker 611918 611918 Brigges, Christopher, of Holte, shoemaker 0
4312489 2134503 2134503 defendant Cooke Edmund carpenter 611918 611918 Cooke, Edmund, of Holte, carpenter 3
4323831 2138382 2138382 defendant Cooke Edmund carpenter 611918 611918 Cooke, Edmund, of Holte, carpenter 3
4365883 2152834 2152834 defendant Barnes John husbandman 611918 611918 Barnes, John, of Holte, Wymborne Mynster, husbandman 0
4392663 2162165 2162165 defendant Antlye William yeoman 611918 611918 Antlye, William, of Holte, yeoman 0
4392665 2162165 2162165 defendant Athowe Thomas, junior butcher 611918 611918 Athowe, Thomas, junior, of Holte, butcher 2
4440556 2181959 2181959 plaintiff Bergh William de   611918 611918 Bergh, William de, of Holte, parson 0
4487415 2196774 2196774 plaintiff Smalbon Thomas   611918 611918 Smalbon, Thomas, of Holte 0
4591029 2228548 2228548 defendant Webbe John   611918 611918 Webbe, John, of Holte 0
4600520 2231384 2231384 defendant Beauchamp John   611918 611918 Beauchamp, John, of Holte, knight 0
4600522 2231385 2231385 defendant Beauchamp John   611918 611918 Beauchamp, John, of Holte, knight 0
4622970 2238163 2238163 defendant Malger Walter   611918 611918 Malger, Walter, of Holte 0
4653758 2247095 2247095 defendant Seymour William husbandman 611918 611918 Seymour, William, of Holte, husbandman 0
4653759 2247095 2247095 defendant Seymour John laborer 611918 611918 Seymour, John, of Holte, laborer 1
4653762 2247095 2247095 defendant Trycer John husbandman 611918 611918 Trycer, John, of Holte, husbandman 4
4653777 2247096 2247096 defendant Seymour William husbandman 611918 611918 together with Seymour, William, of Holte, husbandman 13
4653778 2247096 2247096 defendant Seymour John laborer 611918 611918 Seymour, John, of Holte, laborer 14
4653781 2247096 2247096 defendant Trytor John jusbandman 611918 611918 Trytor, John, of Holte, jusbandman 17
4762047 2284113 2284113 defendant Pylehous William of the husbandman 611918 611918 Pylehous, William of the, of Holte, husbandman 2
4762706 2284315 2284315 defendant Meter Thomas husbandman 611918 611918 Meter, Thomas, of Holte, husbandman 0
4942630 2339667 2339667 plaintiff Freman Robert   611918 611918 Freman, Robert, of Holte 0
5057145 2373718 2373718 defendant Perot John yeoman 611918 611918 Perot, John, of Holte, yeoman 1
5126413 2394200 2394200 defendant Rasy Philip husbandman 611918 611918 Rasy, Philip, of Holte, husbandman 0
5202183 2416401 2416401 defendant Rasy Philip husbandman 611918 611918 Rasy, Philip, of Holte, husbandman 0
5319968 2451058 2451058 defendant Gobbette John butcher 611918 611918 Gobbette, John, of Holte, butcher 2
5452318 2490566 2490566 defendant Baret Richard husbandman 611918 611918 Baret, Richard, of Holte, husbandman 0
5528473 2513436 2513436 plaintiff Nevyll Thomas esq 611918 611918 Nevyll, Thomas, of Holte, esq 18
5528496 2513437 2513437 plaintiff Nevyll Thomas esq 611918 611918 Nevyll, Thomas, of Holte, esq 18
5528519 2513438 2513438 plaintiff Nevyll Thomas esq 611918 611918 Nevyll, Thomas, of Holte, esq 18
5528542 2513439 2513439 plaintiff Nevyll Thomas esq 611918 611918 Nevyll, Thomas, of Holte, esq 18
5559842 2522838 2522838 defendant Stephyns John yeoman 611918 611918 Stephyns, John, of Holte, yeoman 0
5577858 2528146 2528146 defendant Downe William carpenter 611918 611918 Downe, William, of Holte, carpenter 2
5630022 2553391 2553391 defendant Maleier or Malerer Walter laborer 611918 611918 Maleier or Malerer, Walter, of Holte, laborer 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);