names

46 rows where place_id = 592845

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3609145 1870519 1870519 plaintiff Williams Thomas gent 592845 592845 Williams, Thomas, of Edmonton, gent 0
3628059 1903630 1903630 defendant Boterell Thomas gent 592845 592845 Boterell, Thomas, of Edmonton, gent 0
3734906 1937156 1937156 defendant Bone Nicholas (legal representative) 592845 592845 Bone, Nicholas, of Edmonton, gent, executrix of 0
3816998 1963224 1963224 defendant Walles Robert gent 592845 592845 (Walles, Robert, of Edmonton, gent 1
3819704 1964043 1964043 defendant Walles Robert gent 592845 592845 (Walles, Robert, of Edmonton, gent 1
3819831 1964084 1964084 defendant Considue Richard yeoman 592845 592845 Considue, Richard, of Edmonton, yeoman 1
3823721 1965315 1965315 defendant Walles Robert gent 592845 592845 (Walles, Robert, of Edmonton, gent 1
3969194 2013835 2013835 plaintiff Condycote or Coudycote Henry   592845 592845 Condycote or Coudycote, Henry, of Edmonton 0
4039384 2038711 2038711 defendant Shawe William yeoman 592845 592845 Shawe, William, of Edmonton, yeoman 0
4039386 2038712 2038712 defendant Shawe William yeoman 592845 592845 Shawe, William, of Edmonton, yeoman 0
4072381 2050426 2050426 defendant Speller Edward yeoman 592845 592845 Speller, Edward, of Edmonton, yeoman 0
4072382 2050426 2050426 defendant Shaw Robert yeoman 592845 592845 Shaw, Robert, of Edmonton, yeoman 1
4072383 2050426 2050426 defendant Strynger John yeoman 592845 592845 Strynger, John, of Edmonton, yeoman 2
4114272 2065387 2065387 defendant Harr John husbandman 592845 592845 Harr, John, of Edmonton, husbandman 2
4246242 2111721 2111721 defendant Leake Jasper gent 592845 592845 Leake, Jasper, of Edmonton, gent 1
4270682 2119774 2119774 defendant Leake Jasper gent 592845 592845 Leake, Jasper, of Edmonton, gent 1
4279033 2122596 2122596 defendant Cade Henry yeoman 592845 592845 Cade, Henry, of Edmonton, yeoman 0
4375486 2156288 2156288 defendant Manchyll or Machyll Thomas, junior gent 592845 592845 Manchyll or Machyll, Thomas, junior, of Edmonton, or of Hackney, Middx, gent 0
4409479 2167767 2167767 defendant Cussh alias Anthonye Richard yeoman 592845 592845 Cussh alias Anthonye, Richard, of Edmonton, yeoman 0
4409480 2167767 2167767 defendant Roose John yeoman 592845 592845 Roose, John, of Edmonton, yeoman 1
5137122 2397371 2397371 defendant Balle John, senior husbandman 592845 592845 Balle, John, senior, of Edmonton, husbandman 3
5137123 2397371 2397371 defendant Broun William husbandman 592845 592845 Broun, William, of Edmonton, husbandman 4
5137124 2397371 2397371 defendant Hill Margaret widow 592845 592845 Hill, Margaret, of Edmonton, widow 5
5137125 2397371 2397371 defendant Cordell Richard, senior maltman 592845 592845 Cordell, Richard, senior, of Edmonton, maltman 6
5137126 2397371 2397371 defendant Goldyng Emmot widow 592845 592845 Goldyng, Emmot, of Edmonton, widow 7
5137127 2397371 2397371 defendant Warner Thomas husbandman 592845 592845 Warner, Thomas, of Edmonton, husbandman 8
5137128 2397371 2397371 defendant Barbour William husbandman 592845 592845 Barbour, William, of Edmonton, husbandman 9
5149160 2400885 2400885 plaintiff Deynes Margaret widow 592845 592845 Deynes, Margaret, of Edmonton, widow 0
5149162 2400885 2400885 defendant Langford Richard maltman 592845 592845 Langford, Richard, of Edmonton, maltman 0
5149961 2401122 2401122 defendant Lawrens Alexander yeoman 592845 592845 Lawrens, Alexander, of Edmonton, yeoman 0
5149962 2401122 2401122 defendant Hall William yeoman 592845 592845 Hall, William, of Edmonton, yeoman 1
5149963 2401122 2401122 defendant Furneys William husbandman 592845 592845 Furneys, William, of Edmonton, husbandman 2
5149964 2401122 2401122 defendant Edwyn Nicholas husbandman 592845 592845 Edwyn, Nicholas, of Edmonton, husbandman 3
5149965 2401122 2401122 defendant Rowe John yeoman 592845 592845 Rowe, John, of Edmonton, yeoman 4
5195476 2414424 2414424 defendant Couper William husbandman 592845 592845 Couper, William, of Edmonton, husbandman 2
5251256 2430495 2430495 defendant Edwyn Nicholas husbandman 592845 592845 Edwyn, Nicholas, of Edmonton, husbandman 0
5275806 2437992 2437992 defendant Laurence Alexander husbandman 592845 592845 Laurence, Alexander, of Edmonton, husbandman 0
5275808 2437993 2437993 defendant Laurence Alexander husbandman 592845 592845 Laurence, Alexander, of Edmonton, husbandman 0
5310811 2448270 2448270 defendant Dardys John brewer 592845 592845 Dardys, John, of Edmonton, brewer 1
5310813 2448270 2448270 defendant Pierson Robert laborer 592845 592845 Pierson, Robert, of Edmonton, laborer 3
5440208 2486971 2486971 defendant Benke Henry   592845 592845 Benke, Henry, of Edmonton, baker, Alice, his wife 0
5485975 2500694 2500694 defendant Manser Roger yeoman 592845 592845 Manser, Roger, of Edmonton, yeoman 1
5486093 2500724 2500724 defendant Bener or Bever John husbandman 592845 592845 Bener or Bever, John, of Edmonton, husbandman 0
5486094 2500724 2500724 defendant Leven John husbandman 592845 592845 Leven, John, of Edmonton, husbandman 1
5486096 2500725 2500725 defendant Topsell Peter husbandman 592845 592845 Topsell, Peter, of Edmonton, husbandman 0
5486097 2500725 2500725 defendant Harre John husbandman 592845 592845 Harre, John, of Edmonton, husbandman 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);