names

36 rows where place_id = 589229

✎ 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
3596959 1866678 1866678 defendant Styward John yeoman 589229 589229 Styward, John, of Wythern, yeoman 0
3635429 1905878 1905878 defendant Messenger Henry yeoman 589229 589229 Messenger, Henry, of Wythern, yeoman 0
3669879 1916523 1916523 defendant Woodford Edward gent 589229 589229 Woodford, Edward, of Wythern, gent 0
3681145 1920185 1920185 defendant Woodford Edward yeoman 589229 589229 Woodford, Edward, of Wythern, yeoman 0
3681147 1920186 1920186 defendant Woodford Edward yeoman 589229 589229 Woodford, Edward, of Wythern, yeoman 0
3691540 1923510 1923510 defendant Foster John barker 589229 589229 Foster, John, of Wythern, barker 0
3691541 1923510 1923510 defendant Robertson William husbandman 589229 589229 Robertson, William, of Wythern, husbandman 1
3691543 1923511 1923511 defendant Mydesent Nicholas thatcher 589229 589229 Mydesent, Nicholas, of Wythern, thatcher 0
3704209 1927616 1927616 defendant Mower Anthony husbandman 589229 589229 Mower, Anthony, of Wythern, husbandman 0
3789709 1954611 1954611 defendant Soper Robert   589229 589229 Soper, Robert, of Wythern, freemason 1
3789714 1954612 1954612 defendant Soper Robert   589229 589229 Soper, Robert, of Wythern, freemason 1
4112847 2064861 2064861 defendant Smythe Thomas miller 589229 589229 Smythe, Thomas, of Wythern, miller 0
4174764 2086642 2086642 defendant Hewet Anthony yeoman 589229 589229 Hewet, Anthony, of Wythern, yeoman 0
4186625 2090807 2090807 defendant Ingleby William husbandman 589229 589229 Ingleby, William, of Wythern, or of Alvingham, husbandman 0
4461819 2188760 2188760 plaintiff Stoward Andrew   589229 589229 Stoward, Andrew, of Wythern 0
4522623 2207414 2207414 defendant Milisant John   589229 589229 Milisant, John, of Wythern 0
4644389 2244451 2244451 defendant Walker Simon   589229 589229 Walker, Simon, of Wythern 0
4803304 2297226 2297226 defendant Doughty William yeoman 589229 589229 Doughty, William, of Wythern, yeoman 0
5030555 2365809 2365809 defendant Ingoldmell John chaplain 589229 589229 Ingoldmell, John, of Wythern, chaplain 0
5125041 2393796 2393796 defendant Ormesby William tailor 589229 589229 Ormesby, William, of Wythern, tailor 0
5125042 2393796 2393796 defendant Caleby Robert husbandman 589229 589229 Caleby, Robert, of Wythern, husbandman 1
5143672 2399283 2399283 defendant Ormesby William tailor 589229 589229 Ormesby, William, of Wythern, tailor 0
5143673 2399283 2399283 defendant Calceby Robert, sen husbandman 589229 589229 Calceby, Robert, sen, of Wythern, husbandman 1
5163139 2404949 2404949 defendant Donham Thomas clerk 589229 589229 Donham, Thomas, of Wythern, clerk 0
5163141 2404950 2404950 defendant Jakson John husbandman 589229 589229 Jakson, John, of Wythern, husbandman 0
5164816 2405441 2405441 defendant Ormesby William tailor 589229 589229 Ormesby, William, of Wythern, tailor 0
5164817 2405441 2405441 defendant Calceby Robert, sen husbandman 589229 589229 Calceby, Robert, sen, of Wythern, husbandman 1
5178287 2409352 2409352 defendant Ormesby William tailor 589229 589229 Ormesby, William, of Wythern, tailor 0
5178288 2409352 2409352 defendant Caleby Robert, sen husbandman 589229 589229 Caleby, Robert, sen, of Wythern, husbandman 1
5219467 2421419 2421419 plaintiff Ormesby William   589229 589229 Ormesby, William, of Wythern 2
5243654 2428337 2428337 defendant Ingram Richard husbandman 589229 589229 Ingram, Richard, of Wythern, husbandman 0
5244942 2428694 2428694 defendant Aylby William chaplain 589229 589229 Aylby, William, of Wythern, chaplain 0
5321445 2451506 2451506 defendant Traves Richard clerk 589229 589229 (Traves, Richard, of Wythern, clerk 6
5372296 2466930 2466930 defendant Ormesby John gent 589229 589229 Ormesby, John, of Wythern, gent 0
5437076 2486027 2486027 defendant Symson Thomas yeoman 589229 589229 Symson, Thomas, of Wythern, yeoman 1
5548420 2519572 2519572 defendant Ormesby John gent 589229 589229 Ormesby, John, of Wythern, gent 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);