names

72 rows where place_id = 600325

✎ 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
3640598 1907500 1907500 defendant Rede Margaret widow 600325 600325 Rede, Margaret, of Carlton, widow 1
3667853 1915887 1915887 defendant Page Henry yeoman 600325 600325 Page, Henry, of Carlton, yeoman 0
3694737 1924558 1924558 plaintiff Palmer Richard   600325 600325 Palmer, Richard, of Carlton 0
3695109 1924686 1924686 defendant Waldyngton Roger yeoman 600325 600325 Waldyngton, Roger, of Carlton, yeoman 0
3703458 1927354 1927354 defendant Yates John husbandman 600325 600325 Yates, John, of Carlton, husbandman 1
3722593 1933327 1933327 defendant Page Richard yeoman 600325 600325 Page, Richard, of Carlton, yeoman 0
3722594 1933327 1933327 defendant Stevyns John yeoman 600325 600325 Stevyns, John, of Carlton, yeoman 1
3754719 1943437 1943437 defendant Byrde William husbandman 600325 600325 Byrde, William, of Carlton, husbandman 0
3766237 1947093 1947093 defendant Yongman Richard husbandman 600325 600325 Yongman, Richard, of Carlton, husbandman 2
3787311 1953823 1953823 defendant Lawty Thomas, junior husbandman 600325 600325 Lawty, Thomas, junior, of Carlton, husbandman 0
3787312 1953823 1953823 defendant Melrose John husbandman 600325 600325 Melrose, John, of Carlton, husbandman 1
3789719 1954614 1954614 defendant Burde William husbandman 600325 600325 Burde, William, of Carlton, husbandman 0
4045924 2040992 2040992 plaintiff Shawe James yeoman 600325 600325 Shawe, James, of Carlton, yeoman 0
4072777 2050564 2050564 defendant Lyncoln John husbandman 600325 600325 Lyncoln, John, of Carlton, husbandman 0
4072778 2050564 2050564 defendant Bottall Richard yeoman 600325 600325 Bottall, Richard, of Carlton, yeoman 1
4072780 2050564 2050564 defendant Yongman Robert sawyer 600325 600325 Yongman, Robert, of Carlton, sawyer 3
4152836 2079100 2079100 defendant Murton Thomas glover 600325 600325 Murton, Thomas, of Carlton, glover 2
4153818 2079435 2079435 defendant Bucke Anthony yeoman 600325 600325 Bucke, Anthony, of Carlton, yeoman 0
4157885 2080832 2080832 defendant Rawson Robert laborer 600325 600325 Rawson, Robert, of Carlton, laborer 3
4188009 2091306 2091306 defendant Appleyarde Robert laborer 600325 600325 Appleyarde, Robert, of Carlton, laborer 0
4189964 2091993 2091993 defendant Deeke Simon husbandman 600325 600325 Deeke, Simon, of Carlton, husbandman 0
4196130 2094193 2094193 defendant Partricke Nicholas, junior singleman 600325 600325 Partricke, Nicholas, junior, of Carlton, yeoman, singleman 1
4202392 2096377 2096377 defendant Crawe Robert laborer 600325 600325 Crawe, Robert, of Carlton, laborer 2
4222033 2103197 2103197 defendant How Henry yeoman 600325 600325 How, Henry, of Carlton, yeoman 1
4299398 2129875 2129875 defendant Crawforthe James yeoman 600325 600325 Crawforthe, James, of Carlton, yeoman 1
4310733 2133898 2133898 defendant Stapleton Brian esq 600325 600325 Stapleton, Brian, of Carlton, esq 0
4310736 2133899 2133899 defendant Stapleton Brian esq 600325 600325 Stapleton, Brian, of Carlton, esq 0
4317534 2136247 2136247 defendant Halliwell Brian yeoman 600325 600325 Halliwell, Brian, of Carlton, yeoman 1
4336971 2142657 2142657 defendant Hindmarshe William clerk 600325 600325 Hindmarshe, William, of Carlton, clerk 1
4359930 2150716 2150716 defendant Blakie Thomas laborer 600325 600325 Blakie, Thomas, of Carlton, laborer 0
4359933 2150717 2150717 defendant Blakie Thomas laborer 600325 600325 Blakie, Thomas, of Carlton, laborer 0
4362651 2151700 2151700 defendant Harlinge John husbandman 600325 600325 Harlinge, John, of Carlton, husbandman 3
4388716 2160859 2160859 defendant Harlinge John husbandman 600325 600325 Harlinge, John, of Carlton, husbandman 3
4497245 2199787 2199787 defendant Caudray Adam   600325 600325 Caudray, Adam, of carlton 5
4507001 2202658 2202658 defendant atte Moor Thomas   600325 600325 atte Moor, Thomas, of Carlton 1
4511528 2204054 2204054 plaintiff Berner John   600325 600325 Berner, John, of Carlton 0
4511529 2204054 2204054 defendant Holcote Henry   600325 600325 Holcote, Henry, of Carlton 0
4517292 2205809 2205809 defendant Proktour William   600325 600325 Proktour, William, of Carlton 0
4525698 2208336 2208336 defendant Hely Robert   600325 600325 Hely, Robert, of Carlton 0
4526021 2208436 2208436 defendant Stokes John   600325 600325 Stokes, John, of Carlton 0
4530025 2209680 2209680 defendant Stokys John   600325 600325 Stokys, John, of Carlton 0
4534867 2211187 2211187 defendant Knoppyng Robert   600325 600325 Knoppyng, Robert, of Carlton 0
4539940 2212760 2212760 defendant del Bank Thomas   600325 600325 del Bank, Thomas, of Carlton 0
4542857 2213655 2213655 defendant Bradshawe Richard   600325 600325 Bradshawe, Richard, of Carlton 0
4578139 2224664 2224664 defendant Ady William   600325 600325 Ady, William, of Carlton 3
4593351 2229206 2229206 defendant Fuyster Thomas   600325 600325 Fuyster, Thomas, of Carlton 1
4597242 2230380 2230380 defendant Shadeworth Thomas   600325 600325 Shadeworth, Thomas, of Carlton 2
4672296 2256984 2256984 defendant Child Alexander shipman 600325 600325 Child, Alexander, of Carlton, shipman 0
4679280 2259129 2259129 plaintiff Joy John   600325 600325 Joy, John, of Carlton 0
4682099 2260020 2260020 defendant Pool Edmund laborer 600325 600325 Pool Edmund, of Carlton, laborer 6
4706044 2267264 2267264 defendant Smyth John   600325 600325 Smyth, John, of Carlton, parson & clerk 0
4712441 2269206 2269206 plaintiff Wyberton Robert   600325 600325 Wyberton, Robert, of Carlton, parson 3
4725057 2273132 2273132 defendant Palyser Thomas chapman 600325 600325 Palyser, Thomas, of Carlton, chapman 1
4743070 2278492 2278492 plaintiff Palmer William   600325 600325 Palmer, William, of Carlton 1
4789585 2292814 2292814 defendant Wylde Robert husbandman 600325 600325 Wylde, Robert, of Carlton, husbandman 3
4794747 2294496 2294496 defendant Owhetlay Richard husbandman 600325 600325 Owhetlay, Richard, of Carlton, husbandman 1
4825339 2303968 2303968 defendant Tracy John husbandman 600325 600325 Tracy, John, of Carlton, husbandman 0
4842440 2309171 2309171 defendant Bathe John husbandman 600325 600325 Bathe, John, of Carlton, husbandman 0
4842441 2309171 2309171 defendant Pole William husbandman 600325 600325 Pole, William, of Carlton, husbandman 1
4855675 2313146 2313146 plaintiff atte Moor John   600325 600325 atte Moor, John, of Carlton 0
4872136 2318245 2318245 defendant Cromwell John husbandman 600325 600325 Cromwell, John, of Carlton, husbandman 5
4879280 2320454 2320454 defendant Wyse Roger   600325 600325 Wyse, Roger, of Carlton 5
4883923 2321881 2321881 defendant Bud William   600325 600325 Bud, William, of Carlton 1
4883924 2321881 2321881 defendant Clerk John clerk 600325 600325 Clerk, John, of Carlton, clerk 2
4883925 2321881 2321881 defendant Kendall Thomas husbandman 600325 600325 Kendall, Thomas, of Carlton, husbandman 3
4883926 2321881 2321881 defendant Carlton Richard husbandman 600325 600325 Carlton, Richard, of Carlton, husbandman 4
4984644 2352338 2352338 plaintiff Wolhous Thomas   600325 600325 Wolhous, Thomas, of Carlton 2
5000677 2357071 2357071 defendant Cother William butcher 600325 600325 Cother, William, of Carlton, butcher 0
5003146 2357825 2357825 plaintiff Palmer John   600325 600325 Palmer, John, of Carlton 0
5097164 2385606 2385606 defendant Gun Robert husbandman 600325 600325 Gun, Robert, of Carlton, husbandman 1
5123459 2393311 2393311 defendant Frysbe Thomas husbandman 600325 600325 Frysbe, Thomas, of Carlton, husbandman 0
5315076 2449563 2449563 defendant Lyftchylde Thomas husbandman 600325 600325 Lyftchylde, Thomas, of Carlton, 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);