names

52 rows where place_id = 592017

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3606312 1869643 1869643 defendant Rugdewe William husbandman 592017 592017 Rugdewe, William, of Assyngton, husbandman 0
3643109 1908286 1908286 defendant Frente Thomas yeoman 592017 592017 Frente, Thomas, of Assyngton, yeoman 0
3647618 1909639 1909639 defendant Hervy Robert laborer 592017 592017 Hervy, Robert, of Assyngton, laborer 1
3681839 1920424 1920424 defendant Potter John husbandman 592017 592017 Potter, John, of Assyngton, husbandman 0
3687747 1922334 1922334 defendant Randolff John husbandman 592017 592017 Randolff, John, of Assyngton, husbandman 4
3702951 1927194 1927194 plaintiff Corbett Richard esq 592017 592017 Corbett, Richard, of Assyngton, esq 0
3702952 1927194 1927194 defendant Marteyn alias Bryce George husbandman 592017 592017 Marteyn alias Bryce, George, of Assyngton, husbandman 0
3702953 1927194 1927194 defendant Inkerley Andrew butcher 592017 592017 Inkerley, Andrew, of Assyngton, butcher 1
3702955 1927195 1927195 plaintiff Corbett Richard esq 592017 592017 Corbett, Richard, of Assyngton, esq 0
3702956 1927195 1927195 defendant Marteyn alias Bryce George husbandman 592017 592017 Marteyn alias Bryce, George, of Assyngton, husbandman 0
3702957 1927195 1927195 defendant Inkerley Andrew butcher 592017 592017 Inkerley, Andrew, of Assyngton, butcher 1
3706660 1928368 1928368 defendant Grene John gent 592017 592017 Grene, John, of Assyngton, gent 0
3706661 1928368 1928368 defendant Ketyll Richard husbandman 592017 592017 Ketyll, Richard, of Assyngton, husbandman 1
3706666 1928369 1928369 defendant Grene John gent 592017 592017 Grene, John, of Assyngton, gent 0
3706667 1928369 1928369 defendant Spencer John husbandman 592017 592017 Spencer, John, of Assyngton, husbandman 1
3706670 1928370 1928370 defendant Potter John husbandman 592017 592017 Potter, John, of Assyngton, husbandman 0
3706671 1928370 1928370 defendant Chaundeler John laborer 592017 592017 Chaundeler, John, of Assyngton, laborer 1
3712386 1930191 1930191 defendant Ketyll Richard husbandman 592017 592017 Ketyll, Richard, of Assyngton, husbandman 1
3712389 1930192 1930192 defendant Ketyll Richard husbandman 592017 592017 Ketyll, Richard, of Assyngton, husbandman 1
3727510 1934882 1934882 defendant Potter John yeoman 592017 592017 Potter, John, of Assyngton, yeoman 0
3732311 1936345 1936345 defendant Bedwall John laborer 592017 592017 Bedwall, John, of Assyngton, laborer 0
3732570 1936416 1936416 defendant Potter John husbandman 592017 592017 Potter, John, of Assyngton, husbandman 1
3732571 1936416 1936416 defendant Wygnalle William husbandman 592017 592017 Wygnalle, William, of Assyngton, husbandman 2
3734690 1937098 1937098 defendant Hall John husbandman 592017 592017 Hall, John, of Assyngton, husbandman 0
3742850 1939616 1939616 defendant Carleys Thomas   592017 592017 Carleys, Thomas, of Assyngton 1
3760788 1945377 1945377 defendant Wygnall William husbandman 592017 592017 Wygnall, William, of Assyngton, husbandman 2
3761507 1945609 1945609 defendant Wygnale William husbandman 592017 592017 Wygnale, William, of Assyngton, husbandman 1
3789225 1954447 1954447 defendant Fegrus John husbandman 592017 592017 Fegrus, John, of Assyngton, husbandman 0
3789228 1954448 1954448 defendant Arnold Thomas husbandman 592017 592017 Arnold, Thomas, of Assyngton, husbandman 1
3789230 1954449 1954449 defendant Pratte John husbandman 592017 592017 Pratte, John, of Assyngton, husbandman 0
3809107 1960731 1960731 defendant Wygnale William husbandman 592017 592017 Wygnale, William, of Assyngton, husbandman 2
3813185 1962034 1962034 defendant Patton Thomas husbandman 592017 592017 Patton, Thomas, of Assyngton, husbandman 1
3814907 1962580 1962580 defendant Corbett Joan widow 592017 592017 Corbett, Joan, of Assyngton, widow 0
3856335 1975600 1975600 plaintiff Woode David (legal representative) 592017 592017 Woode, David, of Assyngton, executor of 0
4532341 2210382 2210382 plaintiff Prentys John   592017 592017 Prentys, John, of Assyngton 0
4532343 2210383 2210383 plaintiff Prentys John   592017 592017 Prentys, John, of Assyngton 0
4720606 2271778 2271778 defendant Swanton William yeoman 592017 592017 Swanton, William, of Assyngton, yeoman 0
4736035 2276410 2276410 plaintiff Styward John weaver 592017 592017 Styward, John, of Assyngton, weaver 0
4746283 2279409 2279409 defendant Swayn William farmer 592017 592017 Swayn, William, of Assyngton, farmer 0
4847007 2310570 2310570 plaintiff Smyth Nicholas   592017 592017 Smyth, Nicholas, of Assyngton 1
5118235 2391773 2391773 defendant Wareyn William yeoman 592017 592017 Wareyn, William, of Assyngton, yeoman 0
5122263 2392935 2392935 defendant Corbet John gent 592017 592017 Corbet, John, of Assyngton, gent 0
5186723 2411865 2411865 defendant Corbet John   592017 592017 Corbet, John, of Assyngton 1
5216548 2420570 2420570 defendant Dorwyn John yeoman 592017 592017 Dorwyn, John, of Assyngton, yeoman 0
5216549 2420570 2420570 defendant Sondon Robert yeoman 592017 592017 Sondon, Robert, of Assyngton, yeoman 1
5216550 2420570 2420570 defendant Steward John husbandman 592017 592017 Steward, John, of Assyngton, husbandman 2
5225052 2422998 2422998 defendant Leme John husbandman 592017 592017 Leme, John, of Assyngton, husbandman 0
5225053 2422998 2422998 defendant Sowdon Robert husbandman 592017 592017 Sowdon, Robert, of Assyngton, husbandman 1
5322861 2451917 2451917 defendant Herry Edmund tailor 592017 592017 Herry, Edmund, of Assyngton, tailor 2
5349857 2460090 2460090 defendant Clerbek Andrew husbandman 592017 592017 Clerbek, Andrew, of Assyngton, husbandman 2
5578922 2528477 2528477 defendant Potter Patrick husbandman 592017 592017 Potter, Patrick, of Assyngton, husbandman 0
5578924 2528477 2528477 defendant Orrell John laborer 592017 592017 Orrell, John, of Assyngton, laborer 2

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