names

130 rows where place_id = 589839

✎ 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
3598950 1867299 1867299 defendant Smale Richard yeoman 589839 589839 Smale, Richard, of Herne, yeoman 3
3602267 1868374 1868374 defendant Cobell Henry husbandman 589839 589839 Cobell, Henry, of Herne, husbandman 0
3602274 1868376 1868376 defendant Cobell Henry husbandman 589839 589839 Cobell, Henry, of Herne, husbandman 0
3611771 1871346 1871346 defendant Davy Vincent husbandman 589839 589839 Davy, Vincent, of Herne, husbandman 0
3630065 1904250 1904250 defendant at See William yeoman 589839 589839 at See, William, of Herne, yeoman 0
3666321 1915418 1915418 defendant Onyende William husbandman 589839 589839 Onyende, William, of Herne, husbandman 0
3773950 1949569 1949569 defendant Worde John husbandman 589839 589839 Worde, John, of Herne, husbandman 0
3877938 1982866 1982866 defendant Hawelet Thomas mariner 589839 589839 Hawelet, Thomas, of Herne, mariner 0
3887630 1986110 1986110 defendant Broke Thomas yeoman 589839 589839 Broke, Thomas, of Herne, yeoman 0
3887631 1986110 1986110 defendant Ewell John laborer 589839 589839 Ewell, John, of Herne, laborer 1
3901588 1990757 1990757 defendant Ryder Thomas laborer 589839 589839 Ryder, Thomas, of Herne, laborer 0
3901589 1990757 1990757 defendant Howell Roger fuller 589839 589839 Howell, Roger, of Herne, fuller 1
3901590 1990757 1990757 defendant White Christopher tailor 589839 589839 White, Christopher, of Herne, tailor 2
3908469 1993129 1993129 defendant Badock Richard butcher 589839 589839 Badock, Richard, of Herne, butcher 0
3950197 2007153 2007153 defendant Button William yeoman 589839 589839 Button, William, of Herne, yeoman 1
3981955 2018309 2018309 defendant Cowper Edmund yeoman 589839 589839 Cowper, Edmund, of Herne, yeoman 1
4022621 2032812 2032812 defendant Button William yeoman 589839 589839 Button, William, of Herne, yeoman 0
4044799 2040592 2040592 defendant Warde Henry chapman 589839 589839 Warde, Henry, of Herne, chapman 0
4044802 2040592 2040592 defendant Norrys John chapman 589839 589839 Norrys, John, of Herne, chapman 3
4056995 2044885 2044885 defendant Fraunkleyn James yeoman 589839 589839 Fraunkleyn, James, of Herne, yeoman 0
4057631 2045110 2045110 plaintiff Byrche William yeoman 589839 589839 Byrche, William, of Herne, yeoman 0
4246187 2111703 2111703 defendant Ryder Richard husbandman 589839 589839 Ryder, Richard, of Herne, husbandman 0
4355643 2149199 2149199 defendant Trice Thomas, senior yeoman 589839 589839 Trice, Thomas, senior, of Herne, yeoman 0
4355644 2149199 2149199 defendant Browne Robert yeoman 589839 589839 Browne, Robert, of Herne, yeoman 1
4355645 2149199 2149199 defendant Trice John husbandman 589839 589839 Trice, John, of Herne, husbandman 2
4355646 2149199 2149199 defendant Trice William husbandman 589839 589839 Trice, William, of Herne, husbandman 3
4355647 2149199 2149199 defendant Trice Thomas, junior husbandman 589839 589839 Trice, Thomas, junior, of Herne, husbandman 4
4355648 2149199 2149199 defendant Parromore William yeoman 589839 589839 Parromore, William, of Herne, yeoman 5
4371280 2154792 2154792 defendant Ryder George yeoman 589839 589839 Ryder, George, of Herne, yeoman 0
4371281 2154792 2154792 defendant Seathe Robert husbandman 589839 589839 Seathe, Robert, of Herne, husbandman 1
4371282 2154792 2154792 defendant Parker Samuel husbandman 589839 589839 Parker, Samuel, of Herne, husbandman 2
4394443 2162738 2162738 defendant Amys Adam yeoman 589839 589839 Amys, Adam, of Herne, yeoman 2
4432028 2174797 2174797 defendant Blok John   589839 589839 Blok, John, of Herne 0
4432032 2174798 2174798 defendant Blok John   589839 589839 Blok, John, of Herne 0
4496281 2199510 2199510 defendant Colnewod William   589839 589839 Colnewod, William, of Herne 1
4496282 2199510 2199510 defendant Colnewod Thomas   589839 589839 Colnewod, Thomas, of Herne, son of William 2
4516448 2205553 2205553 defendant Colnewode William   589839 589839 Colnewode, William, of Herne 0
4516449 2205553 2205553 defendant Colnewode Thomas   589839 589839 Colnewode, Thomas, of Herne, son of William 1
4548537 2215484 2215484 defendant Paynoy Robert   589839 589839 Paynoy, Robert, of Herne 1
4550438 2216082 2216082 defendant Davy Richard   589839 589839 Davy, Richard, of Herne, shoe maker 0
4550447 2216084 2216084 defendant Person Peter shoemaker 589839 589839 Person, Peter, of Herne, shoemaker 2
4553855 2217128 2217128 defendant Davy John   589839 589839 Davy, John, of Herne 0
4554948 2217474 2217474 defendant Aleyn John   589839 589839 Aleyn, John, of Herne, son of Geoffrey 0
4558156 2218491 2218491 defendant Haghe Robert, sen   589839 589839 Haghe, Robert, sen, of Herne 0
4610276 2234297 2234297 defendant Yunge John   589839 589839 Yunge, John, of Herne 0
4671738 2256804 2256804 defendant Hoghtyng Stephen laborer 589839 589839 Hoghtyng, Stephen, of Herne, laborer 3
4730782 2274830 2274830 defendant May William clerk 589839 589839 May, William, of Herne, clerk 0
4756699 2282459 2282459 defendant Hamon Thomas husbandman 589839 589839 Hamon, Thomas, of Herne, husbandman 0
4783029 2290710 2290710 defendant Goffe William clerk 589839 589839 Goffe, William, of Herne, clerk 0
4801552 2296667 2296667 defendant May Richard laborer 589839 589839 May, Richard, of Herne, laborer 0
4804054 2297452 2297452 plaintiff Beralot William   589839 589839 Beralot, William, of Herne 0
4807723 2298604 2298604 defendant Aleyn John, junior laborer 589839 589839 Aleyn, John, junior, of Herne, laborer 0
4807724 2298604 2298604 defendant Aleyn Margery spinster 589839 589839 Aleyn, Margery, of Herne, spinster 1
4836991 2307528 2307528 defendant Dene William husbandman 589839 589839 Dene, William, of Herne, husbandman 0
4892842 2324491 2324491 defendant Veyrware John husbandman 589839 589839 Veyrware, John, of Herne, husbandman 0
4919051 2332471 2332471 defendant Veyrware John husbandman 589839 589839 Veyrware, John, of Herne, husbandman 0
4944736 2340340 2340340 defendant Veyrware John husbandman 589839 589839 Veyrware, John, of Herne, husbandman 0
4992607 2354671 2354671 defendant Hamond Robert husbandman 589839 589839 Hamond, Robert, of Herne, husbandman 0
4992609 2354671 2354671 defendant Bolle Richard husbandman 589839 589839 (Bolle, Richard, of Herne, husbandman 2
5037472 2367830 2367830 defendant Aleyn John laborer 589839 589839 Aleyn, John, of Herne, laborer 0
5037473 2367830 2367830 defendant Aleyn Thomas husbandman 589839 589839 Aleyn, Thomas, of Herne, husbandman 1
5044742 2370062 2370062 defendant Carpenter William carpneter 589839 589839 Carpenter, William, of Herne, carpneter 0
5045561 2370302 2370302 defendant Carpenter William husbandman 589839 589839 Carpenter, William, of Herne, husbandman 0
5070133 2377561 2377561 defendant Bate John husbandman 589839 589839 Bate, John, of Herne, husbandman 1
5094822 2384898 2384898 defendant Fayreware Thomas husbandman 589839 589839 Fayreware, Thomas, of Herne, husbandman 0
5094823 2384898 2384898 defendant Fayreware William husbandman 589839 589839 Fayreware, William, of Herne, husbandman 1
5103143 2387343 2387343 defendant Hamond John laborer 589839 589839 Hamond, John, of Herne, laborer 0
5108924 2389031 2389031 defendant Knepe William husbandman 589839 589839 Knepe, William, of Herne, husbandman 0
5111065 2389625 2389625 defendant Walter Nicholas laborer 589839 589839 Walter, Nicholas, of Herne, laborer 0
5111066 2389625 2389625 defendant Lynche Henry laborer 589839 589839 Lynche, Henry, of Herne, laborer 1
5215139 2420150 2420150 defendant Baker Thomas barber 589839 589839 Baker, Thomas, of Herne, barber 0
5251684 2430631 2430631 defendant Wormynton or Worvyngton Christopher clerk 589839 589839 Wormynton or Worvyngton, Christopher, of Herne, clerk 0
5252723 2430959 2430959 defendant Parys Sampson chaplain 589839 589839 Parys, Sampson, of Herne, chaplain 0
5259551 2433110 2433110 defendant Davy Robert husbandman 589839 589839 Davy, Robert, of Herne, husbandman 1
5278325 2438763 2438763 defendant Horn Robert husbandman 589839 589839 Horn, Robert, of Herne, husbandman 0
5279426 2439067 2439067 defendant Davy Robert husbandman 589839 589839 Davy, Robert, of Herne, husbandman 4
5279433 2439068 2439068 defendant Davy Robert husbandman 589839 589839 Davy, Robert, of Herne, husbandman 4
5286084 2440938 2440938 defendant Fraunceys Thomas, junior   589839 589839 Fraunceys, Thomas, junior, of Herne, holy water clerk 0
5299754 2444897 2444897 defendant Jacobbe William laborer 589839 589839 Jacobbe, William, of Herne, laborer 2
5312865 2448879 2448879 defendant Elmer James husbandman 589839 589839 Elmer, James, of Herne, husbandman 0
5312866 2448879 2448879 defendant Daneel Robert husbandman 589839 589839 Daneel, Robert, of Herne, husbandman 1
5312868 2448880 2448880 defendant Elmer James husbandman 589839 589839 Elmer, James, of Herne, husbandman 0
5312871 2448881 2448881 defendant Fayreware John husbandman 589839 589839 Fayreware, John, of Herne, husbandman 0
5331377 2454464 2454464 defendant Bocher alias Apilton John butcher 589839 589839 Bocher alias Apilton, John, of Herne, butcher 0
5332512 2454788 2454788 defendant Salkyn John thatcher 589839 589839 Salkyn, John, of Herne, thatcher 0
5334966 2455527 2455527 defendant Walter Nicholas husbandman 589839 589839 Walter, Nicholas, of Herne, husbandman 0
5334967 2455527 2455527 defendant Hode John husbandman 589839 589839 Hode, John, of Herne, husbandman 1
5336987 2456135 2456135 defendant Baker John, senior husbandman 589839 589839 Baker, John, senior, of Herne, husbandman 0
5336988 2456135 2456135 defendant Baker John, junior cordwainer 589839 589839 Baker, John, junior, of Herne, cordwainer 1
5346468 2459040 2459040 defendant Hykke atte Sole John husbandman 589839 589839 Hykke atte Sole, John, of Herne, husbandman 1
5359770 2463096 2463096 defendant Martyn Thomas husbandman 589839 589839 Martyn, Thomas, of Herne, husbandman 1
5374851 2467729 2467729 defendant Taillour Vincent   589839 589839 Taillour, Vincent, of Herne, ship man 0
5385832 2471017 2471017 defendant Stud Vincent husbandman 589839 589839 Stud, Vincent, of Herne, husbandman 0
5386754 2471278 2471278 defendant At See William yeoman 589839 589839 At See, William, of Herne, yeoman 0
5387065 2471369 2471369 defendant Kelby John   589839 589839 Kelby, John, of Herne, parish clerk 1
5391407 2472620 2472620 defendant Taillour Richard husbandman 589839 589839 Taillour, Richard, of Herne, husbandman 0
5391408 2472620 2472620 defendant Calcot William husbandman 589839 589839 Calcot, William, of Herne, husbandman 1
5399781 2475031 2475031 defendant Aleyn Edmund laborer 589839 589839 Aleyn, Edmund, of Herne, laborer 0
5412761 2478766 2478766 defendant Alyn Edmund laborer 589839 589839 Alyn, Edmund, of Herne, laborer 0
5412762 2478766 2478766 defendant Kenet Stephen laborer 589839 589839 Kenet, Stephen, of Herne, laborer 1

Next page

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