names

32 rows where place_id = 606695

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3666207 1915379 1915379 defendant Wryght Robert husbandman 606695 606695 Wryght, Robert, of Donyngton in Holand, husbandman 0
4438005 2181202 2181202 defendant Walter Alan   606695 606695 Walter, Alan, of Donyngton in Holand 0
4493836 2198767 2198767 defendant Derman Richard   606695 606695 Derman, Richard, of Donyngton in Holand 0
4678885 2258998 2258998 defendant Erlyche Thomas thatcher 606695 606695 Erlyche, Thomas, of Donyngton in Holand, thatcher 0
4682369 2260107 2260107 defendant Payne John husbandman 606695 606695 Payne, John, of Donyngton in Holand, husbandman 0
4695484 2264068 2264068 defendant Cokeman John   606695 606695 Cokeman, John, of Donyngton in Holand, salt weller 3
4696691 2264442 2264442 defendant Gryffyn John butcher 606695 606695 Gryffyn, John, of Donyngton in Holand, butcher 0
4719598 2271470 2271470 defendant Broun John smith 606695 606695 Broun, John, of Donyngton in Holand, smith 1
4768145 2286009 2286009 plaintiff More John   606695 606695 More, John, of Donyngton in Holand, parson 0
4784313 2291092 2291092 plaintiff Derby William   606695 606695 Derby, William, of Donyngton in Holand 0
4784320 2291093 2291093 defendant Strugge or Scrugge Robert fisher 606695 606695 Strugge or Scrugge, Robert, of Donyngton in Holand, fisher 0
4784321 2291093 2291093 defendant Aubry John husbandman 606695 606695 Aubry, John, of Donyngton in Holand, husbandman 1
4784322 2291093 2291093 defendant Aubry William husbandman 606695 606695 Aubry, William, of Donyngton in Holand, husbandman 2
4784323 2291093 2291093 defendant Derman John, junior husbandman 606695 606695 Derman, John, junior, of Donyngton in Holand, husbandman 3
4824226 2303645 2303645 defendant Danyell John laborer 606695 606695 Danyell, John, of Donyngton in Holand, laborer 0
4850940 2311744 2311744 defendant Broun Lambert weaver 606695 606695 Broun, Lambert, of Donyngton in Holand, weaver 0
4857698 2313788 2313788 defendant Smyth Thomas husbandman 606695 606695 Smyth, Thomas, of Donyngton in Holand, husbandman 0
4873097 2318540 2318540 defendant Burbag John, senior husbandman 606695 606695 Burbag, John, senior, of Donyngton in Holand, husbandman 1
4925189 2334311 2334311 defendant Taillour Roger carter 606695 606695 Taillour, Roger, of Donyngton in Holand, carter 3
4941135 2339250 2339250 defendant Danyell John husbandman 606695 606695 Danyell, John, of Donyngton in Holand, husbandman 2
4977610 2350269 2350269 defendant Quekerell Thomas husbandman 606695 606695 Quekerell, Thomas, of Donyngton in Holand, husbandman 0
5025322 2364298 2364298 defendant Hayward John laborer 606695 606695 Hayward, John, of Donyngton in Holand, laborer 0
5025323 2364298 2364298 defendant Boller John laborer 606695 606695 Boller, John, of Donyngton in Holand, laborer 1
5025324 2364298 2364298 defendant Whitham Robert husbandman 606695 606695 Whitham, Robert, of Donyngton in Holand, husbandman 2
5095603 2385138 2385138 defendant at Ale John husbandman 606695 606695 at Ale, John, of Donyngton in Holand, husbandman 0
5157340 2403284 2403284 defendant Chekyn Thomas husbandman 606695 606695 Chekyn, Thomas, of Donyngton in Holand, husbandman 5
5279690 2439142 2439142 defendant Wellys John husbandman 606695 606695 Wellys, John, of Donyngton in Holand, husbandman 0
5293361 2443039 2443039 defendant Wryght Richard husbandman 606695 606695 Wryght, Richard, of Donyngton in Holand, husbandman 1
5339575 2456950 2456950 defendant Copeman Thomas husbandman 606695 606695 Copeman, Thomas, of Donyngton in Holand, husbandman 3
5449067 2489614 2489614 defendant Graunger Peter alias Perkin yeoman 606695 606695 Graunger, Peter alias Perkin, of Donyngton in Holand, yeoman 0
5458920 2492564 2492564 defendant Pereson John chaplain 606695 606695 Pereson, John, of Donyngton in Holand, chaplain 0
5611437 2547308 2547308 plaintiff Bosevyle Alan   606695 606695 Bosevyle, Alan, of Donyngton in Holand 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);