names

56 rows where place_id = 595097

✎ 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
3618895 1873520 1873520 defendant Gresham John gent 595097 595097 Gresham, John, of Holt Market, gent 0
3618896 1873520 1873520 defendant Cobet John butcher 595097 595097 Cobet, John, of Holt Market, butcher 1
3716725 1931522 1931522 defendant Barbyr Thomas husbandman 595097 595097 Barbyr, Thomas, of Holt Market, husbandman 2
3856294 1975586 1975586 defendant Matsale William mercer 595097 595097 Matsale, William, of Holt Market, mercer 0
3909465 1993466 1993466 defendant Mabbys Thomas husbandman 595097 595097 Mabbys, Thomas, of Holt Market, husbandman 0
3921490 1997529 1997529 defendant Grome Nicholas yeoman 595097 595097 Grome, Nicholas, of Holt Market, yeoman 0
3993557 2022440 2022440 plaintiff Harman John   595097 595097 Harman, John, of Holt Market 1
4141314 2075120 2075120 defendant Mowlinge Nicholas yeoman 595097 595097 Mowlinge, Nicholas, of Holt Market, yeoman 0
4141316 2075121 2075121 defendant Mowlynge Nicholas yeoman 595097 595097 Mowlynge, Nicholas, of Holt Market, yeoman 0
4672436 2257032 2257032 defendant Rogers Richard chapman 595097 595097 Rogers, Richard, of Holt Market, chapman 1
4672449 2257035 2257035 defendant Rogers Richard chapman 595097 595097 Rogers, Richard, of Holt Market, chapman 1
4679129 2259081 2259081 plaintiff Ixworth Thomas   595097 595097 Ixworth, Thomas, of Holt Market, on his own account 0
4681491 2259825 2259825 defendant Hosyer Thomas yeoman 595097 595097 Hosyer, Thomas, of Holt Market, yeoman 2
4698159 2264912 2264912 defendant Coppyng or Coppyngt William   595097 595097 Coppyng or Coppyngt, William, of Holt Market, shepherd 0
4702907 2266305 2266305 defendant Freman Robert yeoman 595097 595097 Freman, Robert, of Holt Market, yeoman 0
4813790 2300424 2300424 plaintiff Holtman John   595097 595097 Holtman, John, of Holt Market 0
4813793 2300425 2300425 plaintiff Holtman John   595097 595097 Holtman, John, of Holt Market 0
4813795 2300426 2300426 plaintiff Holtman John   595097 595097 Holtman, John, of Holt Market 0
4903614 2327744 2327744 defendant Holtman John yeoman 595097 595097 Holtman, John, of Holt Market, yeoman 0
4933992 2337012 2337012 defendant Roper John pedder 595097 595097 Roper, John, of Holt Market, pedder 0
5024442 2364060 2364060 plaintiff Holtman John (legal representative) 595097 595097 Holtman, John, of Holt Market, executors of 0
5151415 2401563 2401563 defendant Fochet John   595097 595097 Fochet, John, of Holt Market, mason 0
5169560 2406833 2406833 defendant Fochet John   595097 595097 Fochet, John, of Holt Market, mason 0
5186533 2411811 2411811 defendant Fochet John   595097 595097 Fochet, John, of Holt Market, mason 0
5220097 2421586 2421586 defendant Stokele William yeoman 595097 595097 Stokele, William, of Holt Market, yeoman 2
5287721 2441431 2441431 defendant Carter Robert yeoman 595097 595097 Carter, Robert, of Holt Market, yeoman 0
5291144 2442416 2442416 defendant Rychard Hugh chaplain 595097 595097 Rychard, Hugh, of Holt Market, chaplain 0
5291145 2442416 2442416 defendant Perys Robert yeoman 595097 595097 Perys, Robert, of Holt Market, yeoman 1
5294369 2443328 2443328 defendant Carter Robert yeoman 595097 595097 Carter, Robert, of Holt Market, yeoman 0
5304061 2446219 2446219 defendant Stokeley William husbandman 595097 595097 Stokeley, William, of Holt Market, husbandman 3
5304062 2446219 2446219 defendant West William husbandman 595097 595097 West, William, of Holt Market, husbandman 4
5311315 2448413 2448413 defendant Bawet Robert husbandman 595097 595097 Bawet, Robert, of Holt Market, husbandman 2
5320723 2451291 2451291 defendant Carter Robert husbandman 595097 595097 Carter, Robert, of Holt Market, husbandman 0
5331880 2454615 2454615 defendant Prentys John husbandman 595097 595097 Prentys, John, of Holt Market, or of Melton, husbandman 0
5351216 2460472 2460472 defendant Weston William clerk 595097 595097 Weston, William, of Holt Market, clerk 11
5366440 2465158 2465158 defendant Makke John husbandman 595097 595097 Makke, John, of Holt Market, husbandman 0
5376845 2468351 2468351 defendant Roos Richard esq 595097 595097 Roos, Richard, of Holt Market, esq 0
5377451 2468531 2468531 defendant Johnson William   595097 595097 Johnson, William, of Holt Market, hardware man 0
5388380 2471725 2471725 defendant Perys Robert husbandman 595097 595097 Perys, Robert, of Holt Market, husbandman 0
5393052 2473083 2473083 defendant Lathe William smith 595097 595097 Lathe, William, of Holt Market, smith 2
5413969 2479109 2479109 defendant Perys Robert husbandman 595097 595097 Perys, Robert, of Holt Market, husbandman 0
5419312 2480699 2480699 defendant Lathe William smith 595097 595097 Lathe, William, of Holt market, smith 2
5437555 2486170 2486170 defendant Lathe William smith 595097 595097 Lathe, William, of Holt Market, smith 1
5437573 2486175 2486175 defendant Lathe William smith 595097 595097 Lathe, William, of Holt Market, smith 0
5443720 2488045 2488045 defendant Johnson Robert shoemaker 595097 595097 Johnson, Robert, of Holt Market, shoemaker 0
5456532 2491881 2491881 defendant Johnson Robert shoemaker 595097 595097 Johnson, Robert, of Holt Market, shoemaker 0
5468313 2495464 2495464 defendant Johnson Robert shoemaker 595097 595097 Johnson, Robert, of Holt Market, shoemaker 0
5478302 2498539 2498539 defendant Gresham John gent 595097 595097 Gresham, John, of Holt Market, gent 0
5483749 2500088 2500088 defendant Pyrt Robert raffman 595097 595097 Pyrt, Robert, of Holt Market, raffman 2
5490379 2502016 2502016 defendant Chirch William tailor 595097 595097 Chirch, William, of Holt Market, tailor 0
5491617 2502382 2502382 defendant Chirch William tailor 595097 595097 Chirch, William, of Holt Market, tailor 0
5492252 2502598 2502598 defendant Gresham John gent 595097 595097 Gresham, John, of Holt Market, gent 0
5515362 2509649 2509649 defendant Chyrche William tailor 595097 595097 Chyrche, William, of Holt Market, tailor 0
5520560 2511256 2511256 defendant Gobet John butcher 595097 595097 Gobet, John, of Holt Market, butcher 0
5551007 2520322 2520322 plaintiff Clyfton John mercer 595097 595097 Clyfton, John, of Holt Market, mercer 0
5551008 2520322 2520322 plaintiff Benet William yeoman 595097 595097 Benet, William, of Holt Market, yeoman 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);