names

52 rows where place_id = 608604

✎ 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
3674418 1918043 1918043 defendant Stokys William clerk 608604 608604 Stokys, William, of Thyngden, clerk 2
3694183 1924386 1924386 defendant Walter Richard husbandman 608604 608604 Walter, Richard, of Thyngden, husbandman 0
3767322 1947424 1947424 defendant Tesdale Thomas husbandman 608604 608604 Tesdale, Thomas, of Thyngden, husbandman 0
3785091 1953123 1953123 defendant Tesdale Thomas husbandman 608604 608604 Tesdale, Thomas, of Thyngden, husbandman 0
3785093 1953124 1953124 defendant Tesdale Thomas husbandman 608604 608604 Tesdale, Thomas, of Thyngden, husbandman 0
3819120 1963871 1963871 defendant Silby Henry husbandman 608604 608604 Silby, Henry, of Thyngden, husbandman 0
3819121 1963871 1963871 defendant Walter Richard husbandman 608604 608604 Walter, Richard, of Thyngden, husbandman 1
4189055 2091660 2091660 defendant Marson Thomas yeoman 608604 608604 Marson, Thomas, of Thyngden, yeoman 0
4440547 2181956 2181956 defendant Tilbrok William   608604 608604 Tilbrok, William, of Thyngden 0
4477940 2193769 2193769 defendant Giles John   608604 608604 Giles, John, of Thyngden 2
4567514 2221397 2221397 defendant Byfeld John   608604 608604 Byfeld, John, of Thyngden 0
4567515 2221397 2221397 defendant Milner John chaplain 608604 608604 Milner, John, of Thyngden, chaplain 1
4610872 2234473 2234473 plaintiff Chaundeler William   608604 608604 Chaundeler, William, of Thyngden 0
4691129 2262745 2262745 defendant Abraham Richard   608604 608604 Abraham, Richard, of Thyngden 1
4761062 2283811 2283811 plaintiff Deye John   608604 608604 Deye, John, of Thyngden 0
4767520 2285819 2285819 defendant Deye Robert husbandman 608604 608604 Deye, Robert, of Thyngden, husbandman 1
4767521 2285819 2285819 defendant Abraham John husbandman 608604 608604 Abraham, John, of Thyngden, husbandman 2
4767524 2285819 2285819 defendant Pette John husbandman 608604 608604 Pette, John, of Thyngden, husbandman 5
4791882 2293564 2293564 defendant Dey Robert husbandman 608604 608604 Dey, Robert, of Thyngden, husbandman 3
4791885 2293564 2293564 defendant Abraham John husbandman 608604 608604 Abraham, John, of Thyngden, husbandman 6
4791886 2293564 2293564 defendant Pette John husbandman 608604 608604 Pette, John, of Thyngden, husbandman 7
4791887 2293564 2293564 defendant Henry Richard husbandman 608604 608604 Henry, Richard, of Thyngden, husbandman 8
4843470 2309476 2309476 defendant Weye Robert husbandman 608604 608604 Weye, Robert, of Thyngden, husbandman 2
4843471 2309476 2309476 defendant Pette William husbandman 608604 608604 Pette, William, of Thyngden, husbandman 3
4916004 2331506 2331506 defendant Chapman Thomas husbandman 608604 608604 Chapman, Thomas, of Thyngden, husbandman 0
4942014 2339485 2339485 defendant West John carpenter 608604 608604 West, John, of Thyngden, carpenter 0
5028647 2365255 2365255 defendant Dagoll Nicholas husbandman 608604 608604 Dagoll, Nicholas, of Thyngden, husbandman 0
5028648 2365255 2365255 defendant Whitlarke Thomas husbandman 608604 608604 Whitlarke, Thomas, of Thyngden, husbandman 1
5035070 2367119 2367119 defendant Cambrigge William mercer 608604 608604 Cambrigge, William, of Thyngden, mercer 1
5039517 2368467 2368467 defendant Shelston John husbandman 608604 608604 Shelston, John, of Thyngden, husbandman 2
5067649 2376818 2376818 defendant Cambrigge William husbandman 608604 608604 Cambrigge, William, of Thyngden, husbandman 0
5092979 2384335 2384335 defendant Smyth Robert chapman 608604 608604 Smyth, Robert, of Thyngden, chapman 0
5092981 2384336 2384336 defendant Smyth Robert chapman 608604 608604 Smyth, Robert, of Thyngden, chapman 0
5107829 2388724 2388724 defendant Tayllour Thomas drover 608604 608604 Tayllour, Thomas, of Thyngden, drover 1
5114465 2390629 2390629 defendant Taillour William tailor 608604 608604 Taillour, William, of Thyngden, tailor 1
5114466 2390629 2390629 defendant Lynne Thomas smith 608604 608604 Lynne, Thomas, of Thyngden, smith 2
5133315 2396233 2396233 defendant Brampton John   608604 608604 Brampton, John, of Thyngden 0
5153137 2402059 2402059 defendant Bryngton John husbandman 608604 608604 Bryngton, John, of Thyngden, husbandman 0
5170673 2407142 2407142 defendant Bryngton John husbandman 608604 608604 Bryngton, John, of Thyngden, husbandman 0
5183026 2410780 2410780 defendant Taillour William tailor 608604 608604 Taillour, William, of Thyngden, tailor 4
5188485 2412351 2412351 defendant Plowright William, sen yeoman 608604 608604 Plowright, William, sen, of Thyngden, yeoman 1
5188486 2412351 2412351 defendant Overton William husbandman 608604 608604 Overton, William, of Thyngden, husbandman 2
5188491 2412352 2412352 defendant Plowright William, sen yeoman 608604 608604 Plowright, William, sen, of Thyngden, yeoman 1
5188492 2412352 2412352 defendant Overton William husbandman 608604 608604 Overton, William, of Thyngden, husbandman 2
5192082 2413413 2413413 defendant Plowryght William, sen husbandman 608604 608604 Plowryght, William, sen, of Thyngden, husbandman 0
5203680 2416828 2416828 defendant Taillour William tailor 608604 608604 Taillour, William, of Thyngden, tailor 4
5207611 2417967 2417967 defendant Plowright William, sen husbandman 608604 608604 Plowright, William, sen, of Thyngden, husbandman 0
5286535 2441070 2441070 defendant Brounesden William chaplain 608604 608604 Brounesden, William, of Thyngden, chaplain 2
5286536 2441070 2441070 defendant Brounesden Roger baker 608604 608604 Brounesden, Roger, of Thyngden, baker 3
5498159 2504399 2504399 defendant Lythell Richard husbandman 608604 608604 Lythell, Richard, of Thyngden, husbandman 0
5498161 2504400 2504400 defendant Lythell Richard husbandman 608604 608604 Lythell, Richard, of Thyngden, husbandman 0
5616893 2549092 2549092 defendant Abraham John   608604 608604 Abraham, John, of Thyngden 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);