names

45 rows where place_id = 599523

✎ 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
3637135 1906413 1906413 defendant Whyght William mercer 599523 599523 Whyght, William, of Hyworth, mercer 0
3685643 1921665 1921665 defendant Chany Richard husbandman 599523 599523 Chany, Richard, of Hyworth, husbandman 0
3685644 1921665 1921665 defendant Saffry Henry husbandman 599523 599523 Saffry, Henry, of Hyworth, husbandman 1
3698064 1925621 1925621 defendant Randolff alias Taylour William (legal representative) 599523 599523 Randolff alias Taylour, William, of Hyworth, husbandman, executor of 0
3698065 1925621 1925621 defendant Edmundys William husbandman 599523 599523 Edmundys, William, of Hyworth, husbandman 1
4077706 2052317 2052317 defendant Skynner Thomas mercer 599523 599523 Skynner, Thomas, of Hyworth, mercer 1
4448632 2184503 2184503 defendant Lynte Richard (legal representative) 599523 599523 Lynte, Richard, of Hyworth, executrix of 0
4513325 2204583 2204583 defendant Curteys Walter   599523 599523 Curteys, Walter, of Hyworth 0
4552780 2216818 2216818 defendant Pedwardyn Walter   599523 599523 Pedwardyn, Walter, of Hyworth 0
4552781 2216819 2216819 plaintiff Fouler Thomas   599523 599523 Fouler, Thomas, of Hyworth 0
4581835 2225763 2225763 defendant Lynte John   599523 599523 Lynte, John, of Hyworth 0
4614166 2235440 2235440 defendant Couper John   599523 599523 Couper, John, of Hyworth 2
4640708 2243389 2243389 defendant Ferrour Thomas   599523 599523 Ferrour, Thomas, of Hyworth 1
4640709 2243389 2243389 defendant Ferrour John   599523 599523 Ferrour, John, of Hyworth 2
4640710 2243389 2243389 defendant Pyle William   599523 599523 Pyle, William, of Hyworth 3
4640711 2243389 2243389 defendant Coupere John   599523 599523 Coupere, John, of Hyworth 4
4648668 2245665 2245665 defendant Latton John   599523 599523 Latton, John, of Hyworth 5
4730364 2274696 2274696 defendant Feld John husbandman 599523 599523 Feld, John, of Hyworth, husbandman 0
4746159 2279368 2279368 defendant Morys Richard husbandman 599523 599523 Morys, Richard, of Hyworth, husbandman 0
4761229 2283860 2283860 defendant Morecokke William husbandman 599523 599523 Morecokke, William, of Hyworth, husbandman 1
4770279 2286676 2286676 defendant Dounton William husbandman 599523 599523 Dounton, William, of Hyworth, husbandman 0
4794766 2294503 2294503 defendant Loder Richard plowman 599523 599523 Loder, Richard, of Hyworth, plowman 0
4794768 2294503 2294503 defendant Morys Richard plowman 599523 599523 Morys, Richard, of Hyworth, plowman 2
4794769 2294503 2294503 defendant Damon John plowman 599523 599523 Damon, John, of Hyworth, plowman 3
4820092 2302360 2302360 defendant Damon John ploughman 599523 599523 Damon, John, of Hyworth, ploughman 3
4820093 2302360 2302360 defendant Morys Richard ploughman 599523 599523 Morys, Richard, of Hyworth, ploughman 4
4974202 2349240 2349240 defendant Waryn Christopher clerk 599523 599523 Waryn, Christopher, of Hyworth, clerk 0
4978288 2350453 2350453 defendant Amour John husbandman 599523 599523 Amour, John, of Hyworth, husbandman 0
4978290 2350454 2350454 defendant Amour John husbandman 599523 599523 Amour, John, of Hyworth, husbandman 0
5024481 2364072 2364072 defendant Byde Henry husbandman 599523 599523 Byde, Henry, of Hyworth, husbandman 2
5037802 2367935 2367935 defendant Marchall John, junior husbandman 599523 599523 Marchall, John, junior, of Hyworth, husbandman 0
5045168 2370186 2370186 plaintiff Jones Henry   599523 599523 Jones, Henry, of Hyworth 0
5126078 2394110 2394110 defendant Marchall John   599523 599523 Marchall, John, of Hyworth, bailiff 0
5151486 2401584 2401584 defendant Chawndeler William   599523 599523 Chawndeler, William, of Hyworth, tallow chandler 0
5227990 2423798 2423798 defendant Marsshall John   599523 599523 Marsshall, John, of Hyworth, bailiff 2
5330172 2454100 2454100 defendant Stone Thomas gent 599523 599523 Stone, Thomas, of Hyworth, gent 0
5350310 2460217 2460217 defendant Bray John chapman 599523 599523 Bray, John, of Hyworth, chapman 1
5386107 2471095 2471095 defendant Bray John chapman 599523 599523 Bray, John, of Hyworth, chapman 3
5398370 2474597 2474597 defendant Bray John chapman 599523 599523 Bray, John, of Hyworth, chapman 3
5420106 2480930 2480930 defendant Bray John chapman 599523 599523 Bray, John, of Hyworth, chapman 2
5531089 2514241 2514241 defendant Hynton James yeoman 599523 599523 Hynton, James, of Hyworth, yeoman 0
5564100 2524116 2524116 defendant Taylour William tailor 599523 599523 Taylour, William, of Hyworth, tailor 1
5564101 2524116 2524116 defendant Bocher William tailor 599523 599523 Bocher, William, of Hyworth, tailor 2
5598237 2534337 2534337 defendant White John yeoman 599523 599523 White, John, of Hyworth, yeoman 0
5624639 2551646 2551646 defendant Bocher Thomas cooper 599523 599523 Bocher, Thomas, of Hyworth, cooper 2

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