names

57 rows where place_id = 592001

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3606270 1869628 1869628 defendant Walker Hugh clerk 592001 592001 Walker, Hugh, of Mereworth, clerk 0
3706568 1928339 1928339 defendant Jeffrey Thomas yeoman 592001 592001 Jeffrey, Thomas, of Mereworth, yeoman 1
3824669 1965590 1965590 defendant Bourman William yeoman 592001 592001 Bourman, William, of Mereworth, yeoman 0
3884899 1985221 1985221 defendant Tuck John husbandman 592001 592001 Tuck, John, of Mereworth, husbandman 4
3884905 1985222 1985222 defendant Turk John husbandman 592001 592001 Turk, John, of Mereworth, husbandman 4
3998062 2024065 2024065 defendant Alrooke John tanner 592001 592001 Alrooke, John, of Mereworth, tanner 2
4015688 2030309 2030309 defendant Raynes William gent 592001 592001 Raynes, William, of Mereworth, gent 0
4059094 2045649 2045649 defendant Waston John yeoman 592001 592001 Waston, John, of Mereworth, yeoman 0
4300386 2130239 2130239 defendant Brooke John tanner 592001 592001 Brooke, John, of Mereworth, tanner 0
4308668 2133182 2133182 defendant Baldock George miller 592001 592001 Baldock, George, of Mereworth, miller 0
4361716 2151346 2151346 defendant Parson William husbandman 592001 592001 Parson, William, of Mereworth, husbandman 2
4367194 2153326 2153326 defendant Bettes Robert yeoman 592001 592001 Bettes, Robert, of Mereworth, yeoman 0
4569536 2222057 2222057 defendant Sywardby John   592001 592001 Sywardby, John, of Mereworth 0
4569643 2222088 2222088 defendant Kynet John   592001 592001 Kynet, John, of Mereworth 0
4589848 2228190 2228190 defendant Godfrey Thomas   592001 592001 Godfrey, Thomas, of Mereworth 2
4622648 2238061 2238061 defendant Yonge John   592001 592001 Yonge, John, of Mereworth 0
4644485 2244472 2244472 defendant Yonge John   592001 592001 Yonge, John, of Mereworth 0
4649540 2245900 2245900 defendant Warere Walter   592001 592001 Warere, Walter, of Mereworth 1
4709210 2268248 2268248 defendant Tannere John husbandman 592001 592001 Tannere, John, of Mereworth, husbandman 0
4709213 2268249 2268249 defendant Tannere John husbandman 592001 592001 Tannere, John, of Mereworth, husbandman 0
4719542 2271454 2271454 defendant Cornemonger John husbandman 592001 592001 Cornemonger, John, of Mereworth, husbandman 0
4727899 2273968 2273968 defendant Bocher Thomas   592001 592001 Bocher, Thomas, of Mereworth, swyne libber or sow gelder 1
4736472 2276540 2276540 defendant Maydestan Thomas laborer 592001 592001 Maydestan, Thomas, of Mereworth, laborer 0
4750278 2280559 2280559 defendant Kyryell Bartholomew husbandman 592001 592001 Kyryell, Bartholomew, of Mereworth, husbandman 1
4759346 2283266 2283266 defendant Cornmonger John, sen husbandman 592001 592001 Cornmonger, John, sen, of Mereworth, husbandman 3
4759369 2283272 2283272 defendant Brown William weaver 592001 592001 Brown, William, of Mereworth, weaver 3
4818285 2301796 2301796 defendant Bradshawe Thomas yeoman 592001 592001 Bradshawe, Thomas, of Mereworth, yeoman 0
4849117 2311197 2311197 defendant Deye William husbandman 592001 592001 Deye, William, of Mereworth, husbandman 0
4849119 2311198 2311198 defendant Deye William husbandman 592001 592001 Deye, William, of Mereworth, husbandman 0
4887485 2322924 2322924 defendant Cornemonger John, junior laborer 592001 592001 Cornemonger, John, junior, of Mereworth, laborer 0
4896899 2325683 2325683 defendant Partryche Robert husbandman 592001 592001 Partryche, Robert, of Mereworth, husbandman 2
4907256 2328832 2328832 defendant Partryche Robert husbandman 592001 592001 Partryche, Robert, of Mereworth, husbandman 2
4922284 2333387 2333387 defendant Hals Walter   592001 592001 Hals, Walter, of Mereworth, parson 0
4929587 2335667 2335667 defendant Hals Walter chaplain 592001 592001 Hals, Walter, of Mereworth, chaplain 0
5063902 2375736 2375736 defendant Chamberleyn Robert husbndman 592001 592001 Chamberleyn, Robert, of Mereworth, husbndman 1
5080829 2380757 2380757 defendant Chamberlayne Robert yeoman 592001 592001 Chamberlayne, Robert, of Mereworth, yeoman 0
5092268 2384121 2384121 defendant Chambyrlayn Robert yeoman 592001 592001 Chambyrlayn, Robert, of Mereworth, yeoman 0
5128297 2394753 2394753 defendant (illegible) (illegible) husbandman 592001 592001 ---, ---, of Mereworth, husbandman 1
5147386 2400381 2400381 defendant Wylmot Richard husbandman 592001 592001 Wylmot, Richard, of Mereworth, husbandman 1
5153608 2402207 2402207 defendant Taylor Thomas smith 592001 592001 Taylor, Thomas, of Mereworth, smith 0
5167117 2406115 2406115 defendant Wylnot Richard husbandman 592001 592001 Wylnot, Richard, of Mereworth, husbandman 1
5182380 2410601 2410601 defendant Wilmot Richard husbandman 592001 592001 Wilmot, Richard, of Mereworth, husbandman 1
5206401 2417606 2417606 defendant Partrych Robert laborer 592001 592001 Partrych, Robert, of Mereworth, laborer 0
5210565 2418827 2418827 defendant Partrych Robert husbandman 592001 592001 Partrych, Robert, of Mereworth, husbandman 0
5325352 2452668 2452668 defendant Haccher Walter husbandman 592001 592001 Haccher, Walter, of Mereworth, husbandman 3
5369808 2466147 2466147 defendant Hatcher Walter husbandman 592001 592001 Hatcher, Walter, of Mereworth, husbandman 1
5369823 2466150 2466150 defendant Hatcher Walter husbandman 592001 592001 Hatcher, Walter, of mereworth, husbandman 1
5385911 2471043 2471043 defendant Hatthere Walter husbandman 592001 592001 Hatthere, Walter, of Mereworth, husbandman 0
5385912 2471043 2471043 defendant Hethere John husbandman 592001 592001 Hethere, John, of Mereworth, husbandman 1
5396004 2473940 2473940 defendant Cofte John butcher 592001 592001 Cofte, John, of Mereworth, butcher 3
5398101 2474524 2474524 defendant Hatcher John husbandman 592001 592001 Hatcher, John, of Mereworth, husbandman 0
5402812 2475881 2475881 defendant Elyot Robert laborer 592001 592001 Elyot, Robert, of Mereworth, laborer 1
5415752 2479650 2479650 defendant (illegible) Robert laborer 592001 592001 _, Robert, of Mereworth, laborer 1
5417068 2480017 2480017 defendant Taillour Roger   592001 592001 Taillour, Roger, of Mereworth, mason 0
5432209 2484602 2484602 defendant Elyot Robert laborer 592001 592001 Elyot, Robert, of Mereworth, laborer 0
5532427 2514683 2514683 defendant A Mere Roger smith 592001 592001 A Mere, Roger, of Mereworth, smith 4
5625794 2552012 2552012 defendant Yonge John farmer 592001 592001 Yonge, John, of Mereworth, farmer 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);