names

44 rows where place_id = 588829

✎ 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
3595728 1866294 1866294 defendant Kyng Thomas yeoman 588829 588829 Kyng, Thomas, of Ukfeld, yeoman 0
3599886 1867616 1867616 defendant Swayneslond Richard husbandman 588829 588829 Swayneslond, Richard, of Ukfeld, husbandman 0
3599890 1867617 1867617 defendant Swayneslond Richard husbandman 588829 588829 Swayneslond, Richard, of Ukfeld, husbandman 0
3647723 1909676 1909676 defendant Maunser Robert, junior yeoman 588829 588829 Maunser, Robert, junior, of Ukfeld, yeoman 0
3651775 1910911 1910911 defendant Maunser Robert, junior yeoman 588829 588829 Maunser, Robert, junior, of Ukfeld, yeoman 0
4577969 2224614 2224614 defendant Taillour Richard   588829 588829 Taillour, Richard, of Ukfeld 0
4613358 2235208 2235208 defendant Chaury Thomas   588829 588829 Chaury, Thomas, of Ukfeld 3
4613359 2235208 2235208 defendant atte Stone John   588829 588829 atte Stone, John, of Ukfeld 4
4613363 2235208 2235208 defendant Couper Richard   588829 588829 Couper, Richard, of Ukfeld 8
4613365 2235208 2235208 defendant Lucas Thomas   588829 588829 Lucas, Thomas, of Ukfeld 10
4613383 2235210 2235210 defendant Chaury Thomas   588829 588829 Chaury, Thomas, of Ukfeld 2
4613384 2235210 2235210 defendant atte Stone John   588829 588829 atte Stone, John, of Ukfeld 3
4613388 2235210 2235210 defendant Couper Richard   588829 588829 Couper, Richard, of Ukfeld 7
4613390 2235210 2235210 defendant Lucas Thomas   588829 588829 Lucas, Thomas, of Ukfeld 9
4613400 2235210 2235210 defendant Rounger John   588829 588829 Rounger, John, of Ukfeld 19
4625536 2238949 2238949 defendant Chaury Thomas   588829 588829 Chaury, Thomas, of Ukfeld 2
4625538 2238949 2238949 defendant Couper Richard   588829 588829 Couper, Richard, of Ukfeld 4
4625540 2238949 2238949 defendant Lucas Thomas   588829 588829 Lucas, Thomas, of Ukfeld 6
4625551 2238949 2238949 defendant Raunger John   588829 588829 Raunger, John, of Ukfeld 17
4651843 2246514 2246514 defendant Crofton William yeoman 588829 588829 Crofton, William, of Ukfeld, yeoman 3
4667928 2255671 2255671 plaintiff Baker John   588829 588829 Baker, John, of Ukfeld 0
4696339 2264334 2264334 defendant Norton William husbandman 588829 588829 Norton, William, of Ukfeld, husbandman 9
4781354 2290178 2290178 plaintiff Chauntour John, senior   588829 588829 Chauntour, John, senior, of Ukfeld 0
4792386 2293705 2293705 defendant Stokell Thomas wheeler 588829 588829 Stokell, Thomas, of Ukfeld, wheeler 0
4875665 2319344 2319344 defendant Shydyard Julia widow 588829 588829 Shydyard, Julia, of Ukfeld, widow 0
4875666 2319344 2319344 defendant Metkyn William butcher 588829 588829 Metkyn, William, of Ukfeld, butcher 1
4908708 2329272 2329272 defendant Doraunt William butcher 588829 588829 Doraunt, William, of Ukfeld, butcher 0
4978888 2350642 2350642 defendant Durant William butcher 588829 588829 Durant, William, of Ukfeld, butcher 2
5000049 2356897 2356897 defendant Reynold John husbandman 588829 588829 Reynold, John, of Ukfeld, husbandman 0
5409931 2477942 2477942 plaintiff Gilbert William   588829 588829 Gilbert, William, of Ukfeld 1
5423610 2482026 2482026 plaintiff Gilbert William   588829 588829 Gilbert, William, of Ukfeld 1
5423613 2482027 2482027 plaintiff Gilbert William   588829 588829 Gilbert, William, of Ukfeld 1
5423616 2482028 2482028 plaintiff Gilbert William   588829 588829 Gilbert, William, of Ukfeld 1
5455615 2491585 2491585 plaintiff Gilbert William   588829 588829 Gilbert, William, of Ukfeld 1
5467383 2495189 2495189 plaintiff Gilbert William   588829 588829 Gilbert, William, of Ukfeld 1
5467386 2495190 2495190 plaintiff Gilbert William   588829 588829 Gilbert, William, of Ukfeld 1
5489260 2501671 2501671 defendant Wygsell John yeoman 588829 588829 Wygsell, John, of Ukfeld, yeoman 1
5492206 2502580 2502580 defendant Smyth Andrew   588829 588829 Smyth, Andrew, of Ukfeld 0
5495865 2503659 2503659 defendant Wygsell William husbandman 588829 588829 Wygsell, William, of Ukfeld, husbandman 2
5495866 2503659 2503659 defendant Stone Robert laborer 588829 588829 Stone, Robert, of Ukfeld, laborer 3
5495867 2503659 2503659 defendant Bastard Thomas laborer 588829 588829 Bastard, Thomas, of Ukfeld, laborer 4
5504591 2506356 2506356 plaintiff Gilbert William   588829 588829 Gilbert, William, of Ukfeld 1
5504594 2506357 2506357 plaintiff Gilbert William   588829 588829 Gilbert, William, of Ukfeld 1
5504597 2506358 2506358 plaintiff Gilbert William   588829 588829 Gilbert, William, of Ukfeld 1

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