names

58 rows where place_id = 592654

✎ 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
3608414 1870291 1870291 defendant Ayssherygh alias Dodyngton John butcher 592654 592654 Ayssherygh alias Dodyngton, John, of North Tauton, butcher 1
3623149 1874762 1874762 defendant Furryer Walter husbandman 592654 592654 Furryer, Walter, of North Tauton, husbandman 2
3623150 1874762 1874762 defendant Martyn John laborer 592654 592654 Martyn, John, of North Tauton, laborer 3
3625037 1875362 1875362 defendant Colle John gent 592654 592654 Colle, John, of North Tauton, gent 0
4480103 2194435 2194435 defendant Bailly John   592654 592654 Bailly, John, of North Tauton 4
4655249 2247527 2247527 defendant Blanchard William fisher 592654 592654 Blanchard, William, of North Tauton, fisher 0
4663962 2250212 2250212 defendant Pafford Ralph husbandman 592654 592654 Pafford, Ralph, of North Tauton, husbandman 0
4678856 2258987 2258987 defendant Wyke Peter smith 592654 592654 Wyke, Peter, of North Tauton, smith 2
4796311 2294994 2294994 defendant Stoyle Gilbert weaver 592654 592654 Stoyle, Gilbert, of North Tauton, weaver 1
4796314 2294995 2294995 defendant Stoyle Gilbert weaver 592654 592654 Stoyle, Gilbert, of North Tauton, weaver 1
4893600 2324699 2324699 defendant Barre Thomas gent 592654 592654 Barre, Thomas, of North Tauton, gent 2
4984664 2352343 2352343 defendant Wyke William smith 592654 592654 Wyke, William, of North Tauton, smith 0
4985237 2352511 2352511 defendant Wynsham William   592654 592654 Wynsham, William, of North Tauton, bailiff 5
5006076 2358665 2358665 defendant Stoyle Henry husbandman 592654 592654 Stoyle, Henry, of North Tauton, husbandman 0
5006077 2358665 2358665 defendant Dodyngton Thomas butcher 592654 592654 Dodyngton, Thomas, of North Tauton, butcher 1
5015870 2361534 2361534 defendant Stoyle Henry husbandman 592654 592654 Stoyle, Henry, of North Tauton, husbandman 0
5015871 2361534 2361534 defendant Ayssherygge henry fisher 592654 592654 Ayssherygge, henry, of North Tauton, fisher 1
5015872 2361534 2361534 defendant Curteys William husbandman 592654 592654 Curteys, William, of North Tauton, husbandman 2
5015873 2361534 2361534 defendant Hayes John husbandman 592654 592654 Hayes, John, of North Tauton, husbandman 3
5015874 2361534 2361534 defendant Chamberleyn John husbandman 592654 592654 Chamberleyn, John, of North Tauton, husbandman 4
5037898 2367965 2367965 defendant Lybet or Lyvet Walter clerk 592654 592654 Lybet or Lyvet, Walter, of North Tauton, clerk 1
5037904 2367965 2367965 defendant Weryng Henry husbandman 592654 592654 Weryng, Henry, of North Tauton, husbandman 7
5060729 2374789 2374789 defendant Brigge John yeoman 592654 592654 Brigge, John, of North Tauton, yeoman 0
5066232 2376425 2376425 defendant Weryng John husbandman 592654 592654 Weryng, John, of North Tauton, husbandman 1
5066235 2376426 2376426 defendant Weryng John husbandman 592654 592654 Weryng, John, of North Tauton, husbandman 1
5071883 2378085 2378085 defendant Weryng John, junior husbandman 592654 592654 Weryng, John, junior, of North Tauton, husbandman 0
5071884 2378085 2378085 defendant Weryng Gilbert laborer 592654 592654 Weryng, Gilbert, of North Tauton, laborer 1
5072445 2378246 2378246 defendant Westecote John weaver 592654 592654 Westecote, John, of North Tauton, weaver 1
5072446 2378246 2378246 defendant Westecote Roger husbandman 592654 592654 Westecote, Roger, of North Tauton, husbandman 2
5074389 2378843 2378843 defendant Wode John, senior gent 592654 592654 Wode, John, senior, of North Tauton, gent 0
5074390 2378843 2378843 defendant Wode John, junior gent 592654 592654 Wode, John, junior, of North Tauton, gent 1
5074391 2378843 2378843 defendant Wike William gent 592654 592654 Wike, William, of North Tauton, gent 2
5074392 2378843 2378843 defendant Comehede William husbandman 592654 592654 Comehede, William, of North Tauton, husbandman 3
5074393 2378843 2378843 defendant Norys John laborer 592654 592654 Norys, John, of North Tauton, laborer 4
5077553 2379785 2379785 defendant Sampford Hugh gent 592654 592654 Sampford, Hugh, of North Tauton, gent 0
5096809 2385497 2385497 defendant Sampford Baldwin gent 592654 592654 Sampford, Baldwin, of North Tauton, gent 1
5096811 2385498 2385498 defendant Sampford Baldwin gent 592654 592654 Sampford, Baldwin, of North Tauton, gent 0
5130540 2395415 2395415 defendant Nottecombe John   592654 592654 Nottecombe, John, of North Tauton 0
5149938 2401112 2401112 defendant Nottecombe John   592654 592654 Nottecombe, John, of North Tauton, parson 0
5288968 2441780 2441780 defendant Walwen John husbandman 592654 592654 Walwen, John, of North Tauton, husbandman 0
5288969 2441780 2441780 defendant Cole William shoemaker 592654 592654 Cole, William, of North Tauton, shoemaker 1
5288970 2441780 2441780 defendant Stoyle Walter husbandman 592654 592654 Stoyle, Walter, of North Tauton, husbandman 2
5296537 2443976 2443976 defendant Dodyngton Henry fisher 592654 592654 together with Dodyngton, Henry, of North Tauton, fisher 1
5296552 2443981 2443981 plaintiff Wode John esq 592654 592654 Wode, John, of North Tauton, esq 0
5310374 2448137 2448137 defendant Batyn Walter yeoman 592654 592654 Batyn, Walter, of North Tauton, yeoman 2
5311392 2448441 2448441 defendant Pafford Ivan husbandman 592654 592654 Pafford, Ivan, of North Tauton, husbandman 0
5311393 2448441 2448441 defendant Dowene Walter laborer 592654 592654 Dowene, Walter, of North Tauton, laborer 1
5342178 2457745 2457745 defendant Ayssherygge Henry yeoman 592654 592654 Ayssherygge, Henry, of North Tauton, yeoman 6
5430064 2483926 2483926 defendant William William dyer 592654 592654 William, William, of North Tauton, dyer 0
5533168 2514921 2514921 defendant Colle John gent 592654 592654 Colle, John, of North Tauton, gent 0
5534413 2515304 2515304 defendant Helyer Peter dyer 592654 592654 Helyer, Peter, of North Tauton, dyer 0
5538525 2516531 2516531 defendant Sampson John yeoman 592654 592654 Sampson, John, of North Tauton, yeoman 0
5569356 2525596 2525596 defendant Gove Henry husbandman 592654 592654 Gove, Henry, of North Tauton, husbandman 2
5569357 2525596 2525596 defendant Harry John smith 592654 592654 Harry, John, of North Tauton, smith 3
5575105 2527299 2527299 defendant Spynk Robert mercer 592654 592654 Spynk, Robert, of North Tauton, mercer 1
5575106 2527299 2527299 defendant Gove Henry husbandman 592654 592654 Gove, Henry, of North Tauton, husbandman 2
5575107 2527299 2527299 defendant Harry John smith 592654 592654 Harry, John, of North Tauton, smith 3
5583464 2529898 2529898 defendant Colles John esq 592654 592654 Colles, John, of North Tauton, esq 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);