names

38 rows where place_id = 589776

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3598703 1867219 1867219 defendant Wheler John husbandman 589776 589776 Wheler, John, of Clanfeld, husbandman 2
3675181 1918270 1918270 defendant Richardis John yeoman 589776 589776 Richardis, John, of Clanfeld, yeoman 0
3675182 1918270 1918270 defendant Turfrey John yeoman 589776 589776 Turfrey, John, of Clanfeld, yeoman 1
4009309 2028093 2028093 defendant Gryme William yeoman 589776 589776 Gryme, William, of Clanfeld, yeoman 2
4033915 2036782 2036782 plaintiff Gyllam alias Arnolde Alexander yeoman 589776 589776 Gyllam alias Arnolde, Alexander, of Clanfeld, yeoman 0
4050607 2042646 2042646 defendant Hooper Robert   589776 589776 Hooper, Robert, of Clanfeld, yeoman, his son 1
4566858 2221197 2221197 defendant Botte John   589776 589776 Botte, John, of Clanfeld 0
4676575 2258290 2258290 defendant Frewyn John husbandman 589776 589776 Frewyn, John, of Clanfeld, husbandman 2
4893873 2324784 2324784 defendant Warde Hugh   589776 589776 Warde, Hugh, of Clanfeld 0
4894934 2325078 2325078 defendant Genever John husbandman 589776 589776 Genever, John, of Clanfeld, husbandman 0
4931733 2336310 2336310 defendant Broun John husbandman 589776 589776 Broun, John, of Clanfeld, husbandman 0
4945479 2340564 2340564 defendant Janever John husbandman 589776 589776 Janever, John, of Clanfeld, husbandman 0
4957016 2344057 2344057 defendant Abram John husbandman 589776 589776 Abram, John, of Clanfeld, husbandman 0
4957017 2344057 2344057 defendant Abram Thomas yeoman 589776 589776 Abram, Thomas, of Clanfeld, yeoman 1
5012317 2360455 2360455 defendant Aylyf William husbandman 589776 589776 Aylyf, William, of Clanfeld, husbandman 0
5030768 2365865 2365865 defendant Chalkeley Thomas gent 589776 589776 Chalkeley, Thomas, of Clanfeld, gent 0
5041066 2368954 2368954 defendant Yateman Richard yeoman 589776 589776 Yateman, Richard, of Clanfeld, yeoman 0
5041067 2368954 2368954 defendant Broune John husbandman 589776 589776 Broune, John, of Clanfeld, husbandman 1
5067539 2376789 2376789 defendant Jenyfer John husbandman 589776 589776 Jenyfer, John, of Clanfeld, husbandman 1
5069767 2377449 2377449 defendant Janyvere John husbandman 589776 589776 Janyvere, John, of Clanfeld, husbandman 4
5098678 2386043 2386043 defendant Jenyfere John   589776 589776 Jenyfere, John, of Clanfeld, franklin 0
5118816 2391934 2391934 defendant Wyther William husbandman 589776 589776 Wyther, William, of Clanfeld, husbandman 1
5230297 2424480 2424480 defendant Harres John husbandman 589776 589776 Harres, John, of Clanfeld, husbandman 0
5260668 2433462 2433462 defendant Umfrey Henry husbandman 589776 589776 Umfrey, Henry, of Clanfeld, husbandman 0
5260669 2433462 2433462 defendant Umfrey William laborer 589776 589776 Umfrey, William, of Clanfeld, laborer 1
5283755 2440291 2440291 defendant Reve John husbandman 589776 589776 Reve, John, of Clanfeld, husbandman 0
5294732 2443440 2443440 defendant Harrys Richard husbandman 589776 589776 Harrys, Richard, of Clanfeld, husbandman 0
5315724 2449768 2449768 defendant Reve John husbandman 589776 589776 Reve, John, of Clanfeld, husbandman 0
5315725 2449768 2449768 defendant Reve William laborer 589776 589776 Reve, William, of Clanfeld, laborer 1
5315726 2449768 2449768 defendant Reve Thomas laborer 589776 589776 Reve, Thomas, of Clanfeld, laborer 2
5368417 2465735 2465735 defendant Humpfrey William husbandman 589776 589776 Humpfrey, William, of Clanfeld, husbandman 0
5378473 2468852 2468852 defendant Whytehorne Thomas husbandman 589776 589776 Whytehorne, Thomas, of Clanfeld, husbandman 0
5413869 2479074 2479074 defendant Umfry Henry husbandman 589776 589776 Umfry, Henry, of Clanfeld, husbandman 0
5429294 2483693 2483693 defendant Umfrey Henry husbandman 589776 589776 Umfrey, Henry, of Clanfeld, husbandman 0
5429296 2483694 2483694 defendant Umfrey Henry husbandman 589776 589776 Umfrey, Henry, of Clanfeld, husbandman 0
5429298 2483695 2483695 defendant Umfrey Henry husbandman 589776 589776 Umfrey, Henry, of Clanfeld, husbandman 0
5544759 2518472 2518472 defendant Stanlake John husbandman 589776 589776 Stanlake, John, of Clanfeld, husbandman 0
5607445 2537224 2537224 defendant Locke John, junior husbandman 589776 589776 Locke, John, junior, of Clanfeld, husbandman 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);