names

28 rows where place_id = 586927

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590007 1864514 1864514 defendant Chamber William yeoman 586927 586927 Chamber, William, of Rokeby, Warks, yeoman 2
3607691 1870060 1870060 defendant Chambyr William (legal representative) 586927 586927 Chambyr, William, of Rokeby, Warks, yeoman, administratrix of 0
3697544 1925454 1925454 defendant brokehurst John yeoman 586927 586927 brokehurst, John, of Rokeby, Warks, yeoman 0
3718999 1932219 1932219 defendant Shyryff Edmund mercer 586927 586927 Shyryff, Edmund, of Rokeby, Warks, mercer 3
3742845 1939615 1939615 defendant Shyreff William mercer 586927 586927 Shyreff, William, of Rokeby, Warks, mercer 0
3779850 1951430 1951430 defendant Pye Eusebius yeoman 586927 586927 Pye, Eusebius, of Rokeby, Warks, yeoman 0
3784103 1952809 1952809 defendant Devyll John yeoman 586927 586927 Devyll, John, of Rokeby, Warks, yeoman 2
3796821 1956886 1956886 defendant Pye Eusebius yeoman 586927 586927 Pye, Eusebius, of Rokeby, Warks, yeoman 0
3814086 1962306 1962306 defendant Pye Margery widow 586927 586927 Pye, Margery, of Rokeby, Warks, widow 1
3894716 1988438 1988438 defendant Byssell Clement mercer 586927 586927 Byssell, Clement, of Rokeby, Warks, mercer 1
5017823 2362093 2362093 defendant Hewet John yeoman 586927 586927 Hewet, John, of Rokeby, Warks, yeoman 1
5077977 2379896 2379896 defendant Edmunde Thomas husbandman 586927 586927 Edmunde, Thomas, of Rokeby, Warks, husbandman 0
5077984 2379897 2379897 defendant Edmunde Thomas husbandman 586927 586927 Edmunde, Thomas, of Rokeby, Warks, husbandman 0
5092750 2384260 2384260 defendant Mabbe William weaver 586927 586927 Mabbe, William, of Rokeby, Warks, weaver 3
5220446 2421676 2421676 defendant Hurst John chapman 586927 586927 Hurst, John, of Rokeby, Warks, chapman 0
5221479 2421979 2421979 defendant Stone John clerk 586927 586927 Stone, John, of Rokeby, Warks, clerk 0
5222744 2422368 2422368 defendant Stone John clerk 586927 586927 Stone, John, of Rokeby, Warks, clerk 0
5226400 2423387 2423387 defendant Miller William miller 586927 586927 Miller, William, of Rokeby, Warks, miller 2
5247581 2429450 2429450 defendant Huet John husbandman 586927 586927 Huet, John, of Rokeby, Warks, husbandman 1
5262750 2434090 2434090 defendant Warrok Thomas butcher 586927 586927 Warrok, Thomas, of Rokeby, Warks, butcher 2
5262755 2434091 2434091 defendant Warrok Thomas butcher 586927 586927 Warrok, Thomas, of Rokeby, Warks, butcher 2
5352719 2460939 2460939 defendant Maunsfelde Robert clerk 586927 586927 Maunsfelde, Robert, of Rokeby, Warks, clerk 1
5352722 2460940 2460940 defendant Maunsfelde Thomas clerk 586927 586927 Maunsfelde, Thomas, of Rokeby, Warks, clerk 1
5359014 2462870 2462870 defendant Chambre William yeoman 586927 586927 Chambre, William, of Rokeby, Warks, yeoman 0
5528869 2513551 2513551 defendant Corbronde John yeoman 586927 586927 Corbronde, John, of Rokeby, Warks, yeoman 0
5554521 2521357 2521357 defendant Howes William husbandman 586927 586927 Howes, William, of Rokeby, Warks, husbandman 0
5632823 2554277 2554277 defendant Coten- alias Chapman John husbandman 586927 586927 Coten- alias Chapman, John, of Rokeby, Warks, husbandman 4
5632884 2554291 2554291 defendant Cotener alias Chapman John husbandman 586927 586927 Cotener alias Chapman, John, of Rokeby, Warks, husbandman 4

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