names

84 rows where place_id = 590409

✎ 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
3601124 1868014 1868014 defendant Whyte William yeoman 590409 590409 Whyte, William, of Costessey, yeoman 1
3601373 1868092 1868092 defendant Esmondes William esq 590409 590409 Esmondes, William, of Costessey, esq 0
3605092 1869257 1869257 defendant Esmond William gent 590409 590409 Esmond, William, of Costessey, gent 5
3605894 1869507 1869507 defendant Esmond William esq 590409 590409 Esmond, William, of Costessey, esq 0
3607803 1870092 1870092 defendant Whyte William yeoman 590409 590409 Whyte, William, of Costessey, yeoman 0
3608135 1870196 1870196 defendant Whyte William yeoman 590409 590409 Whyte, William, of Costessey, yeoman 1
3611938 1871395 1871395 defendant Brayder Nicholas laborer 590409 590409 Brayder, Nicholas, of Costessey, laborer 1
3625530 1875524 1875524 plaintiff Wood John   590409 590409 Wood, John, of Costessey 0
3637631 1906581 1906581 defendant Smyth Roger yeoman 590409 590409 Smyth, Roger, of Costessey, yeoman 0
3642470 1908088 1908088 defendant Smyth Roger yeoman 590409 590409 Smyth, Roger, of Costessey, yeoman 3
3654564 1911689 1911689 defendant Smyth Roger yeoman 590409 590409 Smyth, Roger, of Costessey, yeoman 1
3659462 1913217 1913217 plaintiff Goos Thomas (legal representative) 590409 590409 Goos, Thomas, of Costessey, vicar, executor of 0
3847830 1972897 1972897 defendant Baron alias Barne Nicholas husbandman 590409 590409 Baron alias Barne, Nicholas, of Costessey, husbandman 0
3847832 1972897 1972897 defendant Yarham John husbandman 590409 590409 Yarham, John, of Costessey, husbandman 2
4009811 2028284 2028284 defendant Lowe Thomas husbandman 590409 590409 Lowe, Thomas, of Costessey, husbandman 0
4009812 2028284 2028284 defendant Amys Robert husbandman 590409 590409 Amys, Robert, of Costessey, husbandman 1
4117748 2066640 2066640 defendant Corpe William   590409 590409 Corpe, William, of Costessey, rough mason 2
4117749 2066640 2066640 defendant Yarham Thomas husbandman 590409 590409 Yarham, Thomas, of Costessey, husbandman 3
4131194 2071476 2071476 defendant Shafer John laborer 590409 590409 Shafer, John, of Costessey, laborer 2
4131195 2071476 2071476 defendant Godale Edward husbandman 590409 590409 Godale, Edward, of Costessey, husbandman 3
4167560 2084149 2084149 defendant Cooke Henry husbandman 590409 590409 Cooke, Henry, of Costessey, husbandman 0
4170541 2085192 2085192 defendant Donne William husbandman 590409 590409 Donne, William, of Costessey, husbandman 3
4190461 2092217 2092217 defendant Crowe Thomas husbandman 590409 590409 Crowe, Thomas, of Costessey, husbandman 1
4193088 2093150 2093150 defendant Taylor Edward yeoman 590409 590409 Taylor, Edward, of Costessey, yeoman 1
4228942 2105604 2105604 defendant Jacobb William husbandman 590409 590409 Jacobb, William, of Costessey, husbandman 0
4229492 2105801 2105801 defendant Fisher Henry yeoman 590409 590409 Fisher, Henry, of Costessey, yeoman 0
4247241 2112054 2112054 defendant Johnson John warrener 590409 590409 Johnson John, of Costessey, warrener 3
4259933 2116291 2116291 defendant Jacobb William   590409 590409 Jacobb, William, of Costessey, or of Easton or Gaston yeoman 2
4277288 2121987 2121987 defendant Cocke William yeoman 590409 590409 Cocke, William, of Costessey, yeoman 0
4326365 2139182 2139182 defendant Gedge Denis smith 590409 590409 Gedge, Denis, of Costessey, smith 3
4328772 2139935 2139935 defendant Dalle Robert yeoman 590409 590409 Dalle, Robert, of Costessey, yeoman 0
4331852 2140947 2140947 defendant Dell Henry singleman 590409 590409 Dell, Henry, of Costessey, husbandman, singleman 0
4336610 2142530 2142530 defendant Hysham George husbandman 590409 590409 Hysham, George, of Costessey, husbandman 3
4341889 2144439 2144439 defendant Harper George miller 590409 590409 Harper, George, of Costessey, miller 0
4341890 2144439 2144439 defendant Harper John miller 590409 590409 Harper, John, of Costessey, miller 1
4345109 2145563 2145563 defendant Dall Francis yeoman 590409 590409 Dall, Francis, of Costessey, yeoman 1
4345110 2145563 2145563 defendant Dall Henry yeoman 590409 590409 Dall, Henry, of Costessey, yeoman 2
4386340 2160109 2160109 defendant Tollyn John husbandman 590409 590409 Tollyn, John, of Costessey, husbandman 0
4390658 2161491 2161491 defendant Gedge Denis smith 590409 590409 Gedge, Denis, of Costessey, smith 0
4398532 2164088 2164088 defendant Gedge or Gede Denis smith 590409 590409 Gedge or Gede, Denis, of Costessey, smith 0
4407807 2167177 2167177 defendant Cooke Henry husbandman 590409 590409 Cooke, Henry, of Costessey, husbandman 0
5301311 2445345 2445345 defendant Roche Thomas (legal representative) 590409 590409 Roche, Thomas, of Costessey, husbandman, executrix of 0
5311887 2448581 2448581 plaintiff Palmer John yeoman 590409 590409 Palmer, John, of Costessey, yeoman 1
5329669 2453941 2453941 defendant Palmer John yeoman 590409 590409 Palmer, John, of Costessey, yeoman 1
5330677 2454254 2454254 defendant Palmer William yeoman 590409 590409 Palmer, William, of Costessey, yeoman 0
5331817 2454595 2454595 defendant Marowe Geoffrey yeoman 590409 590409 Marowe, Geoffrey, of Costessey, yeoman 2
5342991 2457997 2457997 defendant Coche Roger yeoman 590409 590409 Coche, Roger, of Costessey, yeoman 0
5342992 2457997 2457997 defendant Wode Martin yeoman 590409 590409 Wode, Martin, of Costessey, yeoman 1
5342994 2457997 2457997 defendant Wode John yeoman 590409 590409 Wode, John, of Costessey, yeoman 3
5342999 2457998 2457998 defendant Coche Roger yeoman 590409 590409 Coche, Roger, of Costessey, yeoman 0
5343000 2457998 2457998 defendant Wode Martin yeoman 590409 590409 Wode, Martin, of Costessey, yeoman 1
5343002 2457998 2457998 defendant Wode John yeoman 590409 590409 Wode, John, of Costessey, yeoman 3
5348271 2459600 2459600 defendant Whyte William yeoman 590409 590409 Whyte, William, of Costessey, yeoman 3
5348279 2459601 2459601 defendant White William yeoman 590409 590409 White, William, of Costessey, yeoman 5
5380610 2469505 2469505 defendant Whyte William yeoman 590409 590409 Whyte, William, of Costessey, yeoman 1
5384768 2470725 2470725 defendant Whyte William husbandman 590409 590409 Whyte, William, of Costessey, husbandman 13
5385409 2470906 2470906 defendant Whyte William yeoman 590409 590409 Whyte, William, of Costessey, yeoman 1
5397548 2474374 2474374 defendant Goche Roger yeoman 590409 590409 Goche, Roger, of Costessey, yeoman 0
5397549 2474374 2474374 defendant Whyte William yeoman 590409 590409 Whyte, William, of Costessey, yeoman 1
5406641 2476968 2476968 defendant Sabarn John   590409 590409 Sabarn, John, of Costessey, hair man 0
5408296 2477449 2477449 defendant Palmer John yeoman 590409 590409 Palmer, John, of Costessey, yeoman 0
5408297 2477449 2477449 defendant Wode Martin yeoman 590409 590409 Wode, Martin, of Costessey, yeoman 1
5408298 2477449 2477449 defendant Bunton Nicholas yeoman 590409 590409 Bunton, Nicholas, of Costessey, yeoman 2
5408299 2477449 2477449 defendant White William yeoman 590409 590409 White, William, of Costessey, yeoman 3
5417147 2480035 2480035 defendant Whyte William yeoman 590409 590409 Whyte, William, of Costessey, yeoman 0
5419792 2480835 2480835 defendant Sabarn John hairman 590409 590409 Sabarn, John, of Costessey, hairman 0
5426947 2483003 2483003 defendant Coche Roger yeoman 590409 590409 Coche, Roger, of Costessey, yeoman 2
5426963 2483004 2483004 defendant Coche Roger yeoman 590409 590409 Coche, Roger, of Costessey, yeoman 2
5431550 2484391 2484391 defendant Palmer John yeoman 590409 590409 Palmer, John, of Costessey, yeoman 0
5431554 2484392 2484392 defendant Wade Martin yeoman 590409 590409 Wade, Martin, of Costessey, yeoman 0
5431556 2484392 2484392 defendant White William yeoman 590409 590409 White, William, of Costessey, yeoman 2
5431559 2484393 2484393 defendant Wode Martin yeoman 590409 590409 Wode, Martin, of Costessey, yeoman 0
5431560 2484393 2484393 defendant Gunton Nicholas yeoman 590409 590409 Gunton, Nicholas, of Costessey, yeoman 1
5431561 2484393 2484393 defendant White William yeoman 590409 590409 White, William, of Costessey, yeoman 2
5434301 2485196 2485196 defendant Whyte William yeoman 590409 590409 Whyte, William, of Costessey, yeoman 0
5438282 2486383 2486383 defendant Sabarn John   590409 590409 Sabarn, John, of Costessey, hair man 0
5438284 2486384 2486384 defendant Sabarn John hairman 590409 590409 Sabarn, John, of Costessey, hairman 0
5449701 2489798 2489798 defendant White William yeoman 590409 590409 White, William, of Costessey, yeoman 0
5461857 2493489 2493489 defendant Whyte William yeoman 590409 590409 Whyte, William, of Costessey, yeoman 0
5478502 2498598 2498598 defendant Whyte William yeoman 590409 590409 Whyte, William, of Costessey, yeoman 0
5513476 2509060 2509060 defendant Lacheles Thomas fuller 590409 590409 Lacheles, Thomas, of Costessey, fuller 2
5564871 2524311 2524311 defendant Smyth Roger yeoman 590409 590409 Smyth, Roger, of Costessey, yeoman 0
5590569 2532019 2532019 defendant Knyght William husbandman 590409 590409 Knyght, William, of Costessey, husbandman 0
5596381 2533779 2533779 defendant Philbek William husbandman 590409 590409 Philbek, William, of Costessey, 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);