names

46 rows where place_id = 586303

✎ 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
3588391 1864018 1864018 defendant Amy John laborer 586303 586303 Amy, John, of Rysby, laborer 3
3605629 1869426 1869426 plaintiff Page Roger   586303 586303 Page, Roger, of Rysby 2
3605634 1869427 1869427 plaintiff Page Roger   586303 586303 Page, Roger, of Rysby 2
3642724 1908170 1908170 plaintiff Chyrche Thomas clerk 586303 586303 Chyrche, Thomas, of Rysby, clerk 0
3664959 1914985 1914985 defendant Ellerkey Ralph, senior   586303 586303 Ellerkey, Ralph, senior, of Rysby, knight 1
3741118 1939084 1939084 defendant Jamys John husbandman 586303 586303 Jamys, John, of Rysby, or of Bradley Magna, husbandman 0
3762385 1945879 1945879 defendant Cherche John husbandman 586303 586303 Cherche, John, of Rysby, husbandman 1
3867862 1979483 1979483 defendant Tounesend John   586303 586303 Tounesend, John, of Rysby, shepherd 1
3867869 1979486 1979486 defendant Townesend John   586303 586303 Townesend, John, of Rysby, shepherd 1
3896317 1988980 1988980 defendant Webbe Robert yeoman 586303 586303 (Webbe, Robert, of Rysby, yeoman 1
4491590 2198054 2198054 defendant Breseworth John   586303 586303 Breseworth, John, of Rysby, parson 0
4603304 2232234 2232234 plaintiff Wode William   586303 586303 Wode, William, of Rysby 0
4628273 2239770 2239770 defendant Ellerker John   586303 586303 Ellerker, John, of Rysby 0
4628290 2239775 2239775 defendant Ingeland John   586303 586303 Ingeland, John, of Rysby 0
4638743 2242858 2242858 defendant Amy Thomas   586303 586303 Amy, Thomas, of Rysby 1
4651236 2246391 2246391 defendant Wykeham Richard   586303 586303 Wykeham, Richard, of Rysby, wright 2
4651240 2246392 2246392 defendant Wykeham Richard   586303 586303 Wykeham, Richard, of Rysby, wright 2
4733029 2275508 2275508 defendant Wykham Richard husbandman 586303 586303 Wykham, Richard, of Rysby, husbandman 1
4744986 2279047 2279047 defendant Grene Andrew yeoman 586303 586303 (Grene, Andrew, of Rysby, yeoman 1
4803999 2297434 2297434 defendant Hykedon John husbandman 586303 586303 Hykedon, John, of Rysby, husbandman 0
4826848 2304435 2304435 defendant Porter John husbandman 586303 586303 Porter, John, of rysby, husbandman 2
4851441 2311896 2311896 defendant Sclater Richard husbandman 586303 586303 Sclater, Richard, of Rysby, husbandman 3
4879427 2320497 2320497 defendant Sclater Robert husbandman 586303 586303 Sclater, Robert, of Rysby, husbandman 1
4911434 2330078 2330078 defendant Bradehede John husbandman 586303 586303 Bradehede, John, of Rysby, husbandman 0
4911435 2330078 2330078 defendant Lanes William husbandman 586303 586303 Lanes, William, of Rysby, husbandman 1
4915389 2331321 2331321 defendant Lowes William husbandman 586303 586303 Lowes, William, of Rysby, husbandman 0
4931351 2336185 2336185 defendant Weton Robert weaver 586303 586303 Weton, Robert, of rysby, weaver 0
4996951 2355942 2355942 defendant Lawys William husbandman 586303 586303 Lawys, William, of Rysby, husbandman 1
5001707 2357396 2357396 defendant Taillour John tailor 586303 586303 Taillour, John, of Rysby, tailor 0
5018557 2362310 2362310 defendant Bolle John   586303 586303 Bolle, John, of Rysby, ploughwright 0
5022591 2363513 2363513 plaintiff Grene Andrew   586303 586303 Grene, Andrew, of Rysby 0
5041899 2369174 2369174 defendant Clement Roger laborer 586303 586303 Clement, Roger, of Rysby, laborer 0
5043503 2369678 2369678 defendant Bradehed William husbandman 586303 586303 Bradehed, William, of Rysby, husbandman 2
5043504 2369678 2369678 defendant Sproxton William husbandman 586303 586303 Sproxton, William, of Rysby, husbandman 3
5060956 2374847 2374847 defendant Scarlet William gent 586303 586303 Scarlet, William, of Rysby, gent 0
5086897 2382560 2382560 defendant Coderton Thomas gent 586303 586303 Coderton, Thomas, of Rysby, gent 1
5201018 2416054 2416054 defendant Laxton Robert husbandman 586303 586303 Laxton, Robert, of Rysby, husbandman 1
5202824 2416592 2416592 defendant Bokelond John yeoman 586303 586303 Bokelond, John, of Rysby, yeoman 3
5218545 2421154 2421154 plaintiff Page Roger   586303 586303 Page, Roger, of Rysby 3
5263271 2434257 2434257 defendant Rocard Henry   586303 586303 Rocard, Henry, of Rysby, shepherd 2
5263272 2434257 2434257 defendant Busard Stephen   586303 586303 Busard, Stephen, of Rysby, shepherd 3
5325408 2452685 2452685 defendant Nobyll John husbandman 586303 586303 Nobyll, John, of Rysby, husbandman 0
5336814 2456075 2456075 defendant Bullok James   586303 586303 Bullok, James, of Rysby, wheelwright 2
5469627 2495835 2495835 defendant Page Roger yeoman 586303 586303 Page, Roger, of Rysby, yeoman 2
5480943 2499253 2499253 defendant Page Roger yeoman 586303 586303 Page, Roger, of Rysby, yeoman 2
5523324 2512125 2512125 defendant Ellerker Ralph   586303 586303 Ellerker, Ralph, of Rysby, knight 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);